Bug #13312 Updated: cant connect to a odbc source

ID: 13312 Updated by: kalowsky Reported By: parabips@hotmail.com Old Status: Open Status: Closed Bug Type: ODBC related Operating System: Windows2000 server PHP Version: 4.0.6 Previous Comments: ------------------------------------------------------------------------ [2001-09-15 04:04:27] parabips@hotmail.com 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 this bug report at http://bugs.php.net/?id=13312&edit=1