unknown token received from SQL Server

[Yanjie Ren]

One of my user tried to pull data out of SQL Server into
Excel sheet via Microsoft ODBC SQL Server driver. She got
the following error: ( The data volumn is small with 700
rows. )

[Microsoft][ODBC SQL Server Driver]Unknown token received
from SQL Server.

Has anybody had the same experience? Could you shed some
light on this?

Thanks.

[Dinesh T.K]

Yanjie,

Does this help?
'FIX: Err Msg "Unknown Token Received from SQL Server'
http://support.microsoft.com/default.aspx?id=151693

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com

Post by Yanjie Ren
One of my user tried to pull data out of SQL Server into
Excel sheet via Microsoft ODBC SQL Server driver. She got
the following error: ( The data volumn is small with 700
rows. )
[Microsoft][ODBC SQL Server Driver]Unknown token received
from SQL Server.
Has anybody had the same experience? Could you shed some
light on this?
Thanks.

[Yanjie Ren]

The article doesn't apply to what my user did. We have the SQL Server
2000. The user was trying to pull out data into an Excel sheet via ODBC.
(It's just a query. ) Sometimes, she could run it successfully. The
occurence of the error is not consistent.

Thanks.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[SqlJunkies User]

I received the same error using Excel and Microsoft Query in order to import the result set of a specific query into Excel.

I resolved the error by taking out a single line in the query that I had commented using "--" in SQL Query Analyzer. Apparently, the MS Query interface does not like the commented code.

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

[Sarah]

Can someone translate this into english? I have no idea
what forward-only, static, keyset, or dynamic cursors are.
But I still want to pull a table into Excel but I keep
getting this error.

Help please!
Sarah

-----Original Message-----
Yanjie,
Does this help?
'FIX: Err Msg "Unknown Token Received from SQL Server'
http://support.microsoft.com/default.aspx?id=151693
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com

Post by Yanjie Ren
One of my user tried to pull data out of SQL Server

into

Post by Yanjie Ren
Excel sheet via Microsoft ODBC SQL Server driver. She

got

Post by Yanjie Ren
the following error: ( The data volumn is small with

700

Post by Yanjie Ren
rows. )
[Microsoft][ODBC SQL Server Driver]Unknown token

received

Post by Yanjie Ren
from SQL Server.
Has anybody had the same experience? Could you shed

some

Post by Yanjie Ren
light on this?
Thanks.

.