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.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC form HP-UX 11.11 to Linux based mySQL server

Jens Ebert
Frequent Advisor

ODBC form HP-UX 11.11 to Linux based mySQL server

Same problem Seth Clarke reported a short time before, but we need a solution for mySQL.
Szenario: C program running on HP-UX 11.11 making a connection to a remote mySQL server.
Where do I find the software needed on client (HP-UX) side (i.e. header files ...)?

Thank you, Jens
4 REPLIES
harry d brown jr
Honored Contributor

Re: ODBC form HP-UX 11.11 to Linux based mySQL server

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

live free or die
harry d brown jr
Live Free or Die
Ganesha Sridhara
Honored Contributor

Re: ODBC form HP-UX 11.11 to Linux based mySQL server


HTH in configuring ODBC

http://www.ihtmlmerchant.com/tfaqodbc.doc

Regards
Ganesha Sridhara
Jens Ebert
Frequent Advisor

Re: ODBC form HP-UX 11.11 to Linux based mySQL server

Right now I try to get "iodbctest" to work but it fails with the message:

1: SQLDriverConnect = [iODBC][Driver Manager]No such file or directory (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003

I use DSN=test (as configured in odbc.ini):

[ODBC Data Sources]
myodbc = MySQL ODBC 2.50 Driver DSN
test = MySQL ODBC 3.51 Driver DSN
...
[test]
Driver = /usr/local/lib/libmyodbc3.sl
Description = MySQL ODBC 3.51 Driver DSN
SERVER = testhost
PORT = 3306
USER =
Password =
Database = test-db
OPTION = 3
SOCKET =

The library /usr/local/lib/libmyodbc3.sl does exist.

The environment variables are set as:
LD_LIBRARY_PATH=/usr/local/lib
SHLIB_PATH=/usr/local/lib
ODBCINI=/usr/local/etc/odbc.ini

Any idea?
What is missing?
Jens Ebert
Frequent Advisor

Re: ODBC form HP-UX 11.11 to Linux based mySQL server

No reply any more (too simple or too complicated?). Anyhow, having the case open does not make sense to me.