[freetds] [Generic Connectivity Using ODBC]Record <table> has no fields. Loading failed

Bhavesh Patel xooogle at hotmail.com
Mon Jun 14 20:40:02 EDT 2004


I am running oracle 10 g on Linux.
On trying to connect to SQL Server 2000, on Windows 2000, I get the 
following error.

SQL> select * from "AllCampus"@rep;
select * from "AllCampus"@rep
              *
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity Using ODBC]Record AllCampus has no fields. Loading 
failed
ORA-02063: preceding 2 lines from REP

tsql and isql are giving proper results though.

I have freetds version 0.62.4 installed.
I also tried with current freetds-0.63.devel.20040614, but no luck.
odbc.ini:
---------
[oracle at dev-xx oracle]$ cat /home/oracle/.odbc.ini
[repdsn]
Driver          = TDS
Description             = connecting to leadstatus db on uoponlsql1
Trace           = No
Server          = 172.30.8.10
TDS_Version             = 8.0
Port            = 1433
Database                = Lead

tnsnames.ora:
-------------
xxx =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dev-xx)(PORT = 1521))
    (CONNECT_DATA = (SID = rep))
    (HS=OK)
  )
listener.ora:
-------------
    (SID_DESC =
      (SID_NAME = rep)
      (ORACLE_HOME = /Oracle10g/product/10.1.0/db_1)
      (PROGRAM = hsodbc)
      
(ENVS=LD_LIBRARY_PATH=/Oracle10g/product/10.1.0/db_1/lib:/usr/local/unixODBC/lib:/usr/local/freetds/lib)
    )
initrep.ora:
------------
[oracle at dev-xx admin]$ cat initrep.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = repdsn
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/local/unixODBC/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/home/oracle/.odbc.ini

_________________________________________________________________
Getting married? Find great tips, tools and the latest trends at MSN Life 
Events. http://lifeevents.msn.com/category.aspx?cid=married




More information about the FreeTDS mailing list