[freetds] Unable to connect to MySQL database

Bill Endter bill_e at mail.arc.nasa.gov
Thu Jul 22 16:40:56 EDT 2004


    Thank you Paul for the explanation and the link. I did not realize there was a big difference between
MySQL and Microsoft SQL.  We use FreeTDS to connect to Sybase servers and it works great.

            Bill

"Bort, Paul" wrote:

> Everyone else on the list is free to correct me, but I think the problem is
> that you're using the completely wrong protocol.
>
> The "TDS" in FreeTDS stands for "Tabular Data Stream", a protocol developed
> by Sybase (and used/modified by Microsoft) for client-server database
> communications.
>
> Doing a quick Google search, I can't find any evidence that MySQL
> understands the TDS protocol at all.
>
> Unless you're trying to connect to a Sybase ASA or ASE server, or a
> Microsoft SQL server, FreeTDS won't help you.
>
> I found the following link discussing the MySQL protocol, perhaps it will
> help: http://www.redferni.uklinux.net/mysql/MySQL-Protocol.html
>
> Good Luck.
>
> > -----Original Message-----
> > From: Bill Endter [mailto:bill_e at mail.arc.nasa.gov]
> > Sent: Thursday, July 22, 2004 4:17 PM
> > To: freetds at lists.ibiblio.org
> > Subject: [freetds] Unable to connect to MySQL database
> >
> >
> >
> >     We have a MySQL database server running on a MAC.  I
> > cannot get a connection using FreeTDS tsql.  We are
> > using FreeTDS version 0.63.dev.20040507 (also tried 0.62.4)
> > on a Solaris 8 server.  The error received is
> > "Unknown marker".  We can connect successfully using the
> > mysql test program from mysql.com.  We have tried TDS
> > Version 7.0 and 8.0.  Can anyone explain what is happening
> > and how to fix the problem?
> >
> >             Thanks,
> >
> >             Bill
> >
> > >From freetds.conf:
> >
> > # SQL Testing
> > [SQLTEST]
> >         host = xxxxxx.arc.nasa.gov
> >         port = 3306
> >         tds version = 7.0
> >
> >
> > Here is the log:
> >
> > Starting log file for FreeTDS 0.63.dev.20040507
> >         on 2004-07-21 11:06:20 with debug level 99.
> > names for ISO-8859-1: ISO8859-1
> > names for UTF-8: UTF-8
> > names for UCS-2LE: UCS-2LE
> > names for UCS-2BE: UCS-2BE
> > iconv to convert client-side data to the "646" character set
> > 11:06:20.311516 tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
> > 11:06:20.312603 tds_iconv_info_init: converting
> > "ISO-8859-1"->"UCS-2LE"
> > 11:06:20.312704 Connecting to 128.102.0.1 port 3306, TDS 7.0.
> > 11:06:20.316094 tds_put_string converting 22 bytes of
> > "xxxxxxxxx.arc.nasa.gov"
> > 11:06:20.316201 tds_put_string wrote 44 bytes
> > 11:06:20.316254 tds_put_string converting 5 bytes of "xxxxx"
> > 11:06:20.316307 tds_put_string wrote 10 bytes
> > 11:06:20.316368 tds_put_string converting 4 bytes of "TSQL"
> > 11:06:20.316423 tds_put_string wrote 8 bytes
> > 11:06:20.316472 tds_put_string converting 7 bytes of "SQLTEST"
> > 11:06:20.316525 tds_put_string wrote 14 bytes
> > 11:06:20.316575 tds_put_string converting 11 bytes of "TDS-Library"
> > 11:06:20.316629 tds_put_string wrote 22 bytes
> > 11:06:20.316715 tds_put_string converting 10 bytes of "us_english"
> > 11:06:20.316771 tds_put_string wrote 20 bytes
> > 11:06:20.316820 tds_put_string wrote 0 bytes
> > 11:06:20.317063 tds_process_login_tokens()
> > Received header @ 11:06:20.317240
> > 0000 2b 00 00 00 0a 34 2e 30-                        |+....4.0|
> >
> >
> > 11:06:20.317341 looking for login token, got  0()
> > 11:06:20.317394 tds_process_default_tokens() marker is 0()
> > 11:06:20.318873 tds_client_msg: #20020: "Unknown marker".
> > Connection state is now 0.
> > Unknown marker: 0(0)!!
> > 11:06:20.319352 tds_client_msg: #20014: "Login incorrect.".
> > Connection state is now 0.
> > 11:06:20.319435 tds_free_all_results()
> >
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list