>I connect to an sql server and my application needs at least three databases.
>Is it possible to have three running connections at one time or do I have to make a connection to each database everytime my application needs a particular database?
>
>
>Junjun
You could use SQLStringConnect and define no database. You could directly refer to a table with Database.Owner.TableName or switch database with use command. ie:
lnHandle = SQLStringConnect('Driver=SQL server;Server=servername;'+;
'Integrated Security=SSPI;')
SQLExec(lnHandle,'select * from Northwind.dbo.employees')
SQLExec(lnHandle,'use Pubs')
SQLExec(lnHandle,'select * from authors')
Cetin