Re: Excel 2007 -> ODBC -> SQL2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Peter,

Thanks for the help with this.

It's more like an Excle/office related issue that you should post in Excel
newsgroup.

As I said, I tested it outside Excel using the MSQUERY client. I would not expect the normal users of Excel groups to know how to solve "Protocol Error in TDS Stream". That's why I posted it here as an SQL client issue...

Based on my experience, after you create a connection to SQL Server in
Excel "Data" tab, and you click "Existing Connection"->Open

In "Import data" dialog, click Properties->Definition, and select "Edit
Query" you shall be able to edit the query.

There are two problems with this.

1. This option allows users to import the WHOLE result set without going through the GUI wizard first. It's very unintuitive too.
2. The "Edit Query" button is grayed out in my tests on existing connections, not sure why.

But none of this really helps to troubleshoot why I'm getting problems with TDS stream while using ODBC, which I believe is an issue with the SQL client components.

--
Gerry Hickman
London (UK)

.

Quantcast