Connection Error MPOG Web.

Printable View

14-03-09
Mambo

Connection Error MPOG Web.

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:

Quote:

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.
14-03-09
Linear88

Re: Connection Error MPOG Web.

wesman2232's Unofficial Fix Thread.
14-03-09
Mambo

Re: Connection Error MPOG Web.

Quote:

Originally Posted by Linear88

wesman2232's Unofficial Fix Thread.

I'm using remote connection. And i can't acces dll's or something. (i use webhosting)
14-03-09
Linear88

Re: Connection Error MPOG Web.

Enable remote connections. Google that. It may take some time for it to work.
14-03-09
Mambo

Re: Connection Error MPOG Web.

Quote:

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")
14-03-09
wesman2232

Re: Connection Error MPOG Web.

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
14-03-09
Mambo

Re: Connection Error MPOG Web.

Should i use TCP/IP or Piped? Or both?
14-03-09
wesman2232

Re: Connection Error MPOG Web.

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.
14-03-09
Mambo

Re: Connection Error MPOG Web.

Quote:

Originally Posted by wesman2232

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?
14-03-09
wesman2232

Re: Connection Error MPOG Web.

normal website port?
14-03-09
Mambo

Re: Connection Error MPOG Web.

Quote:

Originally Posted by wesman2232

normal website port?

I don't think so.

Any others? (Wizkid maybe :P?)
15-03-09
Linear88

Re: Connection Error MPOG Web.

Forward port 1433. Old >_>
15-03-09
Mambo

Re: Connection Error MPOG Web.

Quote:

Originally Posted by Linear88

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)
15-03-09
shadow-xx

Re: Connection Error MPOG Web.

In the host variable try

"<ip/domein>:<port>" instead of "<ip/domein>"
16-03-09
Mambo

Re: Connection Error MPOG Web.

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..
17-03-09
Linear88

Re: Connection Error MPOG Web.

Quote:

Originally Posted by Mambo

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)

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.