Re: MS SQL error...I've come a long way to get this far
| From: | Fred Silsbee | Date: | Mon, 08 Dec 2008 20:30:26 +0000 |
| Subject: | Re: MS SQL error...I've come a long way to get this far | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45773@lists.php.net to get a copy of this message | ||
I was just thinking about something I've never understood completely!
mssql_connect($server, 'sa', 'PW'); presumes the server doesn't have all
the permissions in spite of the fact that it has the password.
The password I gave is the XP Prof login PW.
Maybe some other PW.
--- On Mon, 12/8/08, Fred Silsbee <fredsilsbee@yahoo.com> wrote:
> From: Fred Silsbee <fredsilsbee@yahoo.com>
> Subject: MS SQL error...I've come a long way to get this far
> To: php-db@lists.php.net
> Date: Monday, December 8, 2008, 7:13 PM
> many changes to php.ini to get this far..whew!
>
> PHP 5.2.7 just got jerked out from underneathe me (I
> have't replaced it since this is a simple script)
>
> phpinfo works!
>
> <?php
> // Server in the this format:
> <computer>\<instance name> or
> // <server>,<port> when using a non default
> port number
> $server = 'LANDON\SQLEXPRESS';
>
> $link = mssql_connect($server, 'sa', 'PW');
> <<<<< line 6
>
> if(!$link)
> {
> die('Something went wrong while connecting to
> MSSQL');
> }
> ?>
>
>
> Warning: mssql_connect() [function.mssql-connect]: Unable
> to connect to server: LANDON\SQLEXPRESS in
> C:\Inetpub\wwwroot\trymssql.php on line 6
> Something went wrong while connecting to MSSQL