[freetds] FreeTDS and unixODBC issues on Mac OS X
Paul Thurston
pthurston at netegrate.com
Sat May 15 22:39:45 EDT 2010
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
More information about the FreeTDS
mailing list