Access2000 Database &apache Server help!

standalone

hi,..

how can I connect to Access2000 Database and by using ODBC

my database is on "c:\standalone.mdb"

Note:

Apache server & PHP4.

thanks for your help

Anon

I believe you will need to first create the ODBC association in the ODBC32 control panel. Its been a while since I have done this, but I believe you setup a System DNS entry for the database, assign it an ODBC name (this should all be fairly self explanatory in the control panel) and then connect to it per the ODBC PHP instructions.

John

garyr

Add your Access database on the System DSN
(Windows Control Panel/ODBC Data Sources)
and name it say.. "Test_Db"

Then try doing something like this:

--
<?php
$dsn = "Test_Db";
$dbuser = '';
$dbpasswd = '';

$dbconn_id = odbc_connect($dsn, $dbuser, $dbpasswd);

$sql_cmd = "SELECT * FROM table_name";
$result = odbc_exec($dbconn_id, $sql_cmd);
$numrows = 0;

while($query_id = odbc_fetch_row($result)) {
$field1 = odbc_result($result, "field1");
$field2 = odbc_result($result, "field2");
$fieldn = odbc_result($result, "fieldn");
echo "$field1 | $field2 | $ffieldn <p>";
$numrows++;
}

echo "$numrows rows returned <p>";
odbc_close($dbconn_id);