|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|
||||||||
|
|||||||||
|
|
|
|
Company
|
|
 SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
32-bit SYBASE/BDE CLIENT CONFIG
1) Basic BDE32/SQL Links32 connect and select test servers
2) Sybase Install
3) Example SQL.INI entries
4) BDE32/SQL Links 32 CONFIG
5) Errors/Solutions
6) MINIMUM CTLIB CLIENT INSTALL EXAMPLE
Current NET-LIB (Sybase 10.0.3)
Basic BDE32/SQL Links32 connect and select tests done in support on:
SYBASE SQL Server/4.2.2/P/Novell/NetWare386/1/OPT
SPX
SQL Server/10.0.2/P/Sun_svr4/OS 5.2/1/OPT
NT TCP/IP, NAMED PIPES
SYBASE SQL Server/10.0.2/P/PC Intel/NetWare/1/OPT
SPX
SQL Server/10.0.2/P/Sun_svr4/OS 5.2/1/OPT
TCP/IP
1)Run/Execute the Sybase client installation program
2)Add \sql10\dll to the dos path statement (C:\SQL10\DLL for example)
3)REBOOT client machine
4)Execute SQL_EDIT.EXE/DBEDIT.EXE or modify SQL10\INI\SQL.INI manually
Here are some example SQL.INI entries:
[mysybtcpsrvr]
QUERY=NLWNSCK,mysybstpsrvr, 5000
[MYSYESPXSRVR]
QUERY=NLNWLINK,10420022,1,83BD
[MYSYBNMPSRVR]
query=NLMSNMP,\\sqlnt351\pipe\sql\query
The network libraries specified above are as follows:
TCP/IP NLWNSCK.DLL
SPX NLNWLINK.DLL
NMPIPE NLMSNMP.DLL
SQL10\BIN\SYBPING.EXE can be used to verify that the
NETLIB settings for the servers specified in the SQL.INI
are correct and that the SYBASE server software responds
to a Sybase network ping.
If a SYBPING to a specific server is not sucessful then a
connection from a BDE client (DBD, Delphi, Paradox, dBASE,
etc.) will not be successful. You should verify the
installation and configuration of the Sybase client
software.
BDE32/SQL Links 32 CONFIG:
The only differences between the basic 16bit and 32bit
configuration are several additional config options for the
SQL Links drivers which includes a DLL32 option (set to
SQLSYB32.DLL for the Sybase driver.)
Starting w/default settings a Sybase BDE32 alias might have:
DATABASE NAME testdb
SERVERNAME mysybtcpsrvr
USER NAME mysybusername
Before connecting from a BDE32 client application at least a valid
Sybase server Password would be supplied for the above example.
Errors/Solutions
Error:
Vendor initialization failed.
Alias: MYALIASNAME
File:LIBSYBDB.DLL
Possible solution:
SQL10\DLL directory not in the dos path or the specified
file does not exist.
Error:
Cannot load an IDAPI service library.
Alias: MYSYBALIAS
File: SQLSYB32.DLL (or the dll name entered for DLL32)
Possible solution:
SQL Links is not installed (or incomplete) or the specified
dll does not exist.
Error:
Login failed.
Login incorrect.
Alias: MYSYBALIAS
Possible solution:
This error is being returned from the server and indicates
that the entered USER NAME and/or Password are not correct.
Error:
DBExplorer -
"General SQL error. SELECT permission denied on column
audflags of object sysobjects, database , owner dbo"
(The following solutions are temporary until the DB Explorer's default
behavior can be modified.)
solution 1 (preferred):
Add the following to Dbx.dbi file in the [Sybase] section:
dbo.sysobjects:Dataset1=name,id,uid,type,userstat,sysstat,crdate,
dbo.sysobjects:Dataset2=expdate,deltrig,instrig,updtrig,seltrig
solution 2:
GRANT select ON sysobjects TO public - which gives all users on
the system select privileges to all fields of the sysobject table.
MINIMUM CTLIB CLIENT INSTALL EXAMPLE:
Directory of C:\sql10
CHARSETS DIR 12-20-95 3:12p CHARSETS
BIN DIR 12-20-95 3:12p BIN
DLL DIR 12-20-95 3:12p DLL
INI DIR 12-20-95 3:12p INI
LOCALES DIR 12-20-95 3:12p LOCALES
Directory of C:\sql10\BIN
SQLEDIT EXE 32,768 10-21-94 4:14p SQLEDIT.EXE
SYBPING EXE 16,896 10-21-94 4:14p SYBPING.EXE
ISQL42 EXE 82,432 08-23-93 5:00p ISQL42.EXE
ISQL EXE 32,256 11-08-94 10:31a ISQL.EXE
4 file(s) 164,352 bytes
Directory of C:\sql10\CHARSETS
CP850 DIR 12-20-95 3:12p CP850
Directory of C:\sql10\CHARSETS\CP850
ALTDICT SRT 8,687 08-19-94 6:12p ALTDICT.SRT
ALTNOACC SRT 8,320 08-19-94 6:12p ALTNOACC.SRT
ALTNOCSP SRT 9,095 08-19-94 6:12p ALTNOCSP.SRT
BINARY SRT 606 08-19-94 6:12p BINARY.SRT
CHARSET LOC 4,615 08-19-94 6:12p CHARSET.LOC
DICTIONA SRT 8,238 08-19-94 6:12p DICTIONA.SRT
ESPDICT SRT 8,161 08-19-94 6:12p ESPDICT.SRT
ESPNOAC SRT 8,222 08-19-94 6:12p ESPNOAC.SRT
ESPNOCS SRT 8,139 08-19-94 6:12p ESPNOCS.SRT
NOACCENT SRT 8,288 08-19-94 6:12p NOACCENT.SRT
NOCASE SRT 8,768 08-19-94 6:12p NOCASE.SRT
NOCASE34 SRT 5,816 08-19-94 6:12p NOCASE34.SRT
NOCASEPR SRT 8,854 08-19-94 6:12p NOCASEPR.SRT
SCANDICT SRT 8,082 08-19-94 6:12p SCANDICT.SRT
SCANNOCP SRT 8,994 08-19-94 6:12p SCANNOCP.SRT
15 file(s) 112,885 bytes
Directory of C:\sql10\DLL
MSVCRT10 DLL 210,944 04-07-94 8:53a MSVCRT10.DLL
NLMSNMP DLL 8,192 10-21-94 3:35p NLMSNMP.DLL
NLNWLINK DLL 8,704 10-21-94 3:35p NLNWLINK.DLL
NLWNSCK DLL 7,168 10-21-94 3:35p NLWNSCK.DLL
LIBTCL DLL 57,344 10-21-94 10:46p LIBTCL.DLL
LIBCS DLL 47,104 10-21-94 10:43p LIBCS.DLL
LIBCT DLL 301,568 10-21-94 11:27p LIBCT.DLL
LIBINTL DLL 34,816 10-21-94 10:36p LIBINTL.DLL
LIBCOMN DLL 291,328 10-21-94 10:42p LIBCOMN.DLL
LIBSYBDB DLL 361,984 10-21-94 11:12p Libsybdb.dll
10 file(s) 1,329,152 bytes
Directory of C:\sql10\INI
SQL INI 465 12-21-95 11:41a SQL.INI
LIBTCL CFG 133 09-06-95 12:51p Libtcl.cfg
2 file(s) 598 bytes
Directory of C:\sql10\LOCALES
ENGLISH DIR 12-20-95 3:12p ENGLISH
LOCALES DAT 6,470 08-19-94 11:11a LOCALES.DAT
1 file(s) 6,470 bytes
Directory of C:\sql10\LOCALES\ENGLISH
CP850 DIR 12-20-95 3:12p CP850
Directory of C:\sql10\LOCALES\ENGLISH\CP850
CSLIB LOC 5,516 08-19-94 6:11p CSLIB.LOC
NLMSNMP LOC 1,733 08-19-94 6:11p NLMSNMP.LOC
NLNWLINK LOC 2,569 08-19-94 6:11p NLNWLINK.LOC
NLWNSCK LOC 2,157 08-19-94 6:11p NLWNSCK.LOC
COMMON LOC 2,799 08-19-94 6:11p COMMON.LOC
TCLLIB LOC 13,306 08-19-94 6:11p TCLLIB.LOC
6 file(s) 28,080 bytes
Total files listed:
38 file(s) 1,641,537 bytes
|
|
|
|
|||
|
|||||
|
|
||||
 |
|||||
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 19:27:04 EST |
|||||
