FreeTDS Development Group

[Paul Thurston <pthurston AT netegrate.com>]

Vinh:

Also, osql is finding more than one error in your set-up.
You'll probably want to correct both of the issues in order to get ODBC up 
and running.

1) invalid IP address - this is due to a configuration error in odbc.ini.
2) missing strings directory - looks like a potential build time/installation 
time issue.

Try adjusting your settings here.
The "good" osql output should look like the output here:
http://www.freetds.org/userguide/odbcdiagnose.htm#WITH.UNIXODBC

In the example above, the relationship between freetds.conf and odbc.ini is 
displayed, which should help you get things set-up.

Best,


Paul



From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Vinh Nguyen
Sent: Saturday, May 15, 2010 1:54 PM
To: FreeTDS Development Group
Subject: [freetds] FreeTDS and unixODBC issues on Mac OS X


Dear list,



First, let me know if I should contact unixODBC instead and sorry for the 
inconvenience.



After getting the locale issue of FreeTDS resolved (thanks to you guys, 
specifying v8.0 works now), I'm trying to get the two working together on my 
Mac OS X, both compiled from source.  tsql (I use it through bsqldb for 
batch) works.  However, I get the following when issuing isql:



[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source 
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.

[ISQL]ERROR: Could not SQLConnect



A TDSDUMP yields

log.c:196:Starting log file for FreeTDS 0.83.dev.20100504

        on 2010-05-15 10:34:22 with debug flags 0x4fff.

iconv.c:337:tds_iconv_open(0x10010c210, ISO-8859-1) iconv.c:197:local name 
for ISO-8859-1 is ISO-8859-1 iconv.c:197:local name for UTF-8 is UTF-8 
iconv.c:197:local name for UCS-2LE is UCS-2LE iconv.c:197:local name for 
UCS-2BE is UCS-2BE iconv.c:365:setting up conversions for client charset 
"ISO-8859-1"

iconv.c:367:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion 
iconv.c:408:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion

iconv.c:411:tds_iconv_open: done

util.c:337:tdserror(0x100108540, 0x10010c210, 20013, 0) odbc.c:2118:msgno 
20013 20003

util.c:367:tdserror: client library returned TDS_INT_CANCEL(2)

util.c:390:tdserror: returning TDS_INT_CANCEL(2) login.c:421:IP address 
pointer is empty login.c:423:Server SYBASE not found!

mem.c:615:tds_free_all_results()

error.c:412:odbc_errs_add: "Unable to connect to data source"

error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0, 0x7fff5fbfd6b4, 
0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)

error.c:562:_SQLError: "Unknown host machine name."

error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0, 0x7fff5fbfd6b4, 
0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)

error.c:562:_SQLError: "Unable to connect to data source"

error.c:584:SQLError(0x0, 0x10010bbf0, 0x0, 0x7fff5fbfd6a0, 0x7fff5fbfd6b4, 
0x7fff5fbfdea0, 513, 0x7fff5fbfd6be)

odbc.c:3883:SQLFreeConnect(0x10010bbf0)

odbc.c:3855:_SQLFreeConnect(0x10010bbf0)

odbc.c:3906:SQLFreeEnv(0x100101e40)

odbc.c:3893:_SQLFreeEnv(0x100101e40)

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source 
[01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name.

[ISQL]ERROR: Could not SQLConnect



If i do "osql -S adrc -U name -P password", I get the following at the end:

checking shared odbc libraries linked to isql for default directories...

/usr/local/bin/osql: line 53: ldd: command not found

strings: can't open file:  (No such file or directory)

osql: problem: no potential directory strings in "/usr/local/bin/isql"

osql: advice: use "osql -I DIR" where DIR unixODBC\'s install prefix e.g. 
/usr/local isql strings are:

checking odbc.ini files

        reading /Users/vinh/.odbc.ini

[adrc] found in /Users/vinh/.odbc.ini

found this section:

        [adrc]

        Driver=/usr/local/lib/libtdsodbc.so

        Description=adrc

        Trace=No

        ##servername=adrc

        Server=SERVERIP

        Port=1433

        TDS_Version=8.0

        Database=IBADataDictionary



looking for driver for DSN [adrc] in /Users/vinh/.odbc.ini

  found driver line: "  Driver=/usr/local/lib/libtdsodbc.so"

  driver "/usr/local/lib/libtdsodbc.so" found for [adrc] in .odbc.ini found 
driver named "/usr/local/lib/libtdsodbc.so"

/usr/local/lib/libtdsodbc.so is an executable file "Server=SERVERIP" found, 
not using freetds.conf Server=SERVERIP is ""

osql: no value found for "Server=SERVERIP" entry in .odbc.ini





Why is the IP string empty?



Thanks.

Vinh

_______________________________________________

FreeTDS mailing list

FreeTDS AT lists.ibiblio.org<mailto:FreeTDS AT lists.ibiblio.org>

http://lists.ibiblio.org/mailman/listinfo/freetds