From: gezine at hotmail dot com Operating system: Windows PHP version: 5.3.0 PHP Bug Type: ODBC related Bug description: PHP, IIS, MYSQL
Description: ------------ Locally on my computer my connection to the database works fine but the moment I upload my file to the web server, and submit a form I receive the error. Webserver Information ----------------------- Operating System: Windows PHP Version: PHP 5.x IIS Version: IIS 7.0 code tried but no luck ---------------------- http://us3.php.net/manual/en/function.odbc-connect.php Reproduce code: --------------- function connect_to_database($dsn, $user, $password) { //create a connection to the database $conn = odbc_connect($dsn, $user, password,SQL_CUR_USE_DRIVER); //if the connection failed display the appropriate message if(!$conn) { output_error(); die(); }//end if(_); else { //return connection has been established. return $conn; }//end else }//end connect_to_database(_); Expected result: ---------------- I expected a successful return since every thing on the webserver(Godaddy) is setup correctly according to their test. Actual result: -------------- "Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in " -- Edit bug report at http://bugs.php.net/?id=49545&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49545&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49545&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49545&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49545&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49545&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49545&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49545&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49545&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49545&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49545&r=support Expected behavior: http://bugs.php.net/fix.php?id=49545&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49545&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49545&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49545&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49545&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49545&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49545&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49545&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49545&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49545&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49545&r=mysqlcfg
