#21928 [Opn->Fbk]: Cannot find valid ODBC DSN

ID: 21928 Updated by: kalowsky@php.net Reported By: Matt.hintze@nana.com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Win2k server PHP Version: 4.3.0 New Comment: kept as feedback until testing done... Previous Comments: ------------------------------------------------------------------------ [2003-01-29 00:29:25] Matt.hintze@nana.com BTW: I am running MDAC 2.7 SP1 ------------------------------------------------------------------------ [2003-01-29 00:27:09] Matt.hintze@nana.com 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. ------------------------------------------------------------------------ [2003-01-28 22:40:06] kalowsky@php.net 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] Matt.hintze@nana.com 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] pollita@php.net 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")); ?> ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/21928 -- Edit this bug report at http://bugs.php.net/?id=21928&edit=1