Using the MS SQL Server RDMS from IDL
MS SQL Server RDBMS
The Windows NT 4.0-based
Microsoft SQL Server 7.0 relational database management system will
be used for NSTX database work rather than the VMS-based INGRES
database system.
The host computer is an Intel machine named "Eagle".
Sybase OpenClient software links the VMS, Solaris and Digital UNIX
computers with SQL Server; ODBC (Open Database Connectivity) drivers,
which come with newer versions of the operating systems, link Macs and
Windows 95 and NT machines.
syb_entry_display
NSTX will have available MIT-developed X-windows interfaces to browse
entries in the new databases. CMOD's former "entry_display" application
has been ported to MS SQL Server; this version is currently known as
"syb_entry_display."
By default, syb_entry_display shows the most recent entries into the Logbook database.
The Logbook database at PPPL is currently loaded with sample entries from
CMOD. To access this or any other data on the (Windows NT) Microsoft
SQL Server relational database management system, each user must have
a separate account. Currently Tom Carroll is the only person putting up
accounts. Your VMS account username will be used.
To run the entry_display application on your X display,
$ @CARROLL$:[DSQL_MIT.SQLSHR]SETUP.COM
$ IDL
IDL> SET_PLOT, 'X'
IDL> SQL
IDL> SYB_ENTRY_DISPLAY
Some IDL definitions will be needed in your LOGIN.COM as well.
wlogbook
The wlogbook application is not yet available at PPPL.