Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
How do you test connection?
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement