>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') && Database pubs
SQLExec(lnHandle,'select * from authors')

Cetin