Bug #13312: cant connect to a odbc source
| From: | parabips at hotmail dot com | Date: | Sat, 15 Sep 2001 08:04:27 +0000 |
| Subject: | Bug #13312: cant connect to a odbc source | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-65987@lists.php.net to get a copy of this message | ||
From: parabips@hotmail.com
Operating system: Windows2000 server
PHP version: 4.0.6
PHP Bug Type: ODBC related
Bug description: cant connect to a odbc source
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
--
Edit bug report at: http://bugs.php.net/?id=13312&edit=1