freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] [Generic Connectivity Using ODBC]Record <table> has no fields. Loading failed
- 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
-
[freetds] [Generic Connectivity Using ODBC]Record <table> has no fields. Loading failed,
Bhavesh Patel, 06/14/2004
- Re: [freetds] [Generic Connectivity Using ODBC]Record <table> has no fields. Loading failed, James K. Lowden, 06/14/2004
Archive powered by MHonArc 2.6.24.