[unixODBC-support] this select is not working...

Nick Gorham nick.gorham at easysoft.com
Thu May 15 16:31:17 BST 2008


Xavier Colomer Pagès wrote:

>I'm trying to access to a ms access database located on a nfs directory.
>
>I can do simple queries, all is working ok
>
>But if I try to make queries to multiple tables it gives this error:
>
>*Warning*: odbc_fetch_row()
>[function.odbc-fetch-row<http://192.168.0.203/function.odbc-fetch-row>]:
>No tuples available at this result index in */var/www/db.php* on line *23
>
>If I look for the number of rows is 0, but if I test this query on ms access
>software on a windows Box all is OK.
>
>I don't understand.
>
>*[MDBToolsODBC]
>odbcinst.ini
>Driver = /usr/lib/libmdbodbc.so.0
>Usage = 1
>FileUsage = 1
>  
>
I don't think the mdb tools folk would mind me describing the driver as 
beta, its inpressive that it works as well as it does IMHO.

Until MS release the internal format for MDB files (and don't then 
change it five minutes later) its a bit of a problem trying to write a 
mdb driver

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list