freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] [Generic Connectivity Using ODBC]Record <table> has nofields. Loading failed
- From: "Bhavesh Patel" <xooogle AT hotmail.com>
- To: freetds AT lists.ibiblio.org
- Subject: Re: [freetds] [Generic Connectivity Using ODBC]Record <table> has nofields. Loading failed
- Date: Tue, 15 Jun 2004 04:55:00 +0000
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.
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 "UTF-8" character set
21:46:07.228178 tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
21:46:07.228222 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
21:46:07.228244 Connecting to 172.30.8.10 port 1433, TDS 8.0.
21:46:07.228823 tds_put_string converting 12 bytes of "onl-itdev-07"
21:46:07.228852 tds_put_string wrote 24 bytes
21:46:07.228861 tds_put_string converting 9 bytes of "dmwebuser"
21:46:07.228869 tds_put_string wrote 18 bytes
21:46:07.228878 tds_put_string converting 4 bytes of "TSQL"
21:46:07.228887 tds_put_string wrote 8 bytes
21:46:07.228894 tds_put_string converting 7 bytes of "repconf"
21:46:07.228902 tds_put_string wrote 14 bytes
21:46:07.228909 tds_put_string converting 11 bytes of "TDS-Library"
21:46:07.228917 tds_put_string wrote 22 bytes
21:46:07.228924 tds_put_string converting 10 bytes of "us_english"
21:46:07.228932 tds_put_string wrote 20 bytes
21:46:07.228939 tds_put_string wrote 0 bytes
21:46:07.228975 tds_process_login_tokens()
Received header @ 21:46:07.230531
0000 04 01 01 99 00 ca 01 00- |........|
Received packet @ 21:46:07.230555
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 - |.|
21:46:07.230682 looking for login token, got e3(ENVCHANGE)
21:46:07.230692 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 24 from wire to give 12 to client.
tds_get_string: reading 12 from wire to give 6 to client.
21:46:07.230731 looking for login token, got ab(INFO)
21:46:07.230739 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 86 from wire to give 43 to client.
tds_get_string: reading 20 from wire to give 10 to client.
21:46:07.230767 looking for login token, got e3(ENVCHANGE)
21:46:07.230775 tds_process_default_tokens() marker is e3(ENVCHANGE)
21:46:07.230897 tds_iconv_info_init: converting "UTF-8"->"CP1252"
21:46:07.230908 looking for login token, got e3(ENVCHANGE)
21:46:07.230916 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 20 from wire to give 10 to client.
21:46:07.230931 looking for login token, got ab(INFO)
21:46:07.230955 tds_process_default_tokens() marker is ab(INFO)
tds_get_string: reading 78 from wire to give 39 to client.
tds_get_string: reading 20 from wire to give 10 to client.
21:46:07.231039 looking for login token, got ad(LOGINACK)
tds_get_string: reading 44 from wire to give 22 to client.
21:46:07.231057 looking for login token, got e3(ENVCHANGE)
21:46:07.231065 tds_process_default_tokens() marker is e3(ENVCHANGE)
tds_get_string: reading 8 from wire to give 4 to client.
tds_get_string: reading 8 from wire to give 4 to client.
21:46:07.231086 increasing block size from 4096 to 4096
21:46:07.231104 looking for login token, got fd(DONE)
21:46:07.231113 tds_process_default_tokens() marker is fd(DONE)
21:46:07.231121 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
21:46:07.231131 tds_process_end() state set to TDS_IDLE
21:46:07.231138 leaving tds_process_login_tokens() returning 1
21:46:07.231159 tds_put_string converting 19 bytes of "set textsize 64512 "
21:46:07.231169 tds_put_string wrote 38 bytes
Sending packet @ 21:46:07.231177
0000 01 01 00 2e 00 00 01 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .|
Received header @ 21:46:07.232014
0000 04 01 00 11 00 ca 01 00- |........|
Received packet @ 21:46:07.232032
0000 fd 00 00 be 00 00 00 00-00 |........ .|
21:46:07.232043 processing result tokens. marker is fd(DONE)
21:46:07.232052 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
21:46:07.232061 tds_process_end() state set to TDS_IDLE
21:46:07.232069 tds_process_result_tokens() state is COMPLETED
21:46:15.684075 tds_put_string converting 24 bytes of "select * from allcampus
"
21:46:15.684130 tds_put_string wrote 48 bytes
Sending packet @ 21:46:15.684140
0000 01 01 00 38 00 00 01 00-73 00 65 00 6c 00 65 00 |...8.... s.e.l.e.|
0010 63 00 74 00 20 00 2a 00-20 00 66 00 72 00 6f 00 |c.t. .*. .f.r.o.|
0020 6d 00 20 00 61 00 6c 00-6c 00 63 00 61 00 6d 00 |m. .a.l. l.c.a.m.|
0030 70 00 75 00 73 00 0a 00- |p.u.s...|
Received header @ 21:46:15.716122
0000 04 01 01 2d 00 ca 01 00- |...-....|
Received packet @ 21:46:15.716143
0000 81 02 00 00 00 10 00 38-0b 41 00 6c 00 6c 00 43 |.......8 .A.l.l.C|
0010 00 61 00 6d 00 70 00 75-00 73 00 49 00 64 00 00 |.a.m.p.u .s.I.d..|
0020 00 09 00 a7 14 00 09 04-d0 00 34 0d 41 00 6c 00 |........ ..4.A.l.|
0030 6c 00 43 00 61 00 6d 00-70 00 75 00 73 00 4e 00 |l.C.a.m. p.u.s.N.|
0040 61 00 6d 00 65 00 d1 01-00 00 00 10 00 49 6e 74 |a.m.e... .....Int|
0050 6c 20 45 6e 72 6f 6c 6c-6d 65 6e 74 73 d1 02 00 |l Enroll ments...|
0060 00 00 14 00 44 6f 6d 65-73 74 69 63 20 45 6e 72 |....Dome stic Enr|
0070 6f 6c 6c 6d 65 6e 74 73-d1 03 00 00 00 08 00 41 |ollments .......A|
0080 63 61 64 65 6d 69 63 d1-04 00 00 00 0a 00 4e 6f |cademic. ......No|
0090 6e 20 44 65 67 72 65 65-d1 05 00 00 00 10 00 46 |n Degree .......F|
00a0 61 63 75 6c 74 79 20 53-65 72 76 69 63 65 73 d1 |aculty S ervices.|
00b0 06 00 00 00 07 00 46 69-6e 61 6e 63 65 d1 07 00 |......Fi nance...|
00c0 00 00 09 00 4d 61 72 6b-65 74 69 6e 67 d1 08 00 |....Mark eting...|
00d0 00 00 0d 00 48 52 20 43-6f 72 64 69 6e 61 74 6f |....HR C ordinato|
00e0 72 d1 09 00 00 00 0c 00-48 6f 6c 64 69 6e 67 20 |r....... Holding |
00f0 54 61 6e 6b d1 0a 00 00-00 0a 00 53 79 73 74 65 |Tank.... ...Syste|
0100 6d 20 52 65 70 d1 0b 00-00 00 10 00 43 6f 72 70 |m Rep... ....Corp|
0110 6f 72 61 74 65 20 4c 69-61 73 6f 6e fd 10 00 c1 |orate Li ason....|
0120 00 0b 00 00 00 - |.....|
21:46:15.716253 processing result tokens. marker is 81(TDS7_RESULT)
tds_get_string: reading 22 from wire to give 11 to client.
21:46:15.716307 tds7_get_data_info:1451:
colname = AllCampusId (11 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
21:46:15.716350 adjust_character_column_size:
Server charset: CP1252
Server column_size: 20
Client charset: UTF-8
Client column_size: 80
tds_get_string: reading 26 from wire to give 13 to client.
21:46:15.716368 tds7_get_data_info:1451:
colname = AllCampusName (13 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 80 (20 on server)
21:46:15.716401 processing result tokens. marker is d1(ROW)
21:46:15.716412 processing row tokens. marker is d1(ROW)
21:46:15.716421 processing row. column is 0 varint size = 0
21:46:15.716429 processing row. column size is 4
21:46:15.716439 clearing column 0 NULL bit
21:46:15.716446 processing row. column is 1 varint size = 2
21:46:15.716454 processing row. column size is 16
21:46:15.716461 clearing column 1 NULL bit
21:46:15.716501 processing row tokens. marker is d1(ROW)
21:46:15.716510 processing row. column is 0 varint size = 0
21:46:15.716518 processing row. column size is 4
21:46:15.716524 clearing column 0 NULL bit
21:46:15.716531 processing row. column is 1 varint size = 2
21:46:15.716539 processing row. column size is 20
21:46:15.716546 clearing column 1 NULL bit
21:46:15.716560 processing row tokens. marker is d1(ROW)
21:46:15.716568 processing row. column is 0 varint size = 0
21:46:15.716576 processing row. column size is 4
21:46:15.716583 clearing column 0 NULL bit
21:46:15.716590 processing row. column is 1 varint size = 2
21:46:15.716598 processing row. column size is 8
21:46:15.716605 clearing column 1 NULL bit
21:46:15.716618 processing row tokens. marker is d1(ROW)
21:46:15.716626 processing row. column is 0 varint size = 0
21:46:15.716634 processing row. column size is 4
21:46:15.716640 clearing column 0 NULL bit
21:46:15.716647 processing row. column is 1 varint size = 2
21:46:15.716654 processing row. column size is 10
21:46:15.716661 clearing column 1 NULL bit
21:46:15.716674 processing row tokens. marker is d1(ROW)
21:46:15.716682 processing row. column is 0 varint size = 0
21:46:15.716690 processing row. column size is 4
21:46:15.716696 clearing column 0 NULL bit
21:46:15.716703 processing row. column is 1 varint size = 2
21:46:15.716710 processing row. column size is 16
21:46:15.716717 clearing column 1 NULL bit
21:46:15.716731 processing row tokens. marker is d1(ROW)
21:46:15.716739 processing row. column is 0 varint size = 0
21:46:15.716746 processing row. column size is 4
21:46:15.716753 clearing column 0 NULL bit
21:46:15.716760 processing row. column is 1 varint size = 2
21:46:15.716767 processing row. column size is 7
21:46:15.716774 clearing column 1 NULL bit
21:46:15.716787 processing row tokens. marker is d1(ROW)
21:46:15.716795 processing row. column is 0 varint size = 0
21:46:15.716803 processing row. column size is 4
21:46:15.716810 clearing column 0 NULL bit
21:46:15.716816 processing row. column is 1 varint size = 2
21:46:15.716824 processing row. column size is 9
21:46:15.716831 clearing column 1 NULL bit
21:46:15.716844 processing row tokens. marker is d1(ROW)
21:46:15.716852 processing row. column is 0 varint size = 0
21:46:15.716860 processing row. column size is 4
21:46:15.716866 clearing column 0 NULL bit
21:46:15.716873 processing row. column is 1 varint size = 2
21:46:15.716880 processing row. column size is 13
21:46:15.716887 clearing column 1 NULL bit
21:46:15.716900 processing row tokens. marker is d1(ROW)
21:46:15.716908 processing row. column is 0 varint size = 0
21:46:15.716916 processing row. column size is 4
21:46:15.716922 clearing column 0 NULL bit
21:46:15.716929 processing row. column is 1 varint size = 2
21:46:15.716936 processing row. column size is 12
21:46:15.716943 clearing column 1 NULL bit
21:46:15.716956 processing row tokens. marker is d1(ROW)
21:46:15.716964 processing row. column is 0 varint size = 0
21:46:15.716972 processing row. column size is 4
21:46:15.716979 clearing column 0 NULL bit
21:46:15.716986 processing row. column is 1 varint size = 2
21:46:15.716993 processing row. column size is 10
21:46:15.717009 clearing column 1 NULL bit
21:46:15.717024 processing row tokens. marker is d1(ROW)
21:46:15.717032 processing row. column is 0 varint size = 0
21:46:15.717039 processing row. column size is 4
21:46:15.717046 clearing column 0 NULL bit
21:46:15.717053 processing row. column is 1 varint size = 2
21:46:15.717060 processing row. column size is 16
21:46:15.717067 clearing column 1 NULL bit
21:46:15.717080 processing row tokens. marker is fd(DONE)
21:46:15.717089 tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
21:46:15.717098 tds_process_end() state set to TDS_IDLE
21:46:15.717105 rows_affected = 11
21:46:15.717112 tds_process_result_tokens() state is COMPLETED
[oracle@onl-itdev-07 oracle]$
Thanks for all your help!
Bhavesh.
From: "James K. Lowden" <jklowden AT schemamania.org>
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> has nofields. Loading failed
Date: Mon, 14 Jun 2004 20:51:21 -0400
On Tue, 15 Jun 2004, "Bhavesh Patel" <xooogle AT hotmail.com> wrote:
> 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
If I could see a TDSDUMP log, I'd know at least what the Oracle server is
handing to FreeTDS.
To enable logging with an ODBC-only setup like you're using, I think
you'll have to export TDSDUMP in the Oracle process space before starting
the server. At least that would be the case if (as I suspect) the Oracle
server is loading the FreeTDS ODBC shared library.
The alternative would be to enable logging in freetds.conf, and use an
ODBC-combined setup (the Servername option in odbc.ini).
A couple of people have reported success using FreeTDS in the way you want
to, so it would seem it can work. I myself have no experience with the
product. I can help you only from the driver point of view.
HTH.
--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_________________________________________________________________
Watch the online reality show Mixed Messages with a friend and enter to win a trip to NY http://www.msnmessenger-download.click-url.com/go/onm00200497ave/direct/01/
- Re: [freetds] [Generic Connectivity Using ODBC]Record <table> has nofields. Loading failed, Bhavesh Patel, 06/15/2004
Archive powered by MHonArc 2.6.24.