Accounts
Because the content you will be creating in this class is dependent on the use of server side code, it is critical that you have access to a Microsoft Internet Information Server (IIS) 4.0 or 5.0. There are some difference between IIS4.0 and IIS5.0, but both will work for class. Arrangements have been made to provide with an IIS enabled account with TCN.
TCN
Server: \\sotdev2\cg456\LASTNAME
Request:
http://sotdev2.tech.purdue.edu/cg456/TCNLOGIN
Path:
d:\iis\webroot\cg456\TCNLOGIN
Accessing TCN
account from Lab
Go to Start-->Run-->type \\sotdev2.tech.purdue.edu\cg456 . You will then
find a folder with youur TCN username. Create your project with in that
folder. Any files you create in here will be avilable on the web by using
the request http address above.
Accessing TCN account from
Home
Establish an internet coonection. Go to Start
--->Run-->type \\sotdev.tech.purdue.edu . When prompted for an
username and password type SOT\username and your TCN account password.
Note that you must preceed your TCN username with SOT\
DSN / DSN-less connections
In creating connections to your databases in this course, you will need to create a DSN-less connection instead of the DSN connection described in the book. The reason for this is that you would need to physically have access to the server in order to creat a DSN. This is not the case with TCN. If you work at home you can use a DSN connection.
To convert DSN connection to DSN-less conntection do the following. Instead of typing in:
set CarlosDB = Server.CreateObject("ADODB.Connection")
CarlosDB.Open
"Carlos
Type:
set db =
Server.CreateObject("ADODB.Connection")
db.Open "DRIVER= {Microsoft Access
Driver (*.mdb)};DBQ=D:\inetpub\wwwroot\cg456\crmorales\databaseb\data.mdb"
Note: You would change the path of the file to the location of you real
file.