[freetds] [Generic Connectivity Using ODBC]Record <table> hasnofields. Loading failed

Bhavesh Patel xooogle at hotmail.com
Tue Jun 15 12:21:00 EDT 2004


Hi Freddy,
I downloaded freetds-0.63.dev.20040615, and installed with 
--enable-developing.
I am getting a different error now.

[oracle at 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 settings remain the same (as I mentioned in the earlier email).
The freetds.log is .15mb, which I did attach to my earlier email, and its 
waiting for the moderators approval.
I am attaching an excerpt.......

Starting log file for FreeTDS 0.63.dev.20040615
	on 2004-06-15 08:50:45 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
08:50:45.352622 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:50:45.352685 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:50:45.352734 Connecting to 172.30.8.10 port 1433, TDS 8.0.
08:50:45.353339 tds_put_string converting 12 bytes of "onl-itdev-07"
08:50:45.353395 tds_put_string wrote 24 bytes
08:50:45.353410 tds_put_string converting 9 bytes of "dmwebuser"
08:50:45.353427 tds_put_string wrote 18 bytes
08:50:45.353442 tds_put_string wrote 0 bytes
08:50:45.353456 tds_put_string converting 6 bytes of "SYBASE"
08:50:45.353474 tds_put_string wrote 12 bytes
08:50:45.353488 tds_put_string wrote 0 bytes
08:50:45.353502 tds_put_string converting 10 bytes of "us_english"
08:50:45.353519 tds_put_string wrote 20 bytes
08:50:45.353533 tds_put_string converting 12 bytes of "LeadStatusDM"
08:50:45.353550 tds_put_string wrote 24 bytes
08:50:45.353611 tds_process_login_tokens()
Received header @ 08:50:45.355559
0000 04 01 01 99 01 f4 01 00-                        |........|


Received packet @ 08:50:45.355601
0000 e3 27 00 01 0c 4c 00 65-00 61 00 64 00 53 00 74 |.'...L.e .a.d.S.t|
0010 00 61 00 74 00 75 00 73-00 44 00 4d 00 06 6d 00 |.a.t.u.s .D.M..m.|
0020 61 00 73 00 74 00 65 00-72 00 ab 76 00 45 16 00 |a.s.t.e. r..v.E..|
0030 00 02 00 2b 00 43 00 68-00 61 00 6e 00 67 00 65 |...+.C.h .a.n.g.e|
0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 4c |.x.t. .t .o. .'.L|
0070 00 65 00 61 00 64 00 53-00 74 00 61 00 74 00 75 |.e.a.d.S .t.a.t.u|
0080 00 73 00 44 00 4d 00 27-00 2e 00 0a 55 00 4f 00 |.s.D.M.' ....U.O.|
0090 50 00 4f 00 4e 00 4c 00-53 00 51 00 4c 00 31 00 |P.O.N.L. S.Q.L.1.|
00a0 00 00 00 e3 08 00 07 05-09 04 d0 00 34 00 e3 17 |........ ....4...|
00b0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00c0 00 69 00 73 00 68 00 00-ab 6e 00 47 16 00 00 01 |.i.s.h.. .n.G....|
00d0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
00e0 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
00f0 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
0100 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0110 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0120 00 0a 55 00 4f 00 50 00-4f 00 4e 00 4c 00 53 00 |..U.O.P. O.N.L.S.|
0130 51 00 4c 00 31 00 00 00-00 ad 36 00 01 71 00 00 |Q.L.1... ..6..q..|
0140 01 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.|
0150 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.|
0160 65 00 72 00 76 00 65 00-72 00 00 00 00 00 08 00 |e.r.v.e. r.......|
0170 02 f8 e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.......4 .0.9.6..|
0180 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ........|
0190 00                     -                        |.|

I dont know which part will be helpful for you to debug.

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 at 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 at dev-xx oracle]$ echo $TDSDUMP
> > /var/tmp/freetds/log/freetds.log
> >
> > TDSDUMP output:
> > [oracle at 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

_________________________________________________________________
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