Re: Linking Oracle tables to MySQL
I guess Mr. Metras using oracle's hs service to connect to Access. For MySQL,same way will work,but you need to notice some problems:
. Field name (Column name) casesensitive
. Date,Datetime field cound not transfer as a 'where clause' parameter from oracle to MySQL.
. MyODBC has not a true statement prepare function in 3.51 version,so odbc's prepare statement operation will do a full table scan.
I've modified MyODBC driver on redhat es3 lightly,seems avoid the above problems,but not fully tested .
Subject
Views
Written By
Posted
6998
November 05, 2004 04:28PM
8543
November 16, 2004 06:39PM
3903
November 17, 2004 07:55AM
3806
November 17, 2004 10:02AM
3513
November 17, 2004 01:15PM
6953
November 17, 2004 01:46PM
3163
November 17, 2004 02:18PM
3464
November 17, 2004 02:41PM
2944
November 17, 2004 03:09PM
3552
December 08, 2004 04:01PM
3291
December 14, 2004 09:20AM
3337
December 14, 2004 09:27AM
Re: Linking Oracle tables to MySQL
3565
December 14, 2004 08:52PM
6920
July 04, 2006 04:46PM
3835
July 04, 2006 05:02PM
3200
July 06, 2006 03:37PM
3701
July 20, 2006 11:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.