Re: PHP 4/MS Sql Server
| From: | Frank M. Kromann | Date: | Tue, 04 Dec 2001 18:56:54 +0000 |
| Subject: | Re: PHP 4/MS Sql Server | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-10731@lists.php.net to get a copy of this message | ||
Hi,
If your MS SQL Client is configured to use a non TCP/IP protocol as the default protocol you cant
connect using ip addresses. If it uses Named Pipes you have to use the netbios name of the server or
ask your ISP to configure a client connection for you, using a name (that you then use as first
param in mssql_connect) and the protocol that they select.
- Frank
> I've been doing this:
>
> <?
> $cn=mssql_connect (<IP address>, <UID>, <PWD>);
> mssql_select_db(<db> , $cn);
> ?>
>
> And it works like a dream on servers over which I have control. My ISP
> supports PHP4 (on Windows) and Ms Sql Server. They setup a db for me which
> I can connect to using Enterprise Manager. No matter how I cast
> mssql_connect(), thought, I can't get to their server from a script. I've
> tried names and ip addresses. Phpinfo() shows mssql extensions.
>
> Is there some other way I can connect?
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>