Skip to Content.
Sympa Menu

freetds - Re: [freetds] Record has no fields

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Зверев Виталий Борисович <VZverev AT genesis.spb.ru>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Record has no fields
  • Date: Wed, 28 Sep 2005 13:06:00 +0400

HI Aaron,
The 'customer_vw' table should be accessible from database noted in ODBCINI /
HS_FDS_CONNECT_INFO or you should assign it explicitly before select:
DECLARE
c INTEGER;
begin
c:= DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@SC('use _bla_bla_bla_');
end;

By default HS uses upper cased column name notation and it can be a
cornerstone of your problem. You should try to rewrite select in
case-sensitive style: select "Exact_CoLuMn_NaMe" from customer_vw@sc If you
doubt in translated HS case-sensitive column names, try this:

select column_name
from dba_tab_columns@sc
where lower(table_name) like 'customer_vw'

Sincerely yours.

-------------------------------------------------------
Vitaly Zverev, OCP DBA 8&8i
Oracle E-Business Suite &
Infiniband Linux Cluster Administrator
Genesis Ltd., St.Petersburg, Russia




-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of apfuller AT dart.net.au
Sent: Wednesday, September 28, 2005 4:35 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Record has no fields


Hi All,

Something that has got me stumped...

I've setup freetds 0.63 (latest stable ver) and unixODBC to connect my Oracle
to SQL Server instance in UNIX. So far I can use isql to query, create,
insert
etc against sql server, however when I try and query through sqlplus using a
database link I get the following sorts of returns...

1.
select * from all_catalog@SC
--this works. Brings back tables for dbo and other users

2.
SQL> select * from "customer_vw"@SC;
select * from "customer_vw"@SC
*
ERROR at line 1:
ORA-00942: table or view does not exist
[Generic Connectivity Using ODBC]DRV_DescribeTable: Record customer_vw has no
fields. Loading failed
ORA-02063: preceding 2 lines from SC


I've read that it was a bug in previous versions of freetds, can I presume
that
it is ok in .63?

Also I have tried many different variants
of "customer_vw"@SC "serviceCentre"."customer_vw"@SC etc, none seem to
work.
I can only select from system tables.

Any thoughts would be most appreciated,

Cheers,

Aaron



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



  • [freetds] Record has no fields, apfuller, 09/27/2005
    • <Possible follow-up(s)>
    • Re: [freetds] Record has no fields, Зверев Виталий Борисович, 09/28/2005

Archive powered by MHonArc 2.6.24.

Top of Page