Skip to Content.
Sympa Menu

freetds - Re: [freetds] isql configuration error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Зверев Виталий Борисович <VZverev AT genesis.spb.ru>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] isql configuration error
  • Date: Sat, 6 May 2006 12:41:46 +0400

Hello Terry,
Couldn't you try to replace in odbc.ini: "Server =
re-navi-test.fakedomainname" on "Servername = re_data_warehouse" ?

Sincerely yours.
-------------------------------------------------------
Vitaly Zverev, OCP DBA 8&8i
Oracle E-Business Suite &
Infiniband Linux Cluster Administrator
Genesis Ltd., St.Petersburg, Russia



> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Gau, Terry
> Sent: Saturday, May 06, 2006 3:24 AM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] isql configuration error
>
> Hi,
> I am new to FreeTDS and unixODBC, so please excuse my likely
> naive posting. I find lots of similar postings on google,
> but can't seem to find the solution for me.
> My ultimate goal is to connect to SQLServer from Oracle
> using Generic Connectivity.
>
> Facts:
> ------------------------
> Solaris 5.8
> freetds-0.63
> unixODBC-2.2.11
> Oracle 8.1.7.4
> SQLServer 2000 (domain login) (located in Europe)
>
> Configuration Files:
> ---------------------------
> $ odbcinst -j
> unixODBC 2.2.11
> DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA
> SOURCES: /usr/local/etc/odbc.ini USER DATA SOURCES..:
> /usr/local/lib/libodbc.so
>
> $ cat odbcinst.ini
> [FreeTDS]
> Description = v0.63 with protocol v8.0
> Driver = /usr/local/lib/libodbc.so
> UsageCount = 1
>
> [ODBC]
> Tracefile = /tmp/odbc.log
> Trace = Yes
>
> This freetds.conf file has been cleaned up considerable in an
> attempt to simplify things for me.
> $ cat freetds.conf
> [global]
> # TDS protocol version
> tds version = 8.0
>
> [re_data_warehouse]
> host = re-navi-test.fakedomainname
> database = re_data_warehouse
> port = 1433
>
> $ cat .odbc.ini
> [ODBC Data Sources]
> FreeTDS
> ODBC
> re_data_warehouse
>
> [FreeTDS]
> Description = v0.63 with protocol v8.0
> Driver = /usr/local/lib/libodbc.so
> UsageCount = 1
>
> [ODBC]
> Tracefile = /tmp/odbc.log
> Trace = Yes
>
> [re_data_warehouse]
> Description = MS SQLServer
> Server = re-navi-test.fakedomainname
> Database = re_data_warehouse
> Port = 1433
> TDS_Version = 8.0
>
> Behavior:
> ----------------------------------
> I am able to connect to SQLServer and run sql queries using
> both methods of tsql (-H and -S).
>
> isql fails with...
> $ isql -v re_data_warehouse
> [IM002][unixODBC][Driver Manager]Data source name not found,
> and no default driver specified
> [ISQL]ERROR: Could not SQLConnect
>
> I get the isql errors regardless of if Driver is set to
> /usr/local/lib/libtdsodbc.so (as installed) or set to
> /usr/local/lib/libodbc.so.
>
> I now get the same messages when attempting to connect from
> Oracle through a database link after changing init.ora
> variable HS_FDS_SHAREABLE_NAME from
> /usr/local/lib/libtdsodbc.so to /usr/local/lib/libodbc.so. I
> get library errors when using libtdsodbc.so. I suspect that
> once I fix isql, Oracle Generic Connectivity should work.
>
> ODBC Trace Output:
> ------------------------------
> $ cat odbc.log
> [ODBC][28232][__handles.c][444]
> Exit:[SQL_SUCCESS]
> Environment = 1dc8d0
> [ODBC][28232][SQLAllocHandle.c][345]
> Entry:
> Handle Type = 2
> Input Handle = 1dc8d0
> [ODBC][28232][SQLAllocHandle.c][463]
> Exit:[SQL_SUCCESS]
> Output Handle = 1dce68
> [ODBC][28232][SQLDriverConnect.c][678]
> Entry:
> Connection = 1dce68
> Window Hdl = 0
> Str In =
> [DSN=re_data_warehouse;UID=FAKEDOMAIN\bcamgr;PWD=*********][le
> ngth = 51 (SQL_NTS)]
> Str Out = ffbed7bc
> Str Out Max = 1020
> Str Out Ptr = ffbed7ba
> Completion = 0
> [ODBC][28232][SQLDriverConnect.c][1085]Error: IM002
> [ODBC][28232][SQLError.c][424]
> Entry:
> Connection = 1dce68
> SQLState = ffbed72c
> Native = ffbed120
> Message Text = ffbed528
> Buffer Length = 511
> Text Len Ptr = ffbed526
> [ODBC][28232][SQLError.c][461]
> Exit:[SQL_SUCCESS]
> SQLState = IM002
> Native = ffbed120 -> 0
> Message Text = [[unixODBC][Driver
> Manager]Data source name not found, and no default driver specified]
>
> Naive Summary:
> ------------------------
> It looks to me like the driver/library file isn't looking for
> odbc.ini or freetds.ini files. My intention is to use the
> ODBC only configuration, but I honestly can't determine how
> to force that.
>
> TIA for any and all feedback.
>
> Terry
>
> --------------------
>
> This email message is for the sole use of the intended
> recipient(s) and may contain privileged information. Any
> unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please
> contact the sender by reply email and destroy all copies of
> the original message.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page