Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Mysql ODBC driver

SOLVED
Go to solution
Antonio Egea
Advisor

Mysql ODBC driver

Hello all,

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
5 REPLIES
Steven E. Protter
Exalted Contributor

Re: Mysql ODBC driver

Shalom Antonio,

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Antonio Egea
Advisor

Re: Mysql ODBC driver

Sorry for the delay Steven. I am asking them what you pointed me which looks more than reasonable
Antonio Egea
Advisor

Re: Mysql ODBC driver

Steven, they need real time querying to a MySQL DB.
IMGERALD
Occasional Advisor
Solution

Re: Mysql ODBC driver

There are a couple of choices and the simpliest is Heterogeneous Services. I do not think UNIXOBDC is available for HP-UX. It is currently available for Solaris 8, 9. In any case there must be an Oracle database running on HP-UX, not just an Oracle client. See if you can get the OBDC from easysoft or datadirect-technologies.com

See Jeff Hunter's site to see how it is done for Solaris.

http://idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml
Antonio Egea
Advisor

Re: Mysql ODBC driver

Thank you all, we will contact easysoft and datadirect.