8.3 ODBC

20.02.2008

[ up ] - [ top ] - [ linux a-z ]

9 Development →

X X X
(My unstructured notes)

Download necessary software
-rw-r--r-- 1 root root 521801 Jan 27  2006 libiodbc-3.52.4-1.i386.rpm
-rw-r--r-- 1 root root 243505 Jan 27  2006 libiodbc-devel-3.52.4-1.i386.rpm
→ www.iodbc.org/index.php?page=downloads/index↑
# ln -s libiodbc.so.2.1.15 libiodbc.so
Install DBD::ODBC
perl Makefile.PL -o /usr
make
make test
make install
Linklist

www.iodbc.org/index.php?page=languages/perl/odbc-perlHOWTO↑

webdna.smithmicro.com/ref/UNIXODBCSetup.html↑

Oracle Driver:
https://shop.openlinksw.com/#product
http://download.openlinksw.com/download/
http://www.easysoft.com/products/data_access/odbc_oracle_driver/index.html

ODBC Driver for MySQL 4.x:
http://download.openlinksw.com/components/6.0/i686-generic-linux-glibc23-32/mys4_lt.taz
c:\Windows\system32\odbcad32.exe

--
mysql>
grant all privileges on beff.* to 'reto'@'84.227.18.221';
UPDATE user SET Password=PASSWORD('yourpass') WHERE User='reto' AND Host='184.27.18.21';
FLUSH PRIVILEGES;

Test it:
mysql -D beff -u reto -h primus.example.net -p

--
yum install mysql-connector-odbc
/etc/odbc.ini
The structure of the ini file below seems to be correct but I could not make an end-to-end test. It might be related with MySQL itself and the fast changes on this DB server. The goal was to connect to an Oracle 9.x DB anyway...
[ODBC Data Sources]
foodb = My database description

[foodb]
Driver = /usr/lib/libmyodbc3_r-3.51.12.so
Host = primus.example.net
Database = yourdbname
USER = reto
Password = yourpass
port = 3306
trace = on

[ODBC]
Trace = 1
TraceFile = /tmp/odbctrace.log
Debug = 1
DebugFile = /tmp/odbcdebug.log
I gave up since I was not able to find the required database driver /usr/lib/libmyodbc.so on the Net :-|
I have installed these RPM's without finding this file.
mysql-connector-odbc-3.51.12-1.2.1
libiodbc-3.52.4-1
unixODBC-2.2.11-6.2.1
libiodbc-devel-3.52.4-1