Bug #13312: cant connect to a odbc source

From: 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

« previous php.dev (#65987) next »