OK, i have an SQL_Layer.php file etc, and in it it has functionality for ODBC mSQL, MySQL etc, (and a ton of others).

any how, with it, it connects to the ODBC Server using:

PHP Code:
odbc_connect($db,$user,$password); 
now for $db, i have put my ODBC Datasource name "SearchAccess"

and i set it all up right, (i think).

in my cp/admin tools/ data sources (odbc)

made a new data source, and made a new MS Access database.

etc.

and ne how, i added a username of "user" and password of "pass" and checked it with some SQL Queries,

now, on the php script, i set error_reporting to E_ALL

and so on,

any how, it does the SQL for it by:

PHP Code:
odbc_exec($id,$query);
// $id being the connection ID 
any how, no errors are returned by the sql query, no warnings, nothing, but, no tables are created, or no inserts are done on the tables,

so im wondering, how do i go about doing a ODBC Data Source with php? (The $db should be the name? or?)

ta