#49545 [NEW]: PHP, IIS, MYSQL
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
Thread (3 messages)
- gezine at hotmail dot com