Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MSSQL Linked server and PHP

    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
    -------------------------
    Shailesh Patil
    -------------------------

  • #2
    New Coder
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Any idea.. suggestions
    -------------------------
    Shailesh Patil
    -------------------------

  • #3
    New Coder
    Join Date
    Dec 2008
    Location
    india
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #4
    New Coder
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    :-(

    Hello friend

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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •