topic Re: Connection from Oracle to MySQL on HP-UX 11 in Operating System - HP-UX

Connection from Oracle to MySQL on HP-UX 11

Brecht De Baets — Fri, 06 Jul 2007 01:44:02 GMT

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

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

Ralph Grothe — Fri, 06 Jul 2007 03:15:55 GMT

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.

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

Brecht De Baets — Fri, 06 Jul 2007 03:31:36 GMT

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

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

Oviwan — Fri, 06 Jul 2007 03:55:56 GMT

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

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

Brecht De Baets — Fri, 06 Jul 2007 04:17:15 GMT

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

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

Brecht De Baets — Fri, 06 Jul 2007 06:32:33 GMT

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

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

Oviwan — Fri, 06 Jul 2007 07:36:42 GMT

mysql odbc: http://dev.mysql.com/downloads/connector/odbc/3.51.html#hpux

maybe you have luck with this:
http://hpux.cs.utah.edu/hppd/hpux/Development/Libraries/qt-3.0.5/

I have never tried it

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

Brecht De Baets — Fri, 06 Jul 2007 08:24:18 GMT

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

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

Dennis Handly — Sat, 07 Jul 2007 10:06:16 GMT

__fpreg is a builtin type that HP compiler's understand.

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

Brecht De Baets — Tue, 10 Jul 2007 03:10:36 GMT

What can I do to solve this problem ?

Regards,
Brecht

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

Dennis Handly — Tue, 10 Jul 2007 05:50:32 GMT

>What can I do to solve this problem?

My IPF gcc compiler (3.4.3) likes __fpreg.
Are you using a PA gcc compiler?

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

Brecht De Baets — Tue, 10 Jul 2007 06:19:00 GMT

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

Where can I get the correct compiler ?

Regards

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

Dennis Handly — Tue, 10 Jul 2007 07:16:31 GMT

>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

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

Brecht De Baets — Thu, 12 Jul 2007 05:04:40 GMT

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 ?

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

Dennis Handly — Thu, 12 Jul 2007 17:37:30 GMT

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.

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

Brecht De Baets — Fri, 13 Jul 2007 03:32:33 GMT

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 ?

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

Dennis Handly — Fri, 13 Jul 2007 14:55:12 GMT

>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.