Home » Open Source » MySQL » Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 (Oracle 9i,ODBC 5.1.5,MySQL 5.0)
Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 [message #434970] Sat, 12 December 2009 05:35 Go to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Dear All,

Hope you are doing great.I was trying oracle heterogeneous services to connect oracle database to mysql database using ODBC driver.I am able to connect MySQL through oracle and fetch data.But VARCHAR columns of MySQL are not fetched properly using heterogeneous services and ODBC but numeric and DATE fields are fetched properly.Have anybody got this issue??

I am looking for some useful links if you can provide

Thanks & Regards,
Rajat
Re: Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 [message #435057 is a reply to message #434970] Mon, 14 December 2009 01:25 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

rajatratewal wrote on Sat, 12 December 2009 12:35
VARCHAR columns of MySQL are not fetched properly using heterogeneous services and ODBC


What do you mean by "not fetched properly".
Perhaps you should explain more in detail and provide an example.

Re: Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 [message #435775 is a reply to message #435057] Thu, 17 December 2009 20:11 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Hi tapush,

Well when i use

select * from table all columns except varchar are fetched.
it seems that ODBC driver is not recongnizing the varchar
columns.
when i do a desc then also varchar columns are omitted.

It seems some kind of driver issue.i searched on net and
found that i have to set charset of the driver but i have
found no option for it.

Regards,
Rajat
Re: Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 [message #435822 is a reply to message #435775] Fri, 18 December 2009 03:34 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Read this thread

If that doesn't solve your issue, post your question on that forum.

Previous Topic: oracle forms with mysql
Next Topic: MySQL
Goto Forum:
  


Current Time: Tue Mar 19 05:52:24 CDT 2024