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,

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

"Yanjie Ren" <yren@cc3.com> wrote in message
news:c9f601c438fb$3ca46510$a001280a@phx.gbl...
> 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.

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!

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
>
>"Yanjie Ren" <yren@cc3.com> wrote in message
>news:c9f601c438fb$3ca46510$a001280a@phx.gbl...
>> 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.
>
>
>.
>

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.