[PHP-WIN] R: [PHP-WIN] Using ODBC

[Alberto. Sartori]

I've used several times an ODBC Connection with Access db. I used the COM object. I 
found a simply example:

$dbname="prova.mdb";     
$query="SELECT * FROM users";

$connessione=new COM("ADODB.Connection");
$connessione->Open("DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=C:\\inetpub\\wwwroot\\$dbname");
$rs=$connessione->execute($query);
if (!$rs->EOF)
 {
  while (!$rs->EOF)
  {
   $campo1=$rs->fields("name");
   $campo2=$rs->fields("surname");
   $campo3=$rs->fields("email");
   echo $campo1->value."<br>";
   echo $campo2->value."<br>";
   echo $campo3->value."<br><hr>";
  $rs->movenext();
  }
 }
$rs->close;
?>


-----Messaggio originale-----
Da: Someone Somewhere [mailto:[EMAIL PROTECTED]]
Inviato: giovedì 4 aprile 2002 17.45
A: [EMAIL PROTECTED]
Oggetto: [PHP-WIN] Using ODBC


Does anyone have any experience using ODBC to connect to an Access database,
I'm runing php and Apache in Windows 2000. Any help will be apreciated.


Thanks
Someone



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php