>I have problem with working my old aplications built for MS SQL6.5
>with MS SQL 7.
>Very often I started to see messages unpredicted ODBC error at casual places. I mean that I start code, it work OK, I start it again, it work Ok, and at last on the next run I see this message. Next time I see this message in different part of the program.
> I analized code and marked, that it happends when I ask few sequental queries sqlexe for one connection.
>What I did, I do connection , make query, close connection, open it again, do query and so on, error- dissapeared. What does it mean new
>bug in MS SQL7. I say it again, the code worked long time for MS SQL6.5 without any problems. It seams to me that sinchronous mode
>works like asinchorouns, and when I send new query, connection is still busy, or ODBC is not ready to get new query?
>Best wishes, Vladimir Zhuravlev.
You may want to increase the number of CommandTimeout property. Most probably you are using a newer ODBC driver for SQL 7 and/or newer version of ADO. That may explain why they behave differently. That does not explain the problem though.
Précédent
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