From: [EMAIL PROTECTED] 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 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]