MSSQL: Best way to connect

[Nichito]

Hello guys.

I'm developing a web application in which I have to connect to a mssql server which is connected through a proxy server. I have allowed data transfers for the MSSQLSERVER service, and allowed connections for port 1433. I've read that this is absolutely insecure, and it still gives me mssql_connect() errors, so which one is the best way to do this?

Thanks in advance

[dottomm]

Hi Nichito -

I am new to mssql but am currently starting a new project using mssql and php. I learned that mssql_connect is no longer supported by M$ and they recommend using SQLSRV driver. You can Google sqlsrv to find the download.

FYI -
Additionally you must use a whole slew of new tags, but it's well documented and isn't too hard to figure out.