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 3 of 3
  1. #1
    Regular Coder
    Join Date
    Nov 2005
    Posts
    148
    Thanks
    1
    Thanked 0 Times in 0 Posts

    [sqlserver] get data from SQL through the web server without a link to SQL server.

    as title, i want get data from SQL server but i cant connect to SQL server because of company policy.
    The administrator jz can give me procedure and let me execute at web server to get data from SQL server..
    but i not really understand about that....i try search from google n yahoo but also cant get what i want...
    any expert can guide me to search or tell me what about that...

    thanks a lot....

    i m using PHP for d web server.
    Last edited by guelphdad; 09-08-2006 at 02:13 AM.

  • #2
    Regular Coder
    Join Date
    Jan 2003
    Posts
    867
    Thanks
    4
    Thanked 8 Times in 8 Posts
    You would still need to connect to the sql server to execute a stored procedure on the web server. I assume they want to stop you from executing arbitrary sql commands. So you can create a stored procedure that is "hard coded" in the sql server. Then you can only call this pre-defined stored procedure so they know what you are executing.

  • #3
    Regular Coder
    Join Date
    Nov 2005
    Posts
    148
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by arnyinc View Post
    You would still need to connect to the sql server to execute a stored procedure on the web server. I assume they want to stop you from executing arbitrary sql commands. So you can create a stored procedure that is "hard coded" in the sql server. Then you can only call this pre-defined stored procedure so they know what you are executing.
    o..icic

    i got another problem about the performance of process.

    currently i want continue with the project that had done by other developer.

    Process getting data from SQL server compare with get from MYSQL will more slow?

    i ask this question is because previous developer want to keep the previous history record so every day get data from SQL server and insert into MYSQL and cause MYSQL got thousand of record.

    this also cause the application run very slow when user perform certain funtions.

    any suggection for to correct it?

    thanks.


  •  

    Posting Permissions

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