ODBC

This forum is for topics specific to the Raspberry Pi and Arch Linux ARM

ODBC

Postby syco » Fri Dec 28, 2012 4:06 pm

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.
syco
 
Posts: 2
Joined: Fri Dec 28, 2012 3:54 pm

Re: ODBC

Postby xenoxaos » Sat Dec 29, 2012 2:34 am

is mysqld running?
Arch Linux ARM exists and continues to grow through community support, please donate today!
xenoxaos
Developer
 
Posts: 323
Joined: Thu Jan 06, 2011 1:45 am

Re: ODBC

Postby syco » Mon Jan 07, 2013 4:32 pm

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.
syco
 
Posts: 2
Joined: Fri Dec 28, 2012 3:54 pm

Re: ODBC

Postby prepro » Tue Feb 19, 2013 10:04 am

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
)

$this->bbcode_second_pass_quote('', ' ')
ls -l /usr/lib/*odbc*
lrwxrwxrwx 1 root root 16 Feb 19 09:57 /usr/lib/libmyodbc.so -> ./libmyodbc5w.so
-rwxr-xr-x 1 root root 262468 Feb 7 00:13 /usr/lib/libmyodbc5w.so
lrwxrwxrwx 1 root root 16 Jul 30 2012 /usr/lib/libodbc.so -> libodbc.so.2.0.0
lrwxrwxrwx 1 root root 16 Jul 30 2012 /usr/lib/libodbc.so.2 -> libodbc.so.2.0.0
-rwxr-xr-x 1 root root 366764 Jul 30 2012 /usr/lib/libodbc.so.2.0.0
lrwxrwxrwx 1 root root 18 Jul 30 2012 /usr/lib/libodbccr.so -> libodbccr.so.2.0.0
lrwxrwxrwx 1 root root 18 Jul 30 2012 /usr/lib/libodbccr.so.2 -> libodbccr.so.2.0.0
-rwxr-xr-x 1 root root 28892 Jul 30 2012 /usr/lib/libodbccr.so.2.0.0
lrwxrwxrwx 1 root root 20 Jul 30 2012 /usr/lib/libodbcinst.so -> libodbcinst.so.2.0.0
lrwxrwxrwx 1 root root 20 Jul 30 2012 /usr/lib/libodbcinst.so.2 -> libodbcinst.so.2.0.0
-rwxr-xr-x 1 root root 55464 Jul 30 2012 /usr/lib/libodbcinst.so.2.0.0

prepro
 
Posts: 1
Joined: Tue Feb 19, 2013 10:02 am

Re: ODBC

Postby Zielony » Tue Feb 26, 2013 1:03 pm

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).
Zielony
 
Posts: 2
Joined: Tue Feb 26, 2013 12:51 pm


Return to Raspberry Pi

Who is online

Users browsing this forum: Google [Bot] and 2 guests