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.
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.
For Drupal 7, connecting to an MS SQL server is hypothetically possible using Microsoft's new MS SQL PDO driver, but a Drupal driver for MS SQL would still need to be written and maintained. I am not aware of any community effort to do so at this time.
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.
On Thu, 30 Oct 2008 11:03:47 +0100 Davide Michel 'ZioBudda' Morelli michel@ziobudda.net 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.
Your best bet would be odbc but it's not going to be nice. Or you could think about importing the data... after all Access has(had?) a bad reputation for concurrent access [sic].
http://www.php.net/manual/en/faq.databases.php#faq.databases.access http://bryanmills.net/archives/2003/11/microsoft-access-database-using-linux...
Get ready to have DB corruption or do further research about the sanity of working with Access at the back end.
Quoting Davide Michel 'ZioBudda' Morelli michel@ziobudda.net:
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.
You can create an MS Access db engine. That would be the only way to accomplish this in a drupalish way. You can also just do the PHP calls yourself.
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
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.
-
Davide Michel 'ZioBudda' Morelli -
Earnie Boyd -
Ivan Sergio Borgonovo -
Larry Garfield