Last post Mar 28, 2008 08:57 AM by kilko
Mar 11, 2008 08:50 AM|RobA2345|LINK
I really apologise if these are really stupid questions but I just don't get how this works having never done it before.
I have built a web form that interacts with SQL Server that runs on my home computer to submit data. I just want to get this simple form on the internet but have no idea how to go about it. Can someone please give me a idea where to start. Do I need to buy
webspace? If so how does publishing my web site on the webspace server let it submit data to my SQL Server on my computer? Or do I have to turn my computer in to a Web Server? If so how would I do that?
If anyone can just post a couple of relevent websites or papers that would be great, I don't mind doing my own research. I'm comfortable with the coding and getting it to run on IIS but it's deploying it to the internet where I become clueless.
Thanks for any help you can give.
Mar 11, 2008 08:59 AM|Coppermill|LINK
Yes you'll need to get hold of some web space, some are free, but I prefer to buy mine.
You'll also need to check with the ISP is they support the version of SQL Server you are running, or if it is SQL Express then if they support that. SQL Express might be a little easier as your configuration will remain the same on the remote server. However
your connection string to SQL Server will be different depending upon your ISP.
As to links check the front page of http://asp.net or the forums section for possible options
Hope this helps?
Mar 11, 2008 09:12 AM|RobA2345|LINK
Many thanks for that very quick response. I'll mark it as answered.
Can you just clarify the point on the connection string? Will my tables and stored procedures be transfered to the ISPs SQL Server or will the connection string route the query through the ISP and then to my SQL Server? It's SQL Server 2005.
I've been using SQL Server and VB for 4 years but only been on .NET for about 3 months and ASP is just totally alien which will explain my questions.
Mar 21, 2008 06:16 PM|amritrr|LINK
Yes you are right, your tables and stored procedures will be transfered to the hosting providers SQL Server and you will need to update your web.config file with the new credentials. You will get your database name, username, password, and I.P while creating
the database through your hosting providers control panel. You will only be able to connect to a SQL server which is hosted on a static ip, and that is the reason why you will not be able to access your local system SQL Server as the IP your system uses while
connecting to the net is Dynamic. By dynamic ip it means that your ip changes every time you connect to the net.
Mar 25, 2008 02:51 AM|Revathyb|LINK
I have a doubt. If we are uploading our web project to the server wont our web.config file conflicts with the one that already exists in the server...
Thanks in advance
Mar 28, 2008 08:57 AM|kilko|LINK