[support] Drupal SQL function and DB Access

[Larry Garfield]

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.  

-- 
Larry Garfield
larry at garfieldtech.com