On Thursday 30 October 2008 5:03:47 am Davide Michel 'ZioBudda' Morelli wrote:
Larry Garfield ha scritto:
On Wednesday 29 October 2008 5:59:26 pm Davide Michel 'ZioBudda' Morelli
wrote:
Hi, In a client site I need to connect to a DB MS Access via Drupal.
Is this possibile ? How can I set the db and credentials ?
M.
Drupal currently does not support MS Access, and I don't believe it would be at all feasible to do so in Drupal 6.
A moment. I don't want to install Drupal 6 on a MS Acess. I need only to connect to it. I need to exec some query.
M.
Your best bet at that point is to bypass Drupal's DB layer entirely. Drupal is still PHP, so if you can connect to Access via PHP then you can connect to it from Drupal the exact same way.
Good luck connecting to Access via PHP. :-) ODBC is probably your best bet, and if you can make it work I suggest using the PDO-ODBC driver rather than the nightmare that is the legacy ext/odbc driver. Be prepared for a lot of hassle either way, though. I suggest the php-general mailing list, #PHP IRC channel, or other common PHP support channels for figuring out how to talk to Access from PHP.