>How do you test connection?

select 1 from [known table] where 1=2

>>Mark,
>>
>>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