Skip to Content.
Sympa Menu

freetds - [freetds] Unable to connect to MySQL database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bill Endter <bill_e AT mail.arc.nasa.gov>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Unable to connect to MySQL database
  • Date: Thu, 22 Jul 2004 13:17:20 -0700


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()






Archive powered by MHonArc 2.6.24.

Top of Page