...

View Full Version : MSSQL Linked server and PHP



shaileshpatil
11-08-2010, 06: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.
Thanks

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

divinequran
11-09-2010, 12:35 PM
Hi,

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.

shaileshpatil
11-10-2010, 08:45 AM
Hello friend

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum