Help AdoDB with PHP

Bidibule

Hi everyone!

Well let's resume, I'm using PHP and Access 2000 and I connect a Access Database btw of an IS Windows Server using this portion of code :

<?php

$dbc = new COM("ADODB.Connection");
$dbc->Open("Driver={Microsoft Access Driver (*.mdb)};DBQ=x:\db\abn.mdb"); //where x: is the drive of the server...

it works and I'm using function like "$result->Fileds[$x]->value"...
to get whatever i want..

But I saw that there were other function like "GetArray()" - "UserDate()", "MetaType()",etc that I would like to use but it always say : Unable to lookup metatype: Unknown name. in ...

I wanna know why it always says that and how to get these functions working for me!

Thx

Ben

PS : What's the difference between

$dbc = new COM("ADODB.Connection");
$dbc->Open("Driver={Microsoft Access Driver (*.mdb)};DBQ=x:\db\abn.mdb");

and

include('adodb.inc.php');

$conn = &ADONewConnection('access');

$conn->PConnect('xxx');
$recordSet = &$conn->Execute('select * from products'

bastien

the first is a db function, its more object oriented programming to abstract the db functions from the code...makes it easier to change if the db changes

conisder using the built it odbc connections instead

<?php

  // Program to test connecting to a Microsoft Access ODBC Data Source
  $connection = odbc_connect("postcard", "", "");
  print "Connected to datasource<BR><BR>";

  if ($result = odbc_exec($connection, "SELECT * FROM mytable"))
    print "Command executed successfully<BR><BR>";
  else
    print "Error while executing command<BR><BR>";

  // Print results
  while(odbc_fetch_row($result))
    print odbc_result($result, 1) . "   " . odbc_result($result, 2) . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) . "   " . odbc_result($result, 5) . "<BR>";

  odbc_close($connection);
  print "<BR>Connection closed.";

?>