🚀 go-pugleaf

Hi,
I am having problems using TADOConnection objects in my application.I have a form having a ADOConnection object.Several DataSets use this connection
object.In my application at run time when I select a different database to connect to, I close the ADOConnection, change the connectionString with
information about the new database and set the ADOConnection's connected  property to true.This sometimes connects to the new data base
and sometimes fails.I get the following error.

General SQL Error: [Sybase][ODBC Driver][Adaptive Server Anywhere] unable to connect to database server.Database server not Running.

BDE Error: 13059.

I am using Sybase SQL Anywhere ver 6.0.3 and Borland C++ Builder Professional with ADOExpress.

Another observation is that I am not able to make 3-4 connections to different databases using Borland Database Explorer or
Sybase central.I have about 3 different sybase SQL servers running on my network.I end up getting the above error message
when I am connection to the 3rd or the 4th database.Is there any limit on the number of simoultaneous connections that can
be held .If so how is this configurable.

Any help is welcome.

Thanks,
Arun kumar.