[Phpwm] connecting to Access database

David J Lodwig David_J_Lodwig at birmingham.gov.uk
Thu Jun 1 13:30:08 BST 2006

If dvam is the folder I think you have forgotten to specify the address or 
name of the server from the string, maybe something like 

odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=\\servername\dvam\lionheart.mdb", "", "","SQL_CUR_USE_ODBC");

might work.

David J. Lodwig
Learning Technology Developer
BASS Learning Technology

alan dunn <alan at dunns.co.uk> 
Sent by: phpwm-bounces at mailman.lug.org.uk
01/06/2006 12:40
Please respond to
phpwm at mailman.lug.org.uk

phpwm <phpwm at mailman.lug.org.uk>

[Phpwm] connecting to Access database

The manual says we can do this, but I am struggling.

We are trying to connect to an access database on a windows machine via 
our linux server. The db is lionheart.mdb and it is in a folder dvam. We 
have mapped the folder dvam on the linux server and can see the db 
within it.

We are then trying to use this string, with no result at all:

odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=\\dvam\lionheart.mdb", "", "","SQL_CUR_USE_ODBC");

thanks, alan dunn

Phpwm mailing list
Phpwm at mailman.lug.org.uk

The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 464 4444 Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.lug.org.uk/pipermail/phpwm/attachments/20060601/f80d491a/attachment.html

More information about the Phpwm mailing list