Skip to Content.
Sympa Menu

freetds - RE: [freetds] Unable to connect to MySQL database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bort, Paul" <pbort AT tmwsystems.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Unable to connect to MySQL database
  • Date: Thu, 22 Jul 2004 16:28:36 -0400

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
>




Archive powered by MHonArc 2.6.24.

Top of Page