Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bhavesh Patel" <xooogle AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] [Generic Connectivity Using ODBC]Record <table> has no fields. Loading failed
  • Date: Tue, 15 Jun 2004 00:40:02 +0000

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@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@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





Archive powered by MHonArc 2.6.24.

Top of Page