HSODBC Link to MySQL: Datatype LONG

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 - 11:39:28 CST