[freetds] Unable to connect to MySQL database

Bort, Paul pbort at tmwsystems.com
Thu Jul 22 16:28:36 EDT 2004


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
> 



More information about the FreeTDS mailing list