mssql_connect and mysql_connect in PHP.ini

[rexolio2008]

Can anyone help me?

My host has PHP and MySQL set up on his server. He also has SQL Server.

I have someone creating a PHP script for me, but I need it to adding records to a table in SQL Server instead of MySQL.

When my host trying to set up the mssql_connect function in the PHP.ini file, all sites on his server running PHP basically stopped working.

However, without the mssql_connect function enabled, you get the function undefined error on the script that's currently being developed.

1. Can mssql_ and mysql_connect both be enabled in PHP.ini and run on the same server?

2. Can anyone point me to a resource for getting this to work if it's possible (#1)

Thanks!

 

[jpadie]

When my host trying to set up the mssql_connect function in the PHP.ini file, all sites on his server running PHP basically stopped working

then he's a monkey.

yes. mysql and mssql extensions can coexist on the same server. there is no magic to making it so. just follow the instructions in the manual for each server.

i would recommend using PDO as a common abstraction layer to address both server instances.

 

[rexolio2008]

then he's a monkey.

LOL... okay, just needed some info to support my request to have it setup. Thank you.

 

[ingresman]

you need to get php_mssql.dll on the extensions path. If you need help on this shout back !

 

[hex6007]

mysql and mssql as my understanding don't create conflict on the same server instances. likewise, they even dont share the same ports. and lastly, both are working differently just like they dont know each other.

try register your dll files (php_mssql.dll, etc.) of msqql and restart your server.

run your phpinfo() and check for mssql if present.

hope this work for your problem.

regards