Skip to Content.
Sympa Menu

freetds - RE: [freetds] [Generic Connectivity Using ODBC]Record <table> hasnofields. 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: RE: [freetds] [Generic Connectivity Using ODBC]Record <table> hasnofields. Loading failed
  • Date: Tue, 15 Jun 2004 16:03:30 +0000

Hi Freddy,
I just downloaded freetds-0.63.dev.20040615.
Now, I am getting a different error.

[oracle@onl-itdev-07 log]$ sqlplus sys as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Jun 15 09:01:01 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from "AllCampus"@rep;
select * from "AllCampus"@rep
*
ERROR at line 1:
ORA-02068: following severe error from REP
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=%s
ORA-28509: unable to establish a connection to non-Oracle system

SQL> exit

The other setup remains same, as I mentioned in my earlier email.

I am attaching the freetds.log.

Thanks for all your help.

Bhavesh.

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] [Generic Connectivity Using ODBC]Record <table> hasnofields. Loading failed
Date: Tue, 15 Jun 2004 08:55:32 +0200

>
> Hey James.
> I got the TDSDUMP working.
> I am now using ODBC-combined setup.
>
> Here is my freetds.conf setting:
> --------------------------------
> dump file = /var/tmp/freetds/log/freetds.log
> debug level = 10
>
> [repconf]
> host = 172.30.8.10
> port = 1433
> tds version = 8.0
>
> Here is my .odbc.ini file:
> --------------------------
> [oracle@dev-xx oracle]$ cat .odbc.ini
> [repdsn]
> Driver = /usr/local/freetds/lib/libtdsodbc.so
> Description = connecting to leadstatus db on uoponlsql1
> Trace = No
> Servername = repconf
> Database = LeadStatusDM
>
> [Default]
> Driver = /usr/local/freetds/lib/libtdsodbc.so
>
> TDSDUMP environment variable:
> -----------------------------
> [oracle@dev-xx oracle]$ echo $TDSDUMP
> /var/tmp/freetds/log/freetds.log
>
> TDSDUMP output:
> [oracle@onl-itdev-07 oracle]$ cat /var/tmp/freetds/log/freetds.log
> Starting log file for FreeTDS 0.62.4
> on 2004-06-14 21:46:07 with debug level 99.

Sorry, it doesn't work with 0.62, use 0.63 (current CVS version).

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Attachment: freetds.log
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page