Two Database in one Centura File

[vikram]

 Posted by:  vikram 

Hi can we connect to two databases in one Centura code file ?

Regards
Vikram

[Jim McNamara]

 Posted by:  Jim McNamara 

This is pretty basic - have you RTFM?

[Jeff Luther]

 Posted by:  Jeff Luther 

You declare 2 Sql Handles, assign your SqlDatabase et al parameters
for the 1st database and invoke SqlConnect( hSqlOne ).

Assuming it connects ok assign, assign your SqlDatabase et al parameters
for the 2nd database and invoke SqlConnect( hSqlTwo ).

Be sure to SqlDisconnect() both handles before or when your application
terminates. And be sure to read the TD and other online PDF books, and
look at the samples. I have a link on my page below if you do not have
the books installed on your machine.

Best Regards,
Jeff @ PC Design
info. & samples: www.JeffLuther.net/gupta/

[Alberto Aviles]

 Posted by:  Alberto Aviles 

i recomend this !!!

if u have 2 or more DB servers u can't use "ALL DATABASES" u have to named
one by one

serverpath=HGDB,xx.xx.xx.xx/db1,db2
serverpath=XYZ,xx.xx.xx.xx/db5,db20