Link to home
Start Free TrialLog in
Avatar of regsamp
regsamp

asked on

ASP website question

We are currently trying to move a ASP website from a Windows 2000 server with IIS and a SQL 2000 database to a Windows 2003 server with IIS and the database will be moved over.  I am a little new at this and it the site appears to have been created with Macromedia Dreamweaver since there are no applicatons here in our organization.  What is the main file to open for the website in Dreamweaver or another similar application to open the whole website?  For example in Visual Studio.NET I would open the example.sln to bring up the whole program and being working on it and how can I find the string connection to which database it is using?  For instance in Visual Studio.NET the connection to the server and database could be hard coded or in webconfig but I am not finding the servername or database name.

Any assistance offered would be greatly appreciated.  
ASKER CERTIFIED SOLUTION
Avatar of dtryon
dtryon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hes
Check in a file global.asa for the connection string some ASP programmers put in there to open the connection when the application starts.
Avatar of regsamp
regsamp

ASKER

Davin, yes this is classic ASP and this should be the connections you were speaking of, correct?
Function OpenDatabase()

      Dim dbUsers                        ' As ADODB Connection.
      
      Set dbUsers = Server.CreateObject("adodb.connection")
      
      dbUsers.Open "dsn=ContactList","sa"
      
      Set OpenDatabase = dbUsers

and
<!-- #include file="../adovbs.inc" -->

<%

'----------------------------------------------------------
Function OpenDatabase()

      Dim dbContact                        ' As ADODB Connection.
      
      Set dbContact = Server.CreateObject("adodb.connection")
      
      dbContact.Open "dsn=ContactList","sa"
      
      Set OpenDatabase = dbContact

End Function
Avatar of regsamp

ASKER

Checked global.asa and nothing in there about connection string.  
Generally speaking the 'default' start is defined within the web server setup and not by Macromedia, Frontpage, or other tools used to develop websites.  I'm not certain but iisstart.asp might be the 'default' for IIS based servers. Check via iisadministrator (via control panel?) Maybe something in the properties will tell you how your particular setup is supposed to work.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
in dreamweaver you create sites they are based on directories like what was said above.

if the files have an .asp at the end.
you can look for an open()
a lot of times these sites use dsn, which would be created in administrative tools / Data Sources
Regsamp,

Yes, that looks like the connection.  You might want to pick up an older book like O'reilly's ASP In A Nutshell.  Make sure it's VBScript.  It could help you recognize all the ASP code because it does look quite different than the .NET code we are now used to.

jrs_50 is right the default start page is set in IIS, but I don't think it would be iisstart.asp, most likely one of the files I already mentioned (default.asp or index.asp).  These files are defined and ordered in IIS.

the adovbs.inc file is an asp library, not custom code, so you shouldn't need to worry about that one.

To answer the overall question again, in order to move the site to Windows Server 2003, you should be able to just copy the directory over directly.  Then set up your IIS virtual directory (a.k.a. web site).  That should work.

Take care,
Davin
From ms doc's, IIS 5 and later

"NOTE: Iisstart.asp is a new default document for the default Web site. Because it has lower priority than the other standard default documents, Default.htm and Default.asp, it will not be loaded if either of those other files exist. Furthermore, if IIS 5.0 is installed over an IIS 4.0 installation that already has a Default.asp or Default.htm file, it does not remove or overwrite them."
Thanks for the points. I hope you're all set.