PHP and MSAccess

[KBeecher]

I am trying to access my Access database using PHP (and I am also new to web programming, so I could easily have overlooked something very simple!)

This is a snippet of code I am using:

PHP Code:

$db = "databaseName" #This is my DSN
    
$connection = odbc_connect($db, "", "");
$result = odbc_do($connection, "select * from table1");

odbc_result_all($result, "BORDER=1");
odbc_close($connection); 


I expected this file, when called, to display the contents of table1. I have also tried using the absolute path to the database to no avail.

Any help will be greatly appreciated.

[Jacob]

You can see a DSN-Less connection here: http://aspn.activestate.com/ASPN/Coo.../Recipe/163447

Hope that helps...

Regards,

Jacob