Intersolv ODBC drivers: cant connect
Quote:
>I've just installed the Intersolv ODBC drivers for Sybase 10.0.2., but when I
>try to connect to my server I get a warning message that says ...
>[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect():unable to get layer
>message string: unable to get origin message string:Error string not available
>I have the Open Client-Library installed on my PC and I can connect to the
>server using WDBPING, but I can't connect using the OpenDatabase command in VB.
>Any help is appriciated.
>Howard Ories
>(301) 236-3660
Pinging is sadly not enough. One thing that we found essential was to
get the SYBASE environment variables right, specifically ...
LANG=enu
whose absence caused a lot of problems. We have to run a batch file
called WSYBSET.BAT before loading Windows / NT.
REM Environment setup for Open Client for Windows
SET LANG=enu
SET SYBASE=C:\SQL10
SET DSQUERY=SYBASE.NT
SET PATH=C:\SQL10\BIN;C:\SQL10\DLL;%PATH%
SET LIB=C:\SQL10\LIB;%LIB%
SET INCLUDE=C:\SQL10\INCLUDE;%INCLUDE%
If you get the drivers working I'd be grateful if you could try
creating a snapshot/ dynaset & then using the Findfirst method. We've
never been able to get this to work.
If it does could you post the Intersolv version number your using.
Many Thanks, ChrisD
