ODBC

[syco]

Hi all,
I have problems with odbc and mysql:
I've installed myodbc and unixodbc,

$this->bbcode_second_pass_code('', 'cat /etc/odbc.ini
[TEST]
Description = MySQL
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = localhost
Database = Test
Option = 3')

$this->bbcode_second_pass_code('', 'cat /etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5w.so
Setup = /usr/lib/libmyodbc5w.so <<<<< first problem, "/usr/lib/libodbcmyS.so" does not exists
FileUsage = 1')

$this->bbcode_second_pass_code('', 'mysql -u tuser -p tpsw -h localhost Test
odbcinst -j
odbcinst -s -q') works.

$this->bbcode_second_pass_code('', 'isql -v TEST tuser tpsw') dies with "[ISQL]ERROR: Could not SQLConnect"

Someone can give a hint?
thanks.

[xenoxaos]

is mysqld running?

[syco]

yes, it is running:
$this->bbcode_second_pass_code('', 'ps aux | grep mysql
mysql 720 0.3 7.1 309420 31992 ? Ssl 15:28 0:12 /usr/bin/mysqld --user=mysql
root 22056 0.0 0.1 2428 736 pts/0 S+ 16:29 0:00 grep mysql')

as said in the first post
$this->bbcode_second_pass_code('', 'mysql -u tuser -p tpsw -h localhost Test
odbcinst -j
odbcinst -s -q')
works without any problem.

In the file /etc/odbcinst.ini there's usually a line Setup that looks like

Setup = /usr/lib64/libodbcmyS.so

but I cannot find any file libodbcmyS.so in the system. Do I miss a dependency?
these are the packets I have installed:
$this->bbcode_second_pass_code('', 'pacman -Qqs odbc
myodbc
unixodbc')
$this->bbcode_second_pass_code('', 'pacman -Qqs mysql
libmysqlclient
myodbc
mysql
mysql-clients')

thanks.

I'm have the same issue!
I'm also cannot find the libodbcmyS.so file
$this->bbcode_second_pass_quote('', '(')isql MySQL-test -v
[ISQL]ERROR: Could not SQLConnect
)

[Zielony]

I've got an identical problem. I think the problem is that ODBC tries to connect through network instead of socket (I have skip-networking in /etc/mysql/my.cnf).