Jump to content

Archived

This topic is now archived and is closed to further replies.

SharkBait

PHP and MSSQL

Recommended Posts

Hi,

Is it somewhat as easy as it is with MySQL to get PHP to Connect to MSSQL on a machine running Win2003 Ent. ?

I figured I would have to do it via the ODBC but I've not had to use the ODBC with PHP and I assume there is a setting in the php.ini file I have to change inorder to do this?

If the server that I have running PHP accesses MySQL DBs as well, will setting it up to connect to MSSQL bugger it up? I don't like MS products much but one of our workplace applications runs SAP which is windows based and I want to use PHP to talk to the SAP database.

I noticed that the tutorial here on PHPFreaks uses the ODBC to connect to a MS Access DB but it only shows the configuration of ODBC on a winbox.

:)

Share this post


Link to post
Share on other sites
Use php mssql functions.

[a href=\"http://www.php.net/manual/en/ref.mssql.php\" target=\"_blank\"]http://www.php.net/manual/en/ref.mssql.php[/a]

For most of them, simply change myxxx to msxxxx

eg. mysql_connect() becomes mssql_connect();

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.