Доброго времени!
имеем:
1.
# cat /etc/redhat-release
CentOS release 5.11 (Final)
1.
# uname -a
Linux adphost 2.6.18-402.el5.centos.plusPAE #1 SMP Wed Feb 11 01:42:09 EST 2015 i686 i686 i386 GNU/Linux
1.
# rpm -q unixODBC
unixODBC-2.2.11-10.el5
1.
2.
3.
# rpm -qa | grep mdbtools
mdbtools-0.6-0.3.cvs20051109.el5
mdbtools-devel-0.6-0.3.cvs20051109.el5
mdbtools-libs-0.6-0.3.cvs20051109.el5
Собсно примонтировал виндовую шару с mdb базой ms access
Добавил драйвер mdbtools в odbcinst.ini
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
# cat /etc/odbcinst.ini
# Example driver definitions
# See /usr/share/doc/unixODBC*/README.64bit for more information
[MDBToolsODBC]
Description = MDB Tools ODBC
Driver = /usr/lib/libmdbodbc.so.0
Setup =
FileUsage =
CPTimeout =
CPReuse =
# Use these definitions with the original unixODBC package
# Driver from the postgresql-odbc package
# Setup from the unixODBC-libs package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC-libs package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3_r.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc3_r.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
# Use these definitions with the unixODBC64 package
# Driver from the postgresql-odbc64 package
# Setup from the unixODBC64-libs package
[PostgreSQL64]
Description = ODBC for PostgreSQL (64 bit)
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS64.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS64.so
FileUsage = 1
# Driver from the mysql-connector-odbc64 package
# Setup from the unixODBC64-libs package
[MySQL64]
Description = ODBC for MySQL (64 bit)
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS64.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS64.so
FileUsage = 1
Прописал DSN в odbc.ini
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
# cat /etc/odbc.ini
[zkteco]
Description = ZKAccess
Driver = MDBToolsODBC
#Driver = /usr/lib/libodbc.so.1.0.0
Servername = localhost
Database = /oracle/doc/php/zkteco/ZKAccess.mdb
UserName =
Password =
port = 5432
Собсно к базе подключаюсь, работать с ней можно, но весьма в ограниченных условиях.
Например при операторе select невозможно отсортировать вывод - ругается на order by
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
# isql zkteco
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from USERINFO order by USERID
Error at Line : syntax error near order
SQLRowCount returns 0
Или например не дает форматировать даты
1.
2.
3.
SQLRowCount returns 0
SQL> select Format(BIRTHDAY,"yyyy-mm-dd") from USERINFO
Error at Line : syntax error near (
SQLRowCount returns 0
Что не так, что можно сделать или мож я неправильно что-то в запросах пишу?
