FreeTDS Development Group

["Gregg Anderson" <ganderson AT ghx.com>]

We have successfully gotten Oracle HS to talk to SQL Server 2000 on three 
different Solaris boxes, but on our 4th attempt we can't seem to get Oracle 
to talk.  I am not sure if this is a unixODBC issue or FreeTDS, but both isql 
and tsql connect and query without issue.  It seems that most our 
environments are different patch levels and configurations, so I am at a loss.

Here is the HS log output with the error.  We have checked paths, but all 
seem to be there and read/execute are granted to all.

Oracle Corporation --- WEDNESDAY JUN 16 2004 23:01:43.563

    Version 9.2.0.4.0

[Generic Connectivity Using ODBC] version: 3.3.00.00.0034
connect string is: defTdpName=CATALYST1;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
IDENTIFIER_QUOTE_CHAR="",
CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj>
<binding>
<datasources>
<datasource name='CATALYST1' type='GENERIC_ODBC_FOR_HS' connect='CATALYST1'>
<driverProperties/></datasource></datasources><remoteMachines/><environment>
<misc year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
parserDepth='2000' noInsertParameterization='true' noThreadedReadAhead='true'
noCommandReuse='true'/></environment></binding></navobj>
ORACLE GENERIC GATEWAY Log File Started at 16-Jun-04 23:01:44
[unixODBC][Driver Manager]Can't open lib
'/usr/local/freetds/lib/libtdsodbc.so.0.0' : ld.so.1: hsodbcCATALYST1: fatal:
libodbcinst.so.1: open failed: No such file or directory (SQL State: 00000;
SQL Code: 0)
(Last message occurred 2 times)

Closing log file at WED JUN 16 23:01:45 2004.

Any ideas?

Thanks,

Gregg Anderson
Senior Software Developer

Global Healthcare Exchange
10385 Westmoor Drive, Suite 100
Westminster, CO 80021