Connect a Web Site with a DB 1

[swreng]

Hello to everybody,

I haven't experience to web applications and i would like your help please in order to understand some things.

I want to make the following implementation:
There is a simple web site that anyone can visit, now we want to add a feature to that site for a simple complain-request recording.
The database which will keep the data is on a sql server on a local network,
so my question is how can i execute a query from the web site to that db?

Many Thanks.

 

[ca8msm]

I'd suggest you go through some of the data access tutorials from

http://asp.net/learn/

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jmeckley]

if your just logging a complaint you may just want to store the value in a text document (xml, csv, txt). download the file and import into xls, access, sql server and do what you need to. or just have them emailed to someone directly.

what do you mean by "local network"? where is the website hosted in relationship to the local network?

with public websites usually the host provides a database server as part of some hosting package. they would provide the url, username and password. then it's just a matter of creating a connection string pointed to the database.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[swreng]

Thank you for you replies.

Maybe i don't know to explain some things so i will try again:

The host of the website is out of our company and we have a database server inside our company which we want to keep this data. So how can i make communication between the site and the database server without saving to files local and make an import?

 

[jmeckley]

I would advise against opening a hole between the website on a 3rd party host and a database within your intranet.

the most secure option is to use the services of your host (their database server) and download the results to your system with an import routine.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[swreng]

Ok thank you for your reply, for this implementation the solution you are suggesting me is enough,
but in the future we are thinking to make sth more complex (e-commerce), so that solution to save the data in the database of the host and download to the local db is it safe ? it looks like very strange to save that kind of data out side the company isn't?

 

[jmeckley]

ecommerce is a totally different scope that logging comments/complaints.

it looks like very strange to save that kind of data out side the company isn't?

that depends on your company's mission/vision and goals.
to bring this site in-house you would need to maintain the server's OS, the database software, Apache/IIS, SSL certs, authentication and authorization(both at a network, local and application), credit card processing, and probably many more services I can't imagine.

if these concerns are not primary to your company then outsourcing to a 3rd party may be a wise decision. Maybe your company can maintain these services, in which case you may just want a consulant to assist with the archetecture (sp) of the network/communications and have your team implement it.

I assuming no one at your company currently has the knowledge to direct this. Otherwise you wouldn't need to post

even if you hosted the site in-house. you still should not have a public website accessing an internal database. too much is at stake if the web server or db server is compromised.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[swreng]

You really helped me a lot, thank you very much

 

[jmeckley]

your welcome

Jason Meckley
Programmer
Specialty Bakers, Inc.