Jump to content


gil

Member Since 13 Apr 2005
Offline Last Active Apr 20 2005 02:00 PM
-----

Posts I've Made

In Topic: SQL SERVER

18 April 2005 - 10:11 AM

Thank you. The change to the CONNECTION string seems to do the trick.
(from)
[DATABASE - SQL2000B]
FILETYPE=SQLSERVE
PRODB_CHARSET=7
CONNECTION=usr1/password

(to)
[DATABASE - SQL2000B]
FILETYPE=SQLSERVE
PRODB_CHARSET=7
CONNECTION=usr1/password/SQL200B

In Topic: SQL SERVER

17 April 2005 - 10:38 AM

Help Still Needed !!

Can someone please tell me how to connect to 2 seperate sql 2000 databases. The default db is SQLSERVE.
I have 2 DNS settings: SQL2000A and SQL2000B. THANK YOU !!

[ENVIRONMENT]
SQL_DBTYPE=SQLSERVE
SQLSERVE_SELECT_FOR_UPDATE=TRUE
SQL_DBNAME=SQL2000A

[CLIENT32]
[DATABASE - SQLDEFAULT]
FILETYPE=SQLSERVE
PRODB_CHARSET=7
CONNECTION=usr1/password

[DATABASE - SQL2000B]
FILETYPE=SQLSERVE
PRODB_CHARSET=7