>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.