-
Junior Member
Connecting to MS Access with PHP
Hi, I want to connect to an MS Access database without using an ODBC. Can someone help me? I have been researching this for a while now and haven't found anything that works. Maybe it's just me. Thanks.
-
Re: Connecting to MS Access with PHP
I dont think there is anything that works for connecting ms access without using odbc
while there are options available to connect mysql, oracle and ms sql server dbs
mysql - mysql_connect()
oracle - ocilogon()
ms sql server - mssql_connect()
using format like for example
$db = mysql_connect("localhost", "root", "password");
mysql_select_db("mydb",$db);
$result = mysql_query("select * from employees",$db);
there dont seem to be one available to connect ms access
however there is one product "php lens" which provides "adodb.inc.php"
using this "adodb.inc.php" you can connect to ms access
the format of which is
include("adodb.inc.php");
$db = newadoconnection('access');
$db->connect("localhost", "root", "password", "my_access_db");
regards
shivanna
Last edited by Shivanna; 01-23-2008 at 06:20 AM.
-
Junior Member
Re: Connecting to MS Access with PHP
Thank you for your help do you know anything about the other connection you were talking about? I found one that seems to connect, but then I don't know the syntax or how to write the code to work with it.
-
Re: Connecting to MS Access with PHP
I have not used adodb.php.inc exactly
You can find this at [[http:// adodb . sourceforge . net / # download]]
Have a look, You should be able to use it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules