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.