RE: [PHP-DB] ODBC and SQL Server
| From: | Andrew Hill | Date: | Wed, 05 Sep 2001 19:25:41 +0000 |
| Subject: | RE: [PHP-DB] ODBC and SQL Server | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12182@lists.php.net to get a copy of this message | ||
Well, does the "Test" button on your ODBC Admininstrator shed any light? :)
If it works there, and doesn't work in your PHP, create an ODBC Trace in the
Administrator so you can see the exact parameters of the connect.
HTH
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Todd Cary [mailto:todd@aristesoftware.com]
> Sent: Wednesday, September 05, 2001 2:49 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] ODBC and SQL Server
>
>
> I am trying to setup an ODBC connect to SQL Server. My DSN is
> "Acct32_ODBC". I am using NT Authentication, so that could be my
> problem.
>
> odbc_connect("Acct32_ODBC", "", "");
>
> Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user
> 'PENTIUM3\IUSR_PENTIUM3'., SQL state 28000 in SQLConnect in
> C:\Webroot\testodbc.php on line 33
>
> Any suggestions on how I can resolve this?
>
> Many thanks.....
>
> Todd
> --
> Todd Cary
> Ariste Software
> todd@aristesoftware.com
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>