Connect to MS SQL on remote server ?
Posted by: Rachid (80.79.44.---)
Date: August 15, 2006 10:32PM

Hi there,

I have MS SQL installed on a remote server, when I write a small VBscript it connects fine.
So I know that the database is working.
It works with ColdFusion as well.

When I try to connect to it with PHP, it just will not connect.
But when I connect to the local development server on the LAN, it does !

So anybody knows what's wrong here ?!?!?

Options: ReplyQuote
Re: Connect to MS SQL on remote server ?
Posted by: Rachid (80.79.44.---)
Date: August 15, 2006 11:04PM

Ah downloaded this ntwdblib.zip and it's all working ! :-)
[webzila.com]

Options: ReplyQuote
Re: Connect to MS SQL on remote server ?
Posted by: CyberSpatium (67.170.181.---)
Date: August 16, 2006 12:20PM

enable the mssql extension in your php.ini file, restart apache, then write your php code like this

mssql_connect ('mssql.remoteserver.com', '_UserName Here_', '_Password Here_');

Options: ReplyQuote
Re: Connect to MS SQL on remote server ?
Posted by: Rachid (80.79.44.---)
Date: August 16, 2006 02:17PM

Already did that.
As I said, all working now.

Options: ReplyQuote


Sorry, only registered users may post in this forum.