General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Hi Christian
Thanks for the reply. The CA opens the table all fine. I update and do changes - No problem. When I exit the connection is still active and it stays active. I see James says that I can set a timeout on the ASA server but I would rather want to close the connection though my code.
I have added no code to disconnect the connection since I have added no code to open the connection except for specifying the connection to be used.
>Hello,
>
>i know nothing about this ASA DB but the CursorAdapter itself (without additional code by you) will not make connections by itself .. you'll have to explicitly set CursorAdapter.DataSource to either a valid connection handle returned from SQLCONNECT/SQLSTRINGCONNECT or with a ADODB.Connection object
>
>i would check your CA class code, and if it calls SQL(STRING)CONNECT or instantiates ADO Connection objects, verify if a corresponding SQLDISCONNECT() is called or that the ADO Connection object is explicitly destroyed
>
>
>
>Regards
>Christian
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only