>Hi,
>
>Say you are using CursorAdapter for getting and setting data in SQL Server. Do you know if the actual connection to the SQL server occurs when the application calls CursorFill() method of the CursorAdapter?
>
>And by the same token, when updating the SQL Server database, does the connection to SQL Server happens when the TableUpdate() is called?
>
>TIA
You must have opened connection in in order to call CursorFill(), no matter what is used ADO or ODBC.
The connection should stay opened during the lifetime of the CA.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.