ID: 21928
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-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] [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
