OraFAQ Forum: MySQL » Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Hetrogeneous Services [Connecting Oracle To MySQL] using ODBC Driver 5.1 [message #434970]

Sat, 12 December 2009 05:35

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	oracle forms with mysql
Next Topic:	MySQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:09:43 CST 2024