Re: ODBC and SQL Server
| From: | Ron Litzenberger | Date: | Sat, 08 Sep 2001 15:41:02 +0000 |
| Subject: | Re: ODBC and SQL Server | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12265@lists.php.net to get a copy of this message | ||
Are u still having password problems? What I did was use a sql account and
not the NT account. So create a user account is SQL then set the odbc
driver to connect using that account. I belive the reason the NT account
wont work is because the account running PHP has permissions set to
everyone and hopefully your database isn't.
Ron Litzenberger
"Todd Cary" <todd@aristesoftware.com> wrote in message
news:3B9673B6.47BBFE1F@aristesoftware.com...
> 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
>
>