File DSN's Page 3
Download the authoritative guide: Data Center Guide: Optimizing Your Data Center Strategy
Download the authoritative guide: Cloud Computing: Using the Cloud for Competitive Advantage
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!
IT Solutions Builder TOP IT RESOURCES TO MOVE YOUR BUSINESS FORWARD
Which topic are you interested in?
What is your company size?
What is your job title?
What is your job function?
Searching our resource database to find your matches...