FreeTDS Development Group

[Jeff Fisher <JFisher AT Emery-Waterhouse.com>]

Stephan, you'll want to watch your results carefully.  We have Oracle 10G on
RH Linux and are connecting to SQL Server using HSODBC and freetds .63.  The
connection work, and basic queries work, but we found that using the
SQLServer connection in a cursor in a stored procedure caused unpredictable
results.  It appeared that result sets are being cached. So even though the
input to the cursor was different, we'd get back a previous result set.
Note this was only an issue in cursors.

We couldn't tell if this was a problem with Oracle or Freetds.  So we
eventually created java stored procedures and used the jtds jdbc driver for
those operations.  We just loaded the jtds driver into Oracle.



-----Original Message-----
From: Stephan Herschel [mailto:Stephan.Herschel AT biovertis.com]
Sent: Tuesday, April 05, 2005 1:34 PM
To: freetds AT lists.ibiblio.org
Subject: RE: [freetds] Oracle heterogeneous connection with FreeTDS:
Failed to load dynamic library


apparently i solved this myself now:

in <oracle-home>/hs/admin/init<SID>.ora I have to use 
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
instead of
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.so

Ouch!

> -----Original Message-----
> From: Stephan Herschel 
> Sent: Tuesday, April 05, 2005 6:33 PM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Oracle heterogeneous connection with 
> FreeTDS: Failed to load dynamic library
> 
> 
> Hi,
> We're using Oracle 10G on Suse Linux. To enable a connection 
> to SQLServer I've set up an ODBC-connection with FreeTDS and 
> unixODBC. The connection works as can be tested with FreeTDS' 
> tsql and unixODBC's isql.
> 
> The server is defined like this:
> ===
> [snorred]
>        host = snorred
>        port = 1433
>        tds version = 8.0
> ===
> 
> Tsql's output is like this:
> ===
> oradba@wickie02:~/OraHome_1/network/admin> tsql -S snorred -U 
> sa -C Compile-time settings (established with the "configure" script):
>                            Version: freetds v0.63
>     MS db-lib source compatibility: no
>        Sybase binary compatibility: unknown
>                      Thread safety: yes
>                      iconv library: yes
>                        TDS version: 5.0
>                              iODBC: no
>                           unixodbc: yes
> ===
> 
> (I don't know why there is this mismatch with TDS-version)
> 
> 
> 
> I've set up the hsodbc connection similar to a working 
> connection to MySQL. 
> When issuing select statements from within Oracle I get:
> 
> ===
> SQL> select * from bla@snorred;
> select * from bla@snorred
> *
> ERROR at line 1:
> ORA-28500: connection from ORACLE to a non-Oracle system 
> returned this message: [Generic Connectivity Using 
> ODBC][C077] Could not find symbol 'SQLDescribeParam' in 
> dynamic library [C079] Failed to load dynamic library 
> '/usr/local/lib/libtdsodbc.so' [C077] Could not find symbol 
> 'SQLExtendedFetch' in dynamic library [C079] Failed to load 
> dynamic library '/usr/local/lib/libtdsodbc.so'
> ORA-02063: preceding 5 lines from SNORRED
> ===
> 
> Any hints are very welcome,
> Stephan
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org 
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds