Store procedure via PHP/FreeBSD

[perrone]

Hi,

Does anybody know if i can access store procedure in MS-SQL2000 via PHP scripts hosted on FreeBSD? I've several scripts that are hosted on Win2k and i would like to move this to FreeBSD. I don't know if i need to re-write my PHP scripts that use store procedure to this works fine in FreeBSD. Are mssql_* functions exactly the same in both environment?

[valen53]

is it mssql2000 can install in freebsd???
or u use mysql in freebsd?
mysql doesn't support store procedure but the procedure can write in php

[perrone]

I will try to explain more clearly...

The MS-SQL2000 and apache1.3(PHP) are installed on Win2k together. I want to move the apache/PHP to one FreeBSD 4.6 server and preserver the database on the old server(Win2k). This way i will work with two servers. But my PHP scripts were written with the mssql_* functions and designing to work with store procedures(MSSQL2000). If i install the apache on FreeBSD, the only way to performing my store procedure through PHP script is via FreeTDS. But i think that i will need to re-write my php code that access store procedure. am i right ?

thanks

[mrmufin]

Is the database server staying on the Win2K machine...? and you're only moving the web front end (Apache / PHP), or am I misunderstanding your post? If this is the case (I suspect) that the only thing you should need to change is the database host name.

[perrone]

The database will be preserved on Win2k server and apache/PHP will be move to FreeBSD server, ok?