Trying to use the datasource asset

yogibear · July 25, 2007, 12:55am

Hi all

I wish to use .mdb as a database type but unfortunately it doesn't seem to support it based on the dropdown list. :unsure:

cheers :lol:

aleks · July 25, 2007, 1:34am

Only Postgres, Oracle and MySQL are listed as supported, unfortunately you can't use access databases.

Avi_Miller · July 25, 2007, 2:27am

Correct – the DB Data Source can only use PostgreSQL, MySQL or Oracle based databases.

gsherwood · July 25, 2007, 7:09am

It can connect to MSSQL DBs as well.

yogibear · July 27, 2007, 1:05am

How can it connect to MSSQL DBs when the dropdown list as mentioned above have three selection only :unsure: . Can you please explain it, rather than going in circles.

Are we assuming of using the selection called OR Complete DSN ??? :blink:

cheers :lol:

gsherwood · July 27, 2007, 1:31am

To connect to any database support by PEAR::DB, enter the complete DSN into the box provided. The drop-down options are just the ones we can help construct a DSN for.

Avi_Miller · July 27, 2007, 4:08am

However, PHP needs to be compiled with SQL Server support, which is very rare. I don't know of any packaged version of PHP that ships with SQL Server support. Your system administrators would have to recompile PHP for this to work (much like getting Oracle support to work as well).