[freetds] freetds / IBM UniVerse
Perry Taylor
perryft at hotmail.com
Fri Jan 12 08:09:08 EST 2007
The odbc configuration for UniVerse makes reference to the path to the
libraries which in my case is set to /usr/local/freetds/lib. According to
IBM, UniVerse looks there for libodbc.so. On my installation libodbc.so is
as symbolic link to libtdsodbc.so.
Is this a problem?
Thanks.
Perry
>From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio at vodafone.com>
>Reply-To: FreeTDS Development Group <freetds at lists.ibiblio.org>
>To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
>Subject: Re: [freetds] freetds / IBM UniVerse
>Date: Fri, 12 Jan 2007 11:54:33 +0100
>
> >
> > 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
>
>Oppps... I just realized that our driver is not libodbc.so.... is called
>libtdsodbc.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.
> >
>
>bye
> freddy77
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
_________________________________________________________________
>From photos to predictions, The MSN Entertainment Guide to Golden Globes has
it all. http://tv.msn.com/tv/globes2007/?icid=nctagline1
More information about the FreeTDS
mailing list