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
dbc: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);
}
?>
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

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);
}
?>