SQLWindows 5.0.3 connecting to Windows 2000 Server

comp.databases.gupta (1995-2015)
Scott Ashby

SQLWindows 5.0.3 connecting to Windows 2000 Server

Post by Scott Ashby » 29 Jan 2003, 23:24

 Posted by:  Scott...@SMNA.com (Scott Ashby) 

Folks,

We have an application developed by a third party using SQLWindows
5.0.3. It connects at the present time to a SQL Server 6.5 database
server. We'd like to eliminate the 6.5 server, and have the app use a
SQL Server 2000 database instead. We've ported the database with no
problems, and would like to point the application to use the new
server instead of the old one. Does anyone out there have any first
hand experiences with doing something similar to this? We think the
changes should be confined to SQL.INI. I'm including a copy of our
SQL.INI for your reference...

Here it is:

[dbwservr]
servername=SBSLOCAL
locktimeout=2
directio=0
dbdir=C:SQLBASE

[winclient]
clientname=WinUser
;DEFAULTUSER=hris
;DEFAULTPASSWORD=
;DEFAULTDATABASE=

[winclient.dll]
;comdll=sqlwsv
comdll=sqlsqsw
;comdll=sqlodbw
;comdll=sqlwsv

[winclient.sqsw]
log=C:SQLBASELOGsqlsqsw.log

[ODBCrtr]
ferslong=off

[sqsgtwy]
remotedbname=hris,SERVER01,hris
remotedbname=hrist,SERVER01,hrist
remotedbname=hrisye,SERVER02,hrisye
mapgticursors=on
sybautocommit=on
enhancedcursors=on
yieldonservercall=0
locktimeout=0
longbuffer=4095
maperror=off
displaybinaryashex=off
checkexists=off
sybapplicationname=@appname
sybworkstationname=@appname

Incidentally, I'm trying to setup a new client for testing purposes,
and right now, I get an error everytime I attempt to run the client.
It is complaining about not being able to find the sqlsqsw.dll file,
but I have it in my Windows directory, and that is in my path...

The SQL 2000 box is capable of supporting either TCP/IP or Named pipes
for its connection. If I need to provide any additional information,
drop me a line...


Thanks in advance,

Scott Ashby
DBA
Swedish Match North America

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 0 guests