Posted by Jerry Stuckle on 08/31/06 13:29

Advo wrote:
> php etc is installed on our hosting, so not sure about that, i could
> possibly look into it if needs be. I just develop the php files, and
> then upload to our fasthosts dedicated server.. but we are running
> Microsoft SQL Server 2000 on our server..
>
>
> Chung Leong 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.
>>>
>>>
>>>Thanks
>>
>>What platform is PHP running on? What version of PHP? What API are you
>>using? Are you using integrated security? What version of SQL Server?
>>Without more information no one will be able to help you.
>
>

Turn on all errors and display them to see what you're getting:

ini_set('display_errors', '1');
error_reporting(E_ALL);

And phpinfo() will tell you if the mssql extensions are loaded in PHP.

Just having SQL Server on the system isn't enough. You also have to
enable it in php.

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

[Back to original message]