note 36707 added to ref.odbc

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 ;-) ---- Manual Page -- http://www.php.net/manual/en/ref.odbc.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+36707 Delete -- http://master.php.net/manage/user-notes.php?action=delete+36707&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+36707&report=yes Search -- http://master.php.net/manage/user-notes.php