[freetds] Record has no fields

apfuller at dart.net.au apfuller at dart.net.au
Tue Sep 27 20:35:13 EDT 2005


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 at 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






More information about the FreeTDS mailing list