|
|
Posted by Advo on 08/31/06 14:13
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?
Navigation:
[Reply to this message]
|