Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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