[unixODBC-support] LIST TABLES unixODBC & mdbtools on fc3

eric belenfant eric.belenfant at ac-orleans-tours.fr
Mon Jan 24 14:35:03 GMT 2005


eric belenfant wrote:

> Hi i use unixODBC-2.2.9.1 on a Fedora core 3
> and i want to access MS Access databases with mdbtools ...
> i use mdbtools-0.5.1
> here is the odbc.ini file
>
> and the odbcinst.ini file
>
> when i try strace isql -v test 2>st.log
> and do list tables i have in the output
> /    SQLRowCount returns 0
> /looping why
>
> here is the st.log where i can see the testUNIX table ...
>
>
> semop(32769, 0xfeee7070, 2)             = 0
> semop(32769, 0xfeee7080, 1)             = 0
> ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, {B38400 opost isig icanon echo 
> ...}) = 0
> fstat64(3, {st_mode=S_IFREG|0755, st_size=475136, ...}) = 0
> lseek(3, 8192, SEEK_SET)                = 8192
> read(3, "\2\1\336\v\0\0\0\0\32\4\0\0Y\6\0\0\23\0\0\0\0\0\0\0\1\0"..., 
> 4096) = 4096
> fstat64(3, {st_mode=S_IFREG|0755, st_size=475136, ...}) = 0
> lseek(3, 24576, SEEK_SET)               = 24576
> read(3, "\1\1Y\7\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247"..., 
> 4096) = 4096
> fstat64(3, {st_mode=S_IFREG|0755, st_size=475136, ...}) = 0
> lseek(3, 57344, SEEK_SET)               = 57344
> read(3, "\1\1-\t\2\0\0\0\0\0\0\0\23\0\265\17d\17\v\17\264\16_\16"..., 
> 4096) = 4096
> write(1, "+------------------------------+"..., 33) = 33
> write(1, "|Tables                        |"..., 33) = 33
> write(1, "+------------------------------+"..., 33) = 33
> write(1, "|testUNIX                      |"..., 33) = 33
> write(1, "+------------------------------+"..., 33) = 33
> ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, {B38400 opost isig icanon echo 
> ...}) = 0
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
> write(1, "SQLRowCount returns 0\n", 22) = 22
>
>
SORRY i forgot the ini files

here is the odbc.ini file
[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/lib/libmdbodbc.so.0
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =

[MySQL ODBC 3.51 Driver]
DRIVER          = /usr/lib/libmyodbc3.so
SETUP           = /usr/lib/libmyodbc3S.so
FileUsage               = 1

and the odbcinst.ini file

[test]
Description = test
Driver = MDBToolsODBC
Database = /root/testUNIX.mdb
Servername = localhost
UserName =
Password =
port = 5432


-- 
eric BELENFANT
Tel : 02.38.79.45.98
Cellule PILOTAGE INFORMATIQUE
DEP - Division Etudes et Prospectives <http://dep.ac-orleans-tours.fr>
Rectorat d'Orléans-Tours <http://www.ac-orleans-tours.fr>




More information about the unixODBC-support mailing list