Operating System - HP-UX
1748041 Members
5176 Online
108757 Solutions
New Discussion юеВ

Re: 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 4
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.