MS SQL = MySQL? kinda? connection help :(

[jirehlubrin]

hi. i dont know if this is the right forum for this :o . I was wondering if it was possible to host a website on PowWeb that connects directly to my MS-SQL database on my computer.

<?PHP
$conn=mssql_connect("000.000.000.000","sa",'lYKAlANCE');//line 11
if ($conn) {
echo "cOoOL man";
}
else {
die("Broken.");
}
?>
With that code, it works when I do a http://localhost/works.php
but when I upload that to the powweb, it doesn't connect.
(I have no firewalls and my port 1433 is open on my router :p)

I get this error :confused:

Fatal error: Call to undefined function: mssql_connect() in /www/path/htdocs/mub/****inguide/works.php on line 11

please help me :D

[satis]

my guess is that powweb doesn't have the mssql connection module for php enabled. I wouldn't be too surprised...after all, they don't have ms-sql server, so why enable the functionality?

[mitchind]

Can't do it here - probably not from any Unix shared hosts - but that's just my guess.

PHP on Unix needs to be compiled/started with --enable-msdblib and FreeTDS

[jirehlubrin]

but im not hosting it on their server. it connects to my server on my computer. on my server, the apache, i have to enable something on the php.ini file and its okay.

[jirehlubrin]

oh and im using win XP :eek:
haha that face is so funny

[tbonekkt]

Our PHP isn't compiled with MSSQL support, so what you're trying to accomplish isn't possible.

[jirehlubrin]

noOoOoooOoooooo!!!!! this is the worst day of my life!!!! is there any way? or any changes in the future?

[IanS]

Changes are unlikely as they staying with a Linux type server.

[tbonekkt]

I don't see that changing - we don't offer MSSQL, so there's no reason for our PHP to be compiled to support it.

Why not use MySQL?

[jirehlubrin]

well we host a game server for a private server called MU. but the database and the webserver is on the same computer/same internet connection.

http://203.177.241.66/mb/

the game uses ms-sql and not mysql to store character information. what i want is the website to be hosted on the powweb that i pay for :p (i am a customer!!) to just host the website and its files,but the database that the website will connect to will be on the computer (203.177.241.66). i understand that the powweb doesnt support the mssql but the mssql is my computer :D and i just want it to connect to a remote server. powweb(php files) ---->> 203.177.241.66 database

is there any way powweb can just enable it for me? :D :D so it can connect to 206.177 and not host on pw

[mitchind]

Change your PC database to MySQL - and everyone's happy

[YvetteKuhns]

PowWeb does not allow connections to remotely hosted databases for security reasons. You could convert your database to MySQL and host it on PowWeb. You CAN connect one or more PowWeb hosted websites to a database hosted on PowWeb. In your case, you may use too much bandwidth!

[jirehlubrin]

ah very depressing :( but okayyyyyyy :D thanks everyone! haha close the thread!!