Database 2

[smash81]

Hello,
I have just learnt how to use ASP.I am now about to do some programming that involves databases (Access).
My question is, how will i get a DSN name for the server that is going to host the web page?
Secondly, normally the path for the database is easy to set on my machine.How will i do this with the database on some other(remote) machine
These may seem very simple to answer but please consider me a beginner and help out.

 

[vasah20]

Depending on your ISP, you might need to contact them to set up your DSN, or you can do it through some type of control panel interface.

As for getting the path to your database, all you need to do is a
Server.MapPath to your database, and that will print out the full path name to your database on the ISP's computer.

Ex:
Response.write Server.MapPath("myDb.mdb&quot

will print out the physical location of your database/

good luck
leo

 

[smash81]

Thanks.
One more question,
Is it possible to have a website (or just the database part of it) residing on my personal computer and available on the internet?
What i mean is if i have a leased line connection 24 Hrs, an NT server with IIS on it, is it then possible to have the website on this machine and accessible over the internet or does it have to be hosted on some webserver?
Please guide me on this.

 

[link9]

Yes, you can do that. The main ingredient is a "static ip address". If you have that, then you can access it from anywhere. But so can hackers. So that introduces security into the equation, and there's no one here that can cover all the bases on what security measures need to be implemented in order to protect your web server.

I would offer this bit of advice. If this is your personal computer (as you said), then I would seriously question the idea of making it available for public access over the Internet. It just isn't a good idea.

If you have a box that can serve as a dedicated web server with only files on it that you don't mind everyone in the world seeing and having access to, then that's a different story.

But like I said, if you have a leased line (T-1 maybe?) connection and a static ip address, then you can do what you have asked about. You should know what your ip address is, and you can type that into any browser to access your computer if you have virtual directories set up on it. I would just be careful.

good luck!
Paul Prewett