Operating System - HP-UX
1748156 Members
3826 Online
108758 Solutions
New Discussion юеВ

Re: Connection from Oracle to MySQL on HP-UX 11

 
SOLVED
Go to solution
Brecht De Baets
Frequent Advisor

Connection from Oracle to MySQL on HP-UX 11

I have an Oracle database 10g installed on a HP-UX server (HP-UX B.11.23). I want a connection from my Oracle database to a MySQL database on windows webserver (so that I can add triggers on my Oracle tables, that can insert data in the mySQL tables).

How can I do this ?

Regards,
Brecht
16 REPLIES 16
Ralph Grothe
Honored Contributor

Re: Connection from Oracle to MySQL on HP-UX 11

If you installed an MySQL client on your Oracle/HP server, and granted perms in your MySQL server for inserts from the Oracle host,
this should work I would think.
I would also think that it shouldn't be too dificult to write a Perl script that imports DBI with installed drivers of DBD::Oracle and DBD::mysql, and that simultanuously opens data base handles to both your Oracle and MySQL instance.
So you can easily read from one and insert to the other.

Madness, thy name is system administration
Brecht De Baets
Frequent Advisor

Re: Connection from Oracle to MySQL on HP-UX 11

Thanks for the reply, but this looks a bit Latin to me (We are a bit new to the Unix environment).
At Oracle I found a document that mentioned an HSODBC-connection to the MySQL database, but I also don't know how to do this ?

Best Regards,
Brecht


Oviwan
Honored Contributor

Re: Connection from Oracle to MySQL on HP-UX 11

Hey

I presume you are trying to create an Oracle DB link.
As far as I know there is no free way to do this. you have two options.

-install ODBC driver on HPUX (extra costs)and use Generic Connectivity (free)
-use Transparent Gateway of Oracle (extra costs)

I had a similar question but to connect to MSSQL. check this two threads for more infos:
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1127245
http://forums.oracle.com/forums/thread.jspa?messageID=1841110

Hope this helps

Regards
Brecht De Baets
Frequent Advisor

Re: Connection from Oracle to MySQL on HP-UX 11

I have found an ODBC-driver for mySQL on www.mysql.org. Apparently also a driver manager has to be installed. There is one on www.unixodbc.org.
When I try to install the driver manager however, it needs QT, which is also not for free ?

Regards
Brecht De Baets
Frequent Advisor

Re: Connection from Oracle to MySQL on HP-UX 11

I am following a document from Oracle.
First it tells me to install ODBC drivers from www.mysql.org. This is no problem.
But apparently also an driver-manager has to be installed. They told me to get it from www.unixodbc.org. As I tried to install this manager, I had the message that qt was needed. So I tried to install Qt/X11 Open Source Edition from the trolltech website.
But to install this I need the aCC-compiler,
which I don't have.

Isn't there another way to install ODBC ??

Regards
Oviwan
Honored Contributor
Solution

Re: Connection from Oracle to MySQL on HP-UX 11

Brecht De Baets
Frequent Advisor

Re: Connection from Oracle to MySQL on HP-UX 11

Ok thanks,

When I run ./configure now, I get the following error :

/usr/include/machine/sys/_types.h:65: error: '__fpreg' does not name a type

What does that mean ?

Regards,
Brecht




Dennis Handly
Acclaimed Contributor

Re: Connection from Oracle to MySQL on HP-UX 11

__fpreg is a builtin type that HP compiler's understand.
Brecht De Baets
Frequent Advisor

Re: Connection from Oracle to MySQL on HP-UX 11

What can I do to solve this problem ?

Regards,
Brecht