General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>How do you test connection?
>>Mark,
send a empty string.
>>
>>From you description my assumption is you are not getting this error all the time but are getting disconnected. I have a connection object that I use to handle this situation. When I get an error like this I first test the existing connection to see if it is valid. If it is not valid then I will connect again to the database and try the query again. If the connection is valid then I assume that there is a problem with the query and report the error.
>>
>>
>>>I am gettng the following error:
>>>Connectivity error: [Microsoft][ODBC SQL Server Driver]Communication link failure
>>>I am thinking to design a reprocess mechanisn to increase an efficiency of SQL execution. I am also thinking to have that mechanism disconnecting from SQL first, even connection handle is a valid one. And then connect back and execute. Does that look correct?
>>>
>>>Thanks
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