May 31, 2006 at 7:11 am
Getting below error message when running a simple select to a table from Query analyser 2000 to a SQLServer 2000 running with SP4.
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
[Microsoft][ODBC SQL Server Driver]Invalid cursor state
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server
Any one faced this error? Any advise please,
June 1, 2006 at 7:37 am
Yes, unfortunately....I know that problem all too well. Apparently it's a problem with the network connection, according to various articles on the web. I generally just create a new connection in query analyzer and that takes care of the problem. Does anyone else have more info as I'd also like to understand what causes this vague error from time to time.
June 4, 2006 at 4:16 am
what is the query?
select * from <table> or something more complex.
It is consistent? Even if you open new connection it gives same error?
June 5, 2006 at 2:02 am
Got weird !
The problem occures iintermittently for the last two days. Now the problem got resolved by itself. I have not made any changes.
I'm sure it would be of network related problem. How can I narrow down and figure it out is that network drivers or network speed or whatever causing this problem?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply