Microsoft Access Query generate tds error

I'm using Access 2010, with a SQL Server 2008 R2 server as the backend. I'm trying to run some Access queries which ran fine in the past. But today, I'm getting 2 types of errors:

"tds buffer length too large"  and "protocol error in TDS stream"

I'm using ODBC to connect to the data; I can open the tables locally with no problem. But when I run the queries, it throws these errors. It is happening across 3 separate Access apps (all of which were running fine last week).

I've searched the internet, with not significant results.

Any suggestions?
rlwhitneyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Nope.  Does 'tds' ring any bells?
0
rlwhitneyAuthor Commented:
According to what I see on the internet, "TDS stands for Tabular Data Stream and is the underlying protocol that SQL Server uses to return results to clients," There are also lots of "hits" when I post the error.
0
Jeffrey CoachmanMIS LiasonCommented:
As this was working fine till today, have a look at any MS Windows, MS Office, or SQL updates that may have been installed automatically recently.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

rlwhitneyAuthor Commented:
Checked updates on both the server and my workstation.

Checked MS Updates on my PC
The most recent updates were 10/9/13; things have worked after that.

Checked MS Updates on my VISUAL653
The most recent updates were 10/12/13; things have worked after that.

So does not appear to be an update issue.
0
Jeffrey CoachmanMIS LiasonCommented:
Have you tried relinking the tables?

Also try running the compact/repair utility.

At the extreme end, Create a new database and import all the objects.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rlwhitneyAuthor Commented:
This issue can be closed.
0
Jeffrey CoachmanMIS LiasonCommented:
Just for clarity, ...which of my three suggestions cleared up the issue?
0
rlwhitneyAuthor Commented:
I was getting some errors on my workstation from Symantec Endpoint Security (our corporate anti-virus package). I hadn't done any recent Microsoft updates, but had just done a Symantec Endpoint Security update. As I had an older version, I decided I'd un-install the current version, then install the updated version. While I was researching this TDS issue, I un-installed Symantec Endpoint Security. When I tried the database again, the TDS error was gone. I'm assuming that since Symantec Endpoint Security monitors network traffic, a problem with Symantec Endpoint Security was the issue. I'm speculating that the SES update, on top of the older SES package, broke something.

At any rate, the TDS issue is gone. I haven't installed the latest SES yet. Tonight, I'll backup my system, then install it, and re-test.
0
Jeffrey CoachmanMIS LiasonCommented:
Then it seems that you solved your own issue here.

Pleas click the "request Attention" link and ask that your post above be selected as the solution.

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.