#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: 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 Previous Comments: ------------------------------------------------------------------------ [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")); ?> ------------------------------------------------------------------------ [2003-01-28 16:57:44] Matt.hintze@nana.com 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