MS Access connection problem

admin

Administrator
Staff member
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);
}
?>
 
Back
Top