HS is very picky. Trying to get data from a Unidata system gave me SQL
errors all over the place. Use the DBMS_HS_PASSTHROUGH package. It will
save you lots of grief.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"steph" <stephan0h_at_gmx.net> wrote in message
news:1106069968.222657.52010_at_f14g2000cwb.googlegroups.com...
> Hi,
>
> I've just set up a database link to a MYSQL database using HSODBC. It
> needed some playing around to get it working - but finally I can select
> data from the MySQL-database! (that is, only if the transaction is in
> READ ONLY mode, but that's ok for me ... )
>
> Still, there's one problem left and maybe someone can help me:
> When selecting from columns for datatype LONG (as mapped in Oracle), I
> get the following error message:
>
> SQL> select "Tree" from "Tree"@mc where "Id"=5854690;
> ERROR:
> ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht
> zuruck:
> [Generic Connectivity Using ODBC][MySQL][ODBC 3.51
> Driver][mysqld-3.23.52-log]You have an error in your SQL syntax near
> '"Tree"
> WHERE "Id"=5854690' at line 1 (SQL State: 37000; SQL Code: 1064)
> ORA-02063: vorherige 2 lines von MC
>
> Has anyone seen this before? Is there a way to change the setup so that
> I can select also long-columns.
>
> (I'm using an Oralce database 10.1.0.3.0 on a SUSE 9.2 system)
> best regards,
> stephan
>
Received on Tue Jan 18 2005 - 12:37:55 CST
