Problems connectiong to MS Access DB

djwinder

I have to be able to access the data held within an MS Access database as part of a function of my site. I have been using the below code and recive the 'cannot open with driver' error can anyone understand why?

//here is the file

<?php

$db = 'C:\web\membership.mdb';

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

// Two ways to connect. Choose one.
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.');
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.');

$sql = 'SELECT forename, surname
FROM member
ORDER BY forename';
$rs = $conn->Execute($sql);

<table>
<tr>
<th>forename</th>
<th>surname</th>

</tr>
<?php while (!$rs->EOF) { ?>
<tr>
<td><?php echo $rs->Fields['forename']->Value ?></td>
<td><?php echo $rs->Fields['surname']->Value ?></td>
</tr>
<?php $rs->MoveNext() ?>
<?php } ?>
</table>

<?php

$rs->Close();
$conn->Close();

$rs = null;
$conn = null;

thorpe

Try using the jet driver that you have commented out.

djwinder

I should have said that i have already tried that and still no luck, have you any other ideas of what the problem might be?

ab4net

please have you find a solution ..!! the problem same am facing, more over, i have :
Fatal error: Cannot instantiate non-existent class: com in /public_html/access/index.php on line 5
the problem also that am using a shared hosting !! please can you help !!?

djwinder

I havent found a solution yet i was hoping for more help, i have tried both the jet and the access drivers with no luck, if i find a solution i will let you know and keep checking this forum

AIS4U

djwinder:

I don't promise it will work for you, but you might try this code:

Connecting to an access database was as simple as the following for me.

odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" . str_replace("/", "\", $_SERVER["DOCUMENT_ROOT"]) . "_database\dbname.mdb", "", "")

Hope it works for you.

Good Luck

djwinder

Thank you very very much for your advice this is a problem that has me stumped. Unfortunatly it didnt seem to work with the page being blank, is their anything obviouse that i might be doing wrong? here is the code below:

<?php

$db = 'C:\web\membership.mdb';

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" . str_replace("/", "\", $_SERVER["DOCUMENT_ROOT"]) . "\web\membership.mdb", "", "")

// Two ways to connect. Choose one.
//$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.');
//$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.');

$sql = 'SELECT forename, surname
FROM member
ORDER BY forename';
$rs = $conn->Execute($sql);

<table>
<tr>
<th>forename</th>
<th>surname</th>

</tr>
<?php while (!$rs->EOF) { ?>
<tr>
<td><?php echo $rs->Fields['forename']->Value ?></td>
<td><?php echo $rs->Fields['surname']->Value ?></td>
</tr>
<?php $rs->MoveNext() ?>
<?php } ?>
</table>

<?php

$rs->Close();
$conn->Close();

$rs = null;
$conn = null;

napper

It would probably work if you told php what rs was. For example:

<?php

$db = 'C:\web\membership.mdb';

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');
$rs = new COM('ADODB.Recordset') or exit('Cannot create rs');

odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" . str_replace("/", "\", $_SERVER["DOCUMENT_ROOT"]) . "\web\membership.mdb", "", "")

$sql = 'SELECT forename, surname
FROM member
ORDER BY forename';
$rs = $conn->Execute($sql);

<table>
<tr>
<th>forename</th>
<th>surname</th>

</tr>
<?php while (!$rs->EOF) { ?>
<tr>
<td><?php echo $rs->Fields['forename']->Value ?></td>
<td><?php echo $rs->Fields['surname']->Value ?></td>
</tr>
<?php $rs->MoveNext() ?>
<?php } ?>
</table>

<?php

$rs->Close();
$conn->Close();

$rs = null;
$conn = null;

See if that works for you.

napper

The following worked for me:

<?

$conn = new COM('ADODB.Connection') or die('Could not make conn');
$rs = new COM('ADODB.Recordset') or die('Coult not make rs');

$connstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\web\\test.mdb";

$conn->Open($connstring);

$sql = "SELECT firstname, lastname FROM t_users";

$rs->Open($sql, $conn, 1, 3);

while(!$rs->EOF) {
	print($rs->Fields['firstname'] . " " . $rs->Fields['lastname'] . "\n");
	$rs->MoveNext();
}

$rs->Close();

$conn->Close();

$rs=null;
$conn=null;

?>

It outputed:

C:\web>C:\PHP5.1.4\php-cgi.exe test.php
X-Powered-By: PHP/5.1.4
Content-type: text/html

Travis Conway
Jeff Evans
Bill Clinton
George Bush
Ronald Regan