Interbase Quick Reference (16bit client) Example connect strings TCP/IP srvr:/usr/interbase/examples/atlas.gdb NETBEUI \\srvr\c:\ibserver\sample\ib4samp.gdb SPX srvr_info@area2:data\info.gdb *If you have installed both the Interbase 4.0 client utilities and Local Interbase Server utilities please see the note at the bottom of this document. 1. In all cases the Borland SQL Link must be installed on the client, 1.0 SQL Link 1.0 for Paradox 1.0/4.5 2.0 SQL Link for Paradox 5.0/dBASE 5.0 2.5 SQL Link for Delphi 1.0 2. The local Hosts file must contain the above IP address's and Interbase host names for example: xxx.xxx.xxx.xxx myibsrvr 3. The local SERVICES file must contain a line containing: gds_db 3050/tcp 4. Netbeui/named pipes requires an NT or Windows for Workgroups client. If using netbeui to connect to the NT server you must have a valid login on the NT machine and be logged in (a TCP/IP connection is just like any other to Interbase). 5. If using the TCP/IP protocol on top of Netware an ODI stack must be used. For example: C:\NET\LSL C:\NET\3C5X9 (this file is network card dependant) C:\NET\IPXODI C:\NET\NETX 6. Interbase DB and Netlib files: SQL Link 1.0 and 2.0 (files must be in dos path): gds.dll remote.dll SQL Link 2.5 and Local Interbase (files must be in dos path): gds.dll remote.dll iutls.dll WIN.INI setting for Interbase 4.0 and Local Interbase (SQL-Link 2.5 and above) note: previous to the SQL-Link 2.5 Interbase driver used a DOS environment variable in place of the WIN.INI entry. [Interbase] RootDirectory=C:\IBLOCAL *Please note: Interbase client utilities exist for both the Interbase 4.0 server and the LIBS (Local Interbase Server; installed by Delphi C/S for example) Currently the client utilities for Interbase 4.0 server are not "aware" of the Local Server which may cause file version conflicts if installed following an install of LIBS. Pay close attention to the 1)WIN.INI setting, 2)versions of the IB utilities and 3)the IB DB and net library versions: 1)the WIN.INI setting [Interbase] RootDirectory=C:\IBLOCAL This will vary according to the client install and specifies where the IB client will find the .msg file, etc. 2)The versions/locations of WISQL.EXE and IBMGR.EXE. Generally you will find the IB4.0 server utilities in the \INTERBAS\BIN directory and the LIBS aware utilities in the \IBLOCAL\BIN directory. 3)As mentioned above the files gds.dll, remote.dll, iutls.dll (IUTLS.DLL is provided with the LIBS aware utilities only) should be in the DOS path or in the \WINDOWS or \WINDOWS\SYSTEM directory and should be the versions installed with the copies of the utilities that you've chosen to use (IB server or LIBS.) BEC 9.20.95 ID:CS0033