hi.
I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?
I had tried to google for more info but there are too complicated thing for me to understand.
Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.
We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )
So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?
I appreciated that.
Regards
newbie on aspnet.
You can do it by
Add a web service to your remote server to expose your table.|||Add a web service to your remote server to expose your table.Lock the web service site to only respond to the expternal IP address of your of your office.Write an application to consume the web service and update the internal table.|||>But i think it is better to program aspx to insert records to intranetdatabase directly. or any alternate ? All database software are alreadyfixed, no change.
For the web application to be able to write directly to the local database will require opening up your firewall - this is not a good idea as it opens up the possibility of your intranet database being hacked. The solution I suggested requires only the HTTP and HTTPS ports to be opened. As the data is being dragged in rather than being pushed in, it is much more secure.
>All database software are already fixed, no change.
If the table is a pure log (records are only added), then the required information may already be be present. You would need to provide your table creation scripts for me to comment further.
No comments:
Post a Comment