How Can I establish an DSN-les connection to Acces

[Anon]

Hi.

How Can I establish an DSN-less connection to an Access database?
My Database is not an ODBC-Datasource, known, to Windows
I get it by e-mail and want to extract some Data from it, using just full Windows path to this database

Can this be done?
Some code extract would help me very much

Thanx in advance
Yurij

[Anon]

Hi Yurij,

yes this is possible, but not with PHPs odbc_*-function. Instead you must
use a COM object. Here's a code snipped which requires ADO to be installed
on your machine. If you have IIS 4 or M$ PWS installed on your machine
there's a greate chance you have ADO installed as well.

<?
$dbc = new COM("ADODB.Connection");

$connstr = "DRIVER={Microsoft Access Driver (.mdb)};";
$connstr .= "DBQ=C:\path\to\db\test.mdb;uid=;pwd=;";
$dbc->open($connstr);
$rs = $dbc->execute("SELECT FROM test");
while(!$rs->eof()) {
print $rs->fields['id']->value();
print "|".$rs->fields['name']->value()."<br>";
$rs->movenext();
}
$dbc->close();
?>

[Anon]

The code does its job fine, but it is generating a worning aswell saying,

Warning: Unsupported variant type in D:\host\www.site.com\test_db.php on line 13

before svery iteration.

How can the error message be suppress, or better trapped?