Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HSODBC Link to MySQL: Datatype LONG

Re: HSODBC Link to MySQL: Datatype LONG

From: Jack <none_at_mail.com>
Date: Wed, 19 Jan 2005 11:22:35 GMT
Message-ID: <%prHd.169$vl1.107@read3.inet.fi>


Hi!

Who has made that ODBC-driver? and which version number? There are differences between vendors. Some works some not. Need testing...

"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 Wed Jan 19 2005 - 05:22:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US