Sybase driver and MSSQL 2k

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Martin Lukasik
    #1

    Sybase driver and MSSQL 2k

    Hi,

    I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
    server 2000.
    But unfortunately connection fails.
    In Event Log on my Win 2k3 SBS I'm getting the following error message:

    Error: 17832, Severity: 20, State: 7
    Connection opened but invalid login packet(s) sent. Connection closed.
    For more information, see Help and Support Center at
    http://go.microsoft.com/fwlink/events.asp.

    I tried to update SQL server to the lastest version; currently I'm using SP4
    but it still didn't resolve the problem.
    Has anyone got an idea what may be wrong?
    Application is written in perl, using DBD::Sybase

    Thanks,
    Martin


    Tags: None
    • Erland Sommarskog
      #2
      Re: Sybase driver and MSSQL 2k

      Martin Lukasik (marcin@milea.p l.i.hate.this.s pam) writes:[color=blue]
      > I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
      > server 2000.
      > But unfortunately connection fails.
      > In Event Log on my Win 2k3 SBS I'm getting the following error message:
      >
      > Error: 17832, Severity: 20, State: 7
      > Connection opened but invalid login packet(s) sent. Connection closed.
      > For more information, see Help and Support Center at
      > http://go.microsoft.com/fwlink/events.asp.
      >
      > I tried to update SQL server to the lastest version; currently I'm using
      > SP4 but it still didn't resolve the problem.
      > Has anyone got an idea what may be wrong?
      > Application is written in perl, using DBD::Sybase[/color]

      It is not likely to be a supported means of connection. Have you ever been
      able to get this combination to work?

      A guess is that the older the version of Sybase's DB-Library, the better
      the chances.

      Also, make sure that SQL Server is configured for SQL Server authentication.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • Mark T. Kennedy
          #3
          Re: Sybase driver and MSSQL 2k

          from linux, the freeTDS driver seems to work fine against sql server
          2005. caveat: i haven't tried anything other than simmple queries.

          /mark

          Erland Sommarskog wrote:[color=blue]
          > Martin Lukasik (marcin@milea.p l.i.hate.this.s pam) writes:[color=green]
          >> I'm using Sybase driver under Linux and I'm trying to connect to MSSQL
          >> server 2000.
          >> But unfortunately connection fails.
          >> In Event Log on my Win 2k3 SBS I'm getting the following error message:
          >>
          >> Error: 17832, Severity: 20, State: 7
          >> Connection opened but invalid login packet(s) sent. Connection closed.
          >> For more information, see Help and Support Center at
          >> http://go.microsoft.com/fwlink/events.asp.
          >>
          >> I tried to update SQL server to the lastest version; currently I'm using
          >> SP4 but it still didn't resolve the problem.
          >> Has anyone got an idea what may be wrong?
          >> Application is written in perl, using DBD::Sybase[/color]
          >
          > It is not likely to be a supported means of connection. Have you ever been
          > able to get this combination to work?
          >
          > A guess is that the older the version of Sybase's DB-Library, the better
          > the chances.
          >
          > Also, make sure that SQL Server is configured for SQL Server authentication.
          >
          >[/color]

            Comment

            Previous template Next
            Working...