- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Mysql ODBC driver
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
тАО08-27-2008 04:15 AM
тАО08-27-2008 04:15 AM
I have been searching in the forum and found some interesting things about it but I already have questions.
We have a RedHat server with MySQL 5.0.45 and an HPUX 11.11 PA-RISC 64bits client host. We want to establish an ODBC communication between them.
We get the Mysql odbc driver from mysql site.
the question is that in the installation instructions there are these recommendations:
"ODBC Systems
Strictly speaking, the driver can be used without any ODBC system but in practice this is seldom done. Depending upon your system - one of the following is needed and is usually available with your operating system (and is often installed by default).
* unixODBC
* Apple iODBC
* iODBC
* Microsoft ODBC
"
From my understanding HPUX does not have an ODBC system, so we need one. The "recommend" from MySQL is the unixODBC from http://www.unixodbc.org/ But I couldn't find if it possible using the driver without it or a better way.
This is too from the INSTALL file:
"one must first extract the files and then manually copy the files to a desired location and then manually register the driver with the ODBC system."
The myodbc3i from the /bin of the mysql ODBC driver doe not work properly (Unable to find library 'libodbcinst.sl.1'.) And truly that library doesn't exist in the machine, and trying to load the library manually with ldd returns an error with the same library. I think this can be because the unixODBC is not installed, can this be true? Is the using of unixODBC the best or a must?
Thank you in advance,
Antonio
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-27-2008 04:41 AM
тАО08-27-2008 04:41 AM
Re: Mysql ODBC driver
Both databases are mysql
You don't need ODBC for data interactivity.
mysqldump can make backups of data that you can transfer from database to database.
One thing I don't see from your post is what you want to do.
Simple data transfers can be scripted.
more complex data transfer can be handled with the native database engines available in mysql.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2008 04:44 AM
тАО08-29-2008 04:44 AM
Re: Mysql ODBC driver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-01-2008 12:45 AM
тАО09-01-2008 12:45 AM
Re: Mysql ODBC driver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-05-2008 08:36 PM
тАО09-05-2008 08:36 PM
SolutionSee Jeff Hunter's site to see how it is done for Solaris.
http://idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-08-2008 03:25 AM
тАО09-08-2008 03:25 AM