note 15522 added to ref.odbc
| From: | parabips at hotmail dot com | Date: | Sat, 15 Sep 2001 07:49:35 +0000 |
| Subject: | note 15522 added to ref.odbc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-18040@lists.php.net to get a copy of this message | ||
I tried to connect with a Microsoft Access database but it didnt work.
I made the DSN named reg and then I used the following code to connect
$connection=odbc_connect("reg","admin","") or die ("Cant connect
the datasource");
$sql="Select * from newuser order by name asc";
$sql_statement=odbc_prepare($connection,$sql) or die ("Cant prepare statement");
$sql_result=odbc_execute($sql_statement) or die ("Cant execute query");
odbc_result_all($sql_result,"border=1");
odbc_free-result($sql_result);
odbc_close($connection);
when i view the php page it says
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
can anyone solve my problem
http://www.php.net/manual/en/ref.odbc.php