How to link up ASP pages with backend SQL Server 2005
Posted on 2007-07-20
I've recently taken over administration of a web site running on Server2003. I'm in the process of moving the site over to a new server (also Server2003). The new server I'm moving it to has IIS 6, the old server, I believe has IIS 5, though I can't be sure because going under Help->About IIS doesn't tell me a version number. What makes me think it's IIS5 is when I view properties for one of the ASP files, the box that comes up doesn't have an ASP.NET tab. In any case, the reason I said all this about versions of IIS is because of my question.
I need to connect these ASP pages to my backend database (SQL Server 2005), [The basic HTML pages are already up and running on the new server] I've already moved over the database from the old server (it was running on SQL2000. The data move was smooth, I used backup/restore).
On my new server it looks like the connection string for each ASP file resides in the Properties->ASP:Net->Edit Config Tab.
However, looking on the old server, I can't see where the connection string was, because as I said, there was no Properties->ASP:NET->Edit Config Tab.
So the basic question is, how to I link up ASP pages to my backend database on the new server.
Sorry if this was a bit wordy, but I wasn't sure which piece of information you might need.
Let me know if you need to know anything else.
PS. I've done this a hundred times using MySQL/Perl/DBI, so 'speaking in tech' to me is fine. I just don't know Microsoft technologies all that well.