[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