Re: ODBC Driver for Solaris 9/10

[Hemant Dangi]

Hello Martin,

For setup of myodbc binary package, please follow below steps:

1. Unpack myodbc zipped file (mysql-connector-odbc-5.2.6-solaris10-sparc-64bit.tar.gz).
2. Edit odbc.ini, either manually or use myodbc-installer. Check below example for manual changes:

------------------------------------------------------------------
;
; odbc.ini configuration for MyODBC 5.2 Drivers
;

[ODBC Data Sources]
database_name = database_description

[database_name]
Driver = /home/user/mysql-connector-odbc-5.2.6-solaris10-sparc-64bit/libmyodbc5w.so
Description = Connector/ODBC 5.2 UNICODE Driver DSN
SERVER = my.server.com
PORT = 3306
USER = myuser
Password = mypwd
Database = test

------------------------------------------------------------------

Also check below link for information regarding odbc.ini:
http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-unix.html


3. Add ODBCSYSINI and ODBCINI environment variable in .bashrc file or command line.

export ODBCSYSINI=/home/user/mysql-connector-odbc-5.2.6-solaris10-sparc-64bit/test/
export ODBCINI=$ODBCSYSINI/odbc.ini



Please use below commands for pkg install:
$ gzip -d mysql-connector-odbc-5.1.12-solaris10-x86-64bit.pkg.gz
$ pkgadd -d mysql-connector-odbc-5.1.12-solaris10-x86-64bit.pkg.gz


Thanks.