note 36707 deleted from ref.odbc by sniper
| From: | sniper@php.net | Date: | Tue, 04 Nov 2003 00:38:38 +0000 |
| Subject: | note 36707 deleted from ref.odbc by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59769@lists.php.net to get a copy of this message | ||
Note Submitter: oliver D O T pliquett @ m93 D O T d e
----
I post this since my hair turned gray during the last two days:
If you ever try to connect to a local MS SQL Server via PEAR and odbc, try this dsn:
$dsn = "ODBC://user:passw@ODBC_name";
where ODBC_name is the name you gave to it in your control panel ODBC manager.
No host name!!!
Also take a look at your SQL Server manager:
in the security-tab of the property-dialogue of your (local) server, select "authentication by
SQL server and Windows"
so your SQL server users are accessible. And last - not least make sure your odbc config is made as
a system-DSN.
(mssql2000 preview / IIS 5.1 / PHP4.3.3 as isapi)
Happy hacking
Oliver ;-)