connecting to database with ASP?

I need to write an application that connects to a database. I've done a couple with an absolute connection line C://inetpub ... etc, but they were just local test examples.

This will be different as the box the database will be on will act as as webserver. So I'm thinking of using the Server.MapPath method ... is this the proper way to write the connection?

I figure that this way, no matter who access the ASP page from the web and from wherever, the server will use the relative connection string from Server.MapPath and find the database right?

Or am I on glue?

A good start, well it helped me no end:

http://www.activeserverpages.com/learn/dbopen.asp