[mdb-dev] ISQL and DataManager problem to access mdb file

[<eri...@ac...>]

Hi,
i have a problem on a RH 7.3 on a itanium 64 bit

i installed unixODBC and MDBtools
and configured odbc like this

odbcinst.ini

[PostgreSQL]
Description         = ODBC for PostgreSQL
Driver         = /usr/lib/libodbcpsql.so
Setup         = /usr/lib/libodbcpsqlS.so
FileUsage         = 1

[ODBC]
Trace         = Yes
Trace File         = /tmp/sql.log
Pooling         = No

[msACCESS]
Description         =
Driver         = /opt/mdbtools/lib/libmdbodbc.0.0.0
Setup         = /opt/mdbtools/lib/libmdbodbc.0.0.0
FileUsage         = 1
CPTimeout         =
CPReuse         =


odbc.ini
[constatBEA9802]
Description         = msACCESS
Driver         = msACCESS
Database         = /mnt/cdrom/bea.mdb

When i do isql -v constatBEA9802
it's ok i'm connected
but when i type help to have the list of tables isql crashes

here's the /tmp/sql.log

[ODBC][2210][__handles.c][357]
       Exit:[SQL_SUCCESS]
               Environment = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][294]
       Entry:
               Handle Type = 2
               Input Handle = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][383]
       Exit:[SQL_SUCCESS]
               Output Handle = 0x6000000000007150
[ODBC][2210][SQLConnect.c][2125]
       Entry:            
               Connection = 0x6000000000007150            
               Server Name = [constatBEA9802][length = 14 (SQL_NTS)]  
        
               User Name = [][length = 0 (SQL_NTS)]            
               Authentication = [][length = 0 (SQL_NTS)]
[ODBC][2210][SQLConnect.c][2672]
       Exit:[SQL_SUCCESS]
[ODBC][2210][SQLError.c][360]
       Entry:                
               Connection = 0x6000000000007150                
               SQLState = 0x60000fffffff90e0                
               Native = 0x60000fffffff90f4                
               Message Text = 0x60000fffffff8ee0                
               Buffer Length = 500                
               Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][396]
       Exit:[SQL_NO_DATA]
[ODBC][2210][SQLError.c][439]
       Entry:                
               Environment = 0x6000000000006c00                
               SQLState = 0x60000fffffff90e0                
               Native = 0x60000fffffff90f4                
               Message Text = 0x60000fffffff8ee0                
               Buffer Length = 500                
               Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][475]
       Exit:[SQL_NO_DATA]
[ODBC][2210][SQLAllocHandle.c][430]
       Entry:
               Handle Type = 3
               Input Handle = 0x6000000000007150
[ODBC][2210][SQLAllocHandle.c][787]
       Exit:[SQL_SUCCESS]
               Output Handle = 0x6000000000025e30
[ODBC][2210][SQLTables.c][148]
       Entry:            
               Statement = 0x6000000000025e30            
               Catalog Name = [NULL]            
               Schema Name = [NULL]            
               Table Name = [NULL]            
               Table Type = [NULL]
[ODBC][2210][SQLTables.c][369]
       Exit:[SQL_SUCCESS]
[ODBC][2210][SQLNumResultCols.c][129]
       Entry:            
               Statement = 0x6000000000025e30            
               Column Count = 0x60000fffffff12c0
[ODBC][2210][SQLNumResultCols.c][220]
       Exit:[SQL_SUCCESS]                
               Count = 0x60000fffffff12c0 -> 0
[ODBC][2210][SQLNumResultCols.c][129]
       Entry:            
               Statement = 0x6000000000025e30            
               Column Count = 0x60000fffffff1140
[ODBC][2210][SQLNumResultCols.c][220]
       Exit:[SQL_SUCCESS]                
               Count = 0x60000fffffff1140 -> 0
[ODBC][2210][SQLFetch.c][142]
       Entry:            
               Statement = 0x6000000000025e30

I have the same problem with Datamanager ...
seems like it crashes with SQLTables !!???

When i do mdb-tables /mnt/cdrom/bea.mdb
i have no table list ie a blank line

eric