Post reply

Connection Failed error

  • 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

  • April 1, 2002 at 10:48 am

    #426367

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

    Steve Jones

    steve@dkranch.net

  • April 1, 2002 at 11:00 am

    #426368

    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

  • April 1, 2002 at 9:54 pm

    #426412

    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

  • April 2, 2002 at 5:40 am

    #426427

    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)

  • April 2, 2002 at 7:03 am

    #426435

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

    thank you

    Mark

  • April 2, 2002 at 11:42 am

    #426461

    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

  • April 3, 2002 at 2:07 pm

    #426558

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

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

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