[freetds] Oracle heterogeneous services

Gregg Anderson ganderson at ghx.com
Thu Apr 22 11:47:21 EDT 2004

We are trying to connect our Solaris 8 Oracle 9i database to FreeTDS through unixODBC, and are able to connect to SQLServer2000.  However, all our queries through SQLPlus error out with "table or view does not exist.  Both tsql and isql queries run fine, so we are baffled.

Here is our configuration string...  Any help would be greatly appreciated.

locale is "C"
locale charset is "646"
Compile-time settings (established with the "configure" script):
                           Version: freetds v0.62.3
    MS db-lib source compatibility: no
       Sybase binary compatibility: unknown
                     Thread safety: no
                     iconv library: yes
                       TDS version: 7.0
                             iODBC: no
                          unixodbc: yes


Gregg Anderson
Senior Software Developer

Global Healthcare Exchange
10385 Westmoor Drive, Suite 100
Westminster, CO 80021
720.887.7200 fax
ganderson at ghx.com

More information about the FreeTDS mailing list