Re: Trouble connecting to MSSQL 2k DB
| From: | Jorge Giménez Mayorgas | Date: | Fri, 14 Sep 2001 10:37:45 +0000 |
| Subject: | Re: Trouble connecting to MSSQL 2k DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12439@lists.php.net to get a copy of this message | ||
Try put the php dlls on %systemroot%/system.
I have IIS 5.0 + PhP 4.0.6 + MSSQL on a W2k server working perfectly.
Later,
Jorge Giménez
----- Original Message -----
From: "Sean Swehla" <sswehla@vpn-solution.net>
To: <php-db@lists.php.net>
Sent: Thursday, September 13, 2001 8:10 PM
Subject: [PHP-DB] Trouble connecting to MSSQL 2k DB
> I'm running Win2k server, with MSSQL 2k, & PHP 4.0.6. Every time I try
> to connect to the SQL sesrver within the script I get the following
> output:
>
> X-Powered-By: PHP/4.0.6
> Content-type: text/html
>
> Warning: MS SQL message: Login failed for user 'tu'. Reason: Not
> associated with a trusted SQL Server connection. (severity 14) in [script
> path] on line 9
>
> Warning: MS SQL: Unable to connect to server: PHP in [script path] on
> line 9
>
> Warning: MS SQL: Unable to connect to server: (null) in [script path]
> on line 10
>
> Warning: MS SQL: A link to the server could not be established in
> [script path] on line 10
>
> Lines 9 & 10 are as follows:
>
> $link_identifier = mssql_connect($server, $user, $pw);
> mssql_select_db($db);
>
> I have the php_mssql.dll file installed in %systemroot%/system32 and the
> appropriate line in php.ini. I've found hundreds of references on various
> websites and in the mailing list archives to php_mssql70.dll, but cannot
> locate it anywhere. Any help/thoughts/guidance would be appreciated.
>
> -=-=-
> Sean Swehla, MCP
> Network Architect
> VPN Solutions, LLC
>
> --
> 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
>
>