Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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
Dennis Handly
Acclaimed Contributor

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

>What can I do to solve this problem?

My IPF gcc compiler (3.4.3) likes __fpreg.
Are you using a PA gcc compiler?
Brecht De Baets
Frequent Advisor

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

We have an ia64 machine.
We use a GNU gcc compiler, version 4.1.2.

Where can I get the correct compiler ?

Regards
Dennis Handly
Acclaimed Contributor

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

>We have an ia64 machine.
>We use a GNU gcc compiler, version 4.1.2.

Can you compile a trivial source and then use the file(1) command on it to see what type of object files you get?

When you use "gcc -v --help", do you see "IA-64 options:"?

>Where can I get the correct compiler?

You can get it from DSPP by registering:
http://h21007.www2.hp.com/portal/site/dspp/menuitem.863c3e4cbcdc3f3515b49c108973a801/?ciid=2a08725cc2f02110725cc2f02110275d6e10RCRD
Brecht De Baets
Frequent Advisor

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

Ok,

The configure statement works fine now.
But when I run make, I get the following errors :

kernel/qt_x11.h:64:22: error: X11/Xlib.h: No such file or directory
kernel/qt_x11.h:69:23: error: X11/Xutil.h: No such file or directory
kernel/qt_x11.h:70:21: error: X11/Xos.h: No such file or directory
kernel/qt_x11.h:71:23: error: X11/Xatom.h: No such file or directory
kernel/qt_x11.h:79:34: error: X11/extensions/shape.h: No such file or directory
kernel/qapplication_x11.cpp:4470:27: error: X11/keysymdef.h: No such file or directory
kernel/qapplication_x11.cpp:6020:26: error: X11/SM/SMlib.h: No such file or directory

Where can I get these missing files ?
Dennis Handly
Acclaimed Contributor

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

These includes are shipped with HP's compilers, X11MotifDevKit is part of B9007AA.

I don't know if there is a opensource version of these.
Brecht De Baets
Frequent Advisor

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

On my HP-UX Application Software DVD, there is a directory B9007AA, but it is empty and
it is not in the list of programs that can be installed from the DVD.
There is, however, a package called HPDesktopDev in the list of programs.

I guess this package doesn't contain the libraries ?
Dennis Handly
Acclaimed Contributor

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

>Application Software DVD, there is a directory B9007AA, but it is empty

You need to purchase the product, perhaps that's why it is empty?

As I said, the headers are in X11MotifDevKit.