Hi people, i'm hosting the MPOG web on my webdomain and the database is on my server. My problem is: It doesn't remotely connect. (Or i do it wrong way)
I'm getting this exact error:
Fatal error: Call to undefined function mssql_connect() in /home/restyleg/public_html/gunz/config.php on line 2
Yes people i did search, no answers.
wesman2232's Unofficial Fix Thread.
I'm using remote connection. And i can't acces dll's or something. (i use webhosting)Originally Posted by Linear88
Enable remote connections. Google that. It may take some time for it to work.
Already did that. But i'll walk al steps trough again. Thanx for trying to help ^^
And any "tips" on how to put in my info?
Like mssql_connect ("IP\SQLEXPRESS","sa","Password")
or mssql_connect ("IP","sa","Password")
Thanks Linear but Mambo is the second person that I know of that uses Remote-SQL I could not fix it for for the first one because wizkid set his up, I didn't know where the DB was (it wasn't on his comp) and his files was on the web-server (so I cant change any dll there D:)
@Mambo if you host the files on your comp I might be able to help :D
Should i use TCP/IP or Piped? Or both?
try TCP/IP first, then with Piped cause i think piped had something to do with ports, i cant remember the last time I tried to configure it.
You are right. It has to be TCP/IP!
And what about the ports? Something to do like (forwarding)? And do i've to set a port? But which one is used by MPOG web?
normal website port?
I don't think so.
Any others? (Wizkid maybe :P?)
Forward port 1433. Old >_>
Did, doesn't work.
I've to put it in the SQL Server options too? (Seen it somewhere, but i don't know HOW to configure it)
In the host variable try
"<ip/domein>:<port>" instead of "<ip/domein>"
mssql_connect or connection to a remote MSSQL database isn't possible from a Linux (web)server to a windows db host? (At all?)
My site is running on Linux..
I'm not running SQL Server right now, but I'll give a brief description.
Forward port 1433.
Go to SQL Server Configuration Manager.
Enable the service SQL Server Browser. (or something named like that)
Start it.
Enable TCP/IP in the SQL Server Configuration Manager.
Double click TCP/IP and check for IPAll. Change the Port to 1433. Leave Dynamic Ports to 0.
Restart the SQL Server Database Engine/SQL Server Service.
Now use SMSE and connect to the server by IP with login details.
Tell me what happens.
Reply With Quote