File DSN's Page 3
To use the file DSN is as simple as building a connection string giving the file DSN name and building the database source.
'First create the connection
Set oconnect = Server.CreateObject("ADODB.Connection")
'Next I map a path to a virtual directory containing all my databases
'This saves time moving the application from a local to a remote server, the
'Physical paths can change, but the virtaul remain the same. Server.MapPath returns
'A physical path from a virtual directory.
DB_PATH = SERVER.MAPPATH("/DATABASE")
'Next build a connection string using the file DSN we created and
'The mapped path to the database directory with the database we want to connect to
CONNECT_STR = "FILEDSN=WEB.DSN;" & _
"DBQ=" & DB_PATH & "\WEBDB.MDB;"
'Now connect as normal and your
That's all there is to it!