ID: 21928 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: Win2k server PHP Version: 4.3.0 New Comment:
I'll run your test in the morning. It might be notable that I can run my script from the command line and have no problems connecting to the ODBC DSN. But when I run it through IIS, it fails. I ran this same script on my local win2k pro desktop and it works fine. This is only happening on my win2k server. I searched the net and see lots of people with this same issue, but cannot find a single one that has a resolution. Previous Comments: ------------------------------------------------------------------------ [2003-01-28 22:40:06] [EMAIL PROTECTED] I don't believe this is a PHP bug itself at all. First off what version of the MDAC are you using? Second can you try doing the following: $dbh = odbc_connect(); // yes I know it will fail $res = odbc_data_source($dbh, SQL_FETCH_FIRST); And print out the results of the $res, and call the data_source() a few more times with SQL_FETCH_NEXT instead of SQL_FETCH_FIRST? Thanks ------------------------------------------------------------------------ [2003-01-28 18:47:07] [EMAIL PROTECTED] This is a system DSN. Here is the output from the lines you sent me. Content-type: text/html X-Powered-By: PHP/4.3.0 resource(1) of type (odbc link) ------------------------------------------------------------------------ [2003-01-28 18:17:10] [EMAIL PROTECTED] Is "ti_readonly" a userDSN or a systemDSN? Run this EXACT script from the COMMAND LINE on your server and report the output: <?php var_dump(odbc_connect("ti_readonly","TI_readonly","TI_readonly")); ?> ------------------------------------------------------------------------ [2003-01-28 16:57:44] [EMAIL PROTECTED] PHP cannot find a valid ODBC datasource. Even though the DSN has been verified and connected to with other products like MS access. The DSN points to a SQL Server database. To complicate matters, PHP can see a DSN that was previously created on for the same SQL server instance. But when trying to create any new DSN, PHP cannot see it. This app was run on my local win2k pro box and worked fine. When I moved it to my Win2k server, it cannot fins the ODBC DSN. I see other bug posts that have had the same problem, yet reponses say that it is not a bug. Line 10 > $connect_TI = odbc_connect("ti_readonly","TI_readonly","TI_readonly"); Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\inetpub\wwwroot\survey\survey.php on line 10 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21928&edit=1