setup help

[annie613]

Here is a question. I need some advice and direction.

I was asked me to build and event calendar for my department. Where the users can view, add, delete and
modify events.

This gave me the idea of using ASP and SQL the user can go to a URL and access a home page where they will be able to login as an operator and then maintain an SQL DB.

I am capable of designing and coding the site and pages. That is not what
I worried about. But here is where my problem arises. I was trying to ask
my supervisor the other day but I was confused myself.

I need to have an understanding of how to set this process. I will have to
report to my supervisor to explain to him how this can happen. So they can
help me get this project rolling

I guess what I am asking is how do you set up something like this.

I need an SQL DB, but where do I create it…like on a webserver or SQL
server???

I need to have a folder to store my ASP files…how is
that done and where it stored? And exactly what type of folder? ( I mean
I can create any folder, but my ASP is only viewable when I store the files
in a certain type of folder)

I need to have a place to view the pages like a URL but do I need a certain URL that will allow users to view the ASP …..how can I get something like this.??? I know in our home office they
have a webserver that hosts our URL but do I just ask their webmaster for some space on there? And if I do what
exactly do I need him to do? I guess this is where he can give me a folder and then I can upload files there…

Can you recommend any books where I can read up on this or just sort of
give me an idea and then I can talk with my supervisor and the webmaster in
reading and get this started…

Thanks so much in advance

[Memnoch1207]

Does the office you work at have all of this? a web server and a server running sql server? if so, then it should be a piece of cake.

[annie613]

well i know we have a webserver about 100 miles off location
and im not sure about the SQL server
they try to use MS Access for their DB
which i can still code the ASP pages to connect to the Access DB
but Im not sure where to create the Access DB.
Do I create the DB here at my office on our server
and then code the ASP to connect to the webserver 100 miles away?

and what do i have to ask their techincal contact?
i guess i need to have him/her to setup some kind of folder to store my asp files, correct?

like our URL is www.mycompany.com
and i will have to have something like
www.mycompany.com/myfoldername/myfiles.asp

and inside myfoldername store my ASP

im on the right track or am i still confused????????

[Memnoch1207]

The access db should be setup on the server, and stored in a folder outside the actual available site...the way I would do it is have 2 folders www01 (where all internet files are) then a var01 folder (that holds the database)...how you set up the db connection is really a matter of preference (i.e. direct connection using the path or as a file or system DSN)...Everything (should) be on the webserver, so you would probably need to have FTP access to the directory or directories you need. ....I would probably have the layout of it look something like this

Domain Layout

[url]www.yourcompany.com[/url] 'the companys base url
[url]www.yourcompany.com/whatever/[/url] 'your url for your stuff

Directory Layout

yourcompany.com folder 'main company site folder, contains all site files
www01 'this is inside the yourcompany.com folder and will house all the site related files
var01 'this is inside the yourcompany.com folder and will house the database
 
[b]Structure[/b]
YourCompany.com Folder
   www01 folder
      'all folders and files related to the website go in here
   var01 folder
      'access database is located in here. So it can't be directly accessed (downloaded) through the internet, it can only be interfaced with through the site.

[annie613]

thanks that helps me out
annie