FreeTDS Development Group

[Зверев Виталий Борисович <VZverev AT genesis.spb.ru>]

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
>