[freetds] freetds / IBM UniVerse

Perry Taylor perryft at hotmail.com
Wed Jan 3 14:20:26 EST 2007


I have built and installed unixodbc and freetds on our RHEL3 server. I have 
been able to successfully connect to our SQL Server using both isql and 
tsql.  However when I try to connect from within our IBM/UniVerse database 
environment I get the following error message...

SQLConnect error:   Status = -1   SQLState = S1000   Natcode = 0
[ODBC] [FreeTDS][SQL Server]Unable to connect to data source

Here is a statement from IBM support on how they implement their ODBC api, 
BCI ...

-------

When you use BCI to connect to an ODBC driver, all we do is go to the driver 
manager, the odbclib that's defined, and the driver manager takes care of 
the rest. If CONNECT finds the driver manager, that's all the CONNECT 
command is supposed to do. From there, it's the driver manager and driver's 
responsibility to find whatever the driver needs and make the connection.

The error shows BCI successfully found the driver manager. In the error: 
[ODBC][FreeTDS][SQL Server]Unable to connect to data source from left to 
right BCI, we found the driver manager [FreeTDS], which then found its SQL 
Server driver, [SQL Server]. BCI is not aware of what you are using so 
that's how we know who's driver you are using and that we found it. The 
"Unable to connect to data source" is coming from the FreeTDS SQL Server 
driver rather than BCI.

----

Additionally IBM support has indicated that others have reported similar 
troubles using freetds with UniVerse.  However, since they do not support 
the odbc driver/manager they offer little more in the way of help other than 
to say to contact the driver support facilities.

When I enable TDSDUMP and here is what I get...

util.c:288:Starting log file for FreeTDS 0.64
        on 2007-01-03 12:00:49 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character 
set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
login.c:209:IP address pointer is empty
login.c:211:Server SYBASE not found!
mem.c:519:tds_free_all_results()

I'm completely baffled as to why it would even be looking for a server named 
"SYBASE".  Here is my /usr/local/etc/odbc.ini...

[root at devuv1 trax]# cat /usr/local/etc/odbc.ini
[ODBC Data Sources]
SQL1            = MS SQL Server Driver

[SQL1]
Driver          = /usr/local/freetds/lib/libodbc.so
Description     = sql1 cueball database
#Servername     = SQL1
Database        = cueball
Server          = devsql1
Port            = 1433
TDS_Version     = 8.0

Any help you can offer will be greatly appreciated.

Sincerely,

Perry Taylor
Sr MV Architect
Zirmed, Inc.

_________________________________________________________________
Fixing up the home? Live Search can help 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG



More information about the FreeTDS mailing list