...

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



CstAn
09-07-2006, 03:13 PM
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.

arnyinc
09-07-2006, 06:32 PM
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.

CstAn
09-08-2006, 02:41 AM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum