>>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.
You are right. But I should have phrased my question better (in the title). I am trying to determine when the connection to the SQL Server was
used last time. And if I understand correctly the call to CursorFill() is when the application actually used the connection. My goal is to "stamp" this time and check for it next time the application uses the connection. If the time since the last connection use is greater than the ConnectionTimeOut I want the application to check if the connection is still valid. If not, create a new connection.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
