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

ID: 21928 Updated by: pollita@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: 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")); ?> Previous Comments: ------------------------------------------------------------------------ [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