4 replies to this topic

[gil]

On setup I selected SQL SERVER as the default db. I have a DNS setup of one of the databases I have created. I am able to access this db via PRO-IV. However, I need to access another SQL SERVER db at the same time withing the same application. How is this done?
Thank you.

[gil]

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

Edited by gil, 17 April 2005 - 10:42 AM.

[Chris Mackenzie]

you can define different Logical Databases in the proiv.ini file so long as they are
available via at least odbc. Search this site or the P4 manuals for more info

[Richard Bassett]

Also, remember to be clear about whether you need coordinated transaction processing (ie. two-phase commit).
I don't know if you can get that with SQL/Server and ProIV.

[gil]

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