mdbtools over samba fs.

inittab <[email protected]> Mon, 2 Aug 2010 03:16:31 -0400
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
Hello, I'm attempting to access an access database via php with a
unixodbc connection.

if I copy the mdb database over to the local filesystem I have no
issues and can query the database fine. But if I try to access it over
my samba mounted directory I get the following error:

Can't alloc filename
Unable to locate database /mnt/netops/20101.mdb


/mnt/netops was mounted with the following command:
mount -t cifs -o username=XXXXXXXXX,password=XXXXXXXX
//10.2.1.XX/NetOps /mnt/netops

I can read files off of the share fine, and can copy the database off
but it seems unixodbc cannot access the file.

root@laptop:~# file /mnt/netops/20101.mdb
/mnt/netops/20101.mdb: Microsoft Access Database


/etc/odbc.ini:
[NetOps]
Description = Netops Database
Driver = MDBToolsODBC
Database = /mnt/netops/20101.mdb
Servername = localhost
UserName =
Password =
port = 5432

I am using the mdbtools driver:
[MDBToolsODBC]
Description = MDB Tools ODBC drivers
Driver = /usr/lib/libmdbodbc.so.0
Driver64 =
Setup =
Setup64 =
UsageCount = 1
CPTimeout =
CPReuse =




Any help is appreciated.

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm