Connection Failed error

Question

Post reply

Connection Failed error

mrd101

SSC Enthusiast

Points: 181
More actions
April 1, 2002 at 7:54 am

#78189

Hello all,
I receive this error it seems about 1 in 5 attempts when opening a dts package or saving a dts package or just opening up a table in enterprise manager.
Connection failied:
SQLState:'01000'
SQL Server Error:10060
[Microsoft][ODBC SQL SERVER DRIVER][TCP/IPSOCKETS]connection Open(PreLoginHandshake())
Connection failed:
SQLState 08001
SQL server error 11
[Microsoft][ODBC SQL SERVER DRIVER][TCP/IPSOCKETS]General network error. Check your network documentation.
this error is really annoying when i have worked a few hours on a dts package and then cannot save it.
any help would be greatly appreciated.
thanks
Mark

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738063 More actions · Answer 1

Sounds like a bad network connection. Do you ahve any other network issues with other apps?

Steve Jones

steve@dkranch.net

mrd101 SSC Enthusiast Points: 181 More actions · Answer 2

Sounds like a bad network connection. Do you ahve any other network issues with other apps?

Steve Jones

steve@dkranch.net

Steve, I have talked to IT and they are having no other problems. they seem to think its on the client side. We have been getting alot of timeout errors also. Maybe a slow network?

thanks

mark

K. Brian Kelley SSC Guru Points: 114703 More actions · Answer 3

I remember seeing a Knowledge Base article on this, but I'll have to search for it. Hopefully someone will find it before I do, but if not, I'll take a look for it at work tomorrow.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

K. Brian Kelley
@kbriankelley

Antares686 SSC Guru Points: 125444 More actions · Answer 4

I had this problem and for me it was related to the MDAC installed (may have been just one of the dlls not registered properly). When I reinstalled the problem went away.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

mrd101 SSC Enthusiast Points: 181 More actions · Answer 5

I have reinstalled the lastest mdac. I will see if this works.

thank you

Mark

K. Brian Kelley SSC Guru Points: 114703 More actions · Answer 6

There is an issue with MDAC 2.6 connecting to SQL Server 7:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300519

This wasn't the article I was thinking about, but it did stand out. I'll keep looking.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

K. Brian Kelley
@kbriankelley

mrd101 SSC Enthusiast Points: 181 More actions · Answer 7

2 days and no errors...yet. I think updating the mdac worked. I hope i havent just jinxed myself

Connection Failed error

Cookies on SQLServerCentral