[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    MySQL/ODBC
From:       administrator <administrator () integrated-group ! com>
Date:       2003-08-31 16:38:40
[Download RAW message or body]

Hello
I wanna use ODBC with MySQL over Redhat 9 , So i was following the
OpenOffice.org 1.0, ODBC, and MySQL 'How-to'
http://pbs.linux.net.pl/ksiazki/OOoMySQL.pdf

I have these packages installed :

[root@localhost root]# rpm -qa | grep ODBC
unixODBC-filedsn-2.2.5-1
unixODBC-2.2.5-1
unixODBC-mysql-2.2.5-1
MyODBC-2.50.39-1
unixODBC-generic-2.2.5-1
unixODBC-kde-2.2.3-6


As The paper stated , I should Add these Entries to
/etc/odbcinst.ini

But i didnt find

Driver 		= /usr/lib.libmyodbc.so
or
Setup		= /usr/lib/libodbcmyS.so

Instead i used :
Driver          = /usr/local/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so.1

So My /etc/odbcinst.ini :

[MySQL]
Description     = ODBC driver for MySQL
Driver          = /usr/local/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so.1
FileUsage       = 1
CPTimeout       =
CPReuse         =

And then There is /etc/odbc.ini

[IGSohba]
Description             = IgSohba
Driver                  = MySQL
Server                  = localhost
Database                = igsohba
Port                    = 3306
Socket                  =
Option                  =
Stmt                    =


it is also mentioned that to test this :

[root@localhost root]# isql IGSohba
[ISQL]ERROR: Could not SQLConnect

So my questions are :
1) Are the libs i added in /etc/odbcinst.ini correct .

2) is there a missing package .

3) where did i go wrong / how do i fix this ?

Thanks In advance .
good day


maybe it would help :
[root@localhost root]# ps -auxe | grep sql
root      2577  0.0  0.0  4188    4 ?        S    Aug27   0:00 /bin/sh 
/usr/bin/mysqld_safe --datadir=/var/lib/mysql 
--pid-file=/var/lib/mysql/localhost.localdomain.pid CONSOLE=/dev/console 
TERM=linux INIT_VERSION=sysvinit-2.84 AUTOBOOT=YES 
PATH=/sbin:/usr/sbin:/bin:/usr/bin://bin RUNLEVEL=5 runlevel=5 
BOOT_FILE=/boot/
mysql     2606  0.0  2.4 30964 6092 ?        S    Aug27   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/localhost.localdomain.pid --skip-locking 
CONSOLE=/dev/console MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock 
TERM=linux INIT_VERSION=sysvinit-2.84 MYSQL_TCP_PORT=3306 AU
root      3320  0.0  0.2  3572  632 pts/2    S    19:37   0:00 grep sql 
HOSTNAME=localhost.localdomain TERM=xterm SHELL=/bin/bash HISTSIZE=1000 
SSH_CLIENT=10.0.0.16 32776 22 SSH_TTY=/dev/pts/2 USER=root 
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00
 [root@localhost root]#


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]