Posted by Jerry Stuckle on 08/30/06 17:35

Kim André Akerø wrote:
> Advo wrote:
>
>
>>Im having major problems trying to connect to a mssql database thats
>>hosted on our server.
>>
>>I've got the ip, username, password and database name, yet no matter
>>what i try, I cant seem to connect. I've trawled the net for hours
>>looking for code, has anyone got any that definately works, or just a
>>simple way I can check the connection.
>
>
> I don't know how you've tried it, but you should be doing something
> like this in your code:
>
> mysql_connect($ip, $username, $password);
> mysql_select_db($database);
>
> You should also be doing this on the server, and not directly from
> home. Security settings on the database server will only allow
> connections from a certain IP (or IP range).
>

Except he's using MS SQL Server, not MySQL. But the statements are the
same - just substitute 'mssql' for 'mysql'.

It's hard to say without knowing what error messages you get. Did you
check the user notes for mssql_connect at
http://www.php.net/manual/en/function.mssql-connect.php? They contain
some good information.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]