MS Access connection problem

Anon

I get the following error when running my php page:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\program files\apache group\apache\htdocs\adodb\adodb-odbc.inc.php on line 67

However all the connections test ok in UltraDev (which I have used to write the page), i.e. the DSN is fine and returns records.

The following is my connection code. Thanks!

<?php
/ FileName="Connection_php_direct.htm" "driver=sun.jdbc.odbc.JdbcOdbcDriver|url=jdbc:odbc:newsletter|uid=|pword="
Type="JDBC"
Catalog=""
Schema=""
HTTP="false"
/
if(!isset($PHP_SELF)){
$PHP_SELF=getenv("SCRIPT_NAME");
}
if (!isset($QUERY_STRING)){
$QUERY_STRING="";
}
if (!isset($REQUEST_URI)){
$REQUEST_URI=$PHP_SELF;
}
$MM_connNewsletter_HOSTNAME = "localhost";
$MM_connNewsletter_DBTYPE = "access";
$MM_connNewsletter_DATABASE = "newslettertest.mdb";
$MM_connNewsletter_USERNAME = "";
$MM_connNewsletter_PASSWORD = "";
ADOLoadCode($MM_connNewsletter_DBTYPE);
$connNewsletter=&ADONewConnection($MM_connNewsletter_DBTYPE);
if($MM_connNewsletter_DBTYPE == "access" || $MM_connNewsletter_DBTYPE == "odbc"){
$connNewsletter->PConnect($MM_connNewsletter_DATABASE, $MM_connNewsletter_USERNAME,$MM_connNewsletter_PASSWORD);
} else if($MM_connNewsletter_DBTYPE == "ibase") {
$connNewsletter->PConnect($MM_connNewsletter_HOSTNAME.":".$MM_connNewsletter_DATABASE,$MM_connNewsletter_USERNAME,$MM_connNewsletter_PASSWORD);
} else {
$connNewsletter->PConnect($MM_connNewsletter_HOSTNAME,$MM_connNewsletter_USERNAME,$MM_connNewsletter_PASSWORD,$MM_connNewsletter_DATABASE);
}
?>

Anon

First of all,... if you don't have to use Access, DON'T. For a nice converter from Access code to MySQL go to http://www.accessmysql.com

But ok,... the reason why your script isn't working is:
$MM_connNewsletter_DATABASE = "newslettertest.mdb";

That won't work,... some standard script for connecting to an access database is:

   $dbname = "Customers";  //dsn name as in dsn system (ODBC configuration WIN32)
     $username = "";       
     $password = "";       

     $con=odbc_connect($dbname, $username, $password);      //don't change order

You have to go to your control panel and verify if the database exists in your computer's System DSN. Go To ODBC DATA sources, click System DSN and look if it's there. If not, add it,... speaks for itself I think.

Then the machine knows the database is there and you can call it with above's script. That's all, real easy.

Also take a look at http://www.phpbuilder.com/columns/siddarth20000228.php3