[freetds] Oracle Generic Connectivity: error: Record <table> has nofields. Loading failed

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Aug 12 04:24:35 EDT 2004


> 
> We are running Solaris 5.8 and Oracle 10g
> We are trying to set up a connection to a MS SQLSERVER using 
> freetds and 
> unixODBC
> 
> Testen the connection to the MS SQLSERVER database with isql 
> and tsql are 
> all fine
> So setup of freetds and unixODBC must be OK.
> 
> In the oracle database we get the next error:
> 
> select * from "MIES"@kana
>               *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> [Generic Connectivity Using ODBC]Record MIES has no fields. 
> Loading failed
> ORA-02063: preceding 2 lines from KANA
> 
> freetds version tested:
> - 0.62.4

It doesn't work...

> - freetds-0.63.dev.20040811 with configure 
> --enable-developing as suggested 
> somewhere
> 

--enable-developing not more necessary

> has someone siolved this issue?
> 

It should work (I don't have Oracle...). Reported some problems with
"materialized view" but a simple query should work.

freddy77



More information about the FreeTDS mailing list