|
|
Posted by Jerry Stuckle on 08/31/06 14:48
Advo wrote:
> Jerry Stuckle wrote:
>
>>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
>>==================
>
>
>
>
>
> yea i think thats the problem because ive got this now, with errors
> turned on:
>
> start
> Fatal error: Call to undefined function mssql_connect() in
> /home/default/site/user/htdocs/testmssql.php on line 5
>
>
>
> so basically i need to do extension=php_mssql.dll in my php.ini?
>
Yes, if everything else is set up correctly that should do it.
It's also a good idea to check the settings in the [MSSQL] section of
your php.ini.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
[Back to original message]
|