- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Connection from Oracle to MySQL on HP-UX 11
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 06:44 PM
тАО07-05-2007 06:44 PM
How can I do this ?
Regards,
Brecht
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 08:15 PM
тАО07-05-2007 08:15 PM
Re: Connection from Oracle to MySQL on HP-UX 11
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 08:31 PM
тАО07-05-2007 08:31 PM
Re: Connection from Oracle to MySQL on HP-UX 11
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 08:55 PM
тАО07-05-2007 08:55 PM
Re: Connection from Oracle to MySQL on HP-UX 11
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 09:17 PM
тАО07-05-2007 09:17 PM
Re: Connection from Oracle to MySQL on HP-UX 11
When I try to install the driver manager however, it needs QT, which is also not for free ?
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2007 11:32 PM
тАО07-05-2007 11:32 PM
Re: Connection from Oracle to MySQL on HP-UX 11
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2007 12:36 AM
тАО07-06-2007 12:36 AM
Solutionmaybe you have luck with this:
http://hpux.cs.utah.edu/hppd/hpux/Development/Libraries/qt-3.0.5/
I have never tried it
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2007 01:24 AM
тАО07-06-2007 01:24 AM
Re: Connection from Oracle to MySQL on HP-UX 11
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2007 03:06 AM
тАО07-07-2007 03:06 AM
Re: Connection from Oracle to MySQL on HP-UX 11
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-09-2007 08:10 PM
тАО07-09-2007 08:10 PM
Re: Connection from Oracle to MySQL on HP-UX 11
Regards,
Brecht