connecting to SQL server from website
I'm new to SQL server. Can someone explain to me how I connect to the SQL server that is on my computer, from a web page? I have created an ASP page and uploaded it onto a web server, but I need to be able to read from my database that is on SQL server on my computer? how do I do this?
Also, can someone explain to me how this actually works? Let's say someone logs onto my website from their computer. they need to see the info from the data base so ASP calls for the information from my computer, is this right? Doesn't that mean that my computer would have to be on so that it can acess the database?