View Full Version : MSSQL Linked server and PHP

11-08-2010, 07:07 AM
Hello experts

I have an procedure which fetch an row from table.
It also contains UDF in MSSQL which connects to linked server and database on another server.
When i run the procedure on SQL database, it pulls out correct information.
When i try to execute the same procedure via, php it return 0 rows.
This procedure was working perfectly until, the database was completely shifted to new server.
Also for linked server credentials passed are of sa
I am using PEAR DB to connect to my application.
Any suggestion on whats going wrong.

11-09-2010, 08:41 AM
Any idea.. suggestions

11-09-2010, 01:35 PM

Does your php code connects with the Linked server without any problem?

Write a pice of code without procedure and try to fetch the same rows or data. This will help you to find the bug on your server.

11-10-2010, 09:45 AM
Hello friend

I did this and was of no help.
PHP doesnt give any kind of error.