File DSN's Page 2

Steps to create a file DSN source.(This example will connects to an Access Database)

Open up a text editor and create a file named WEB.DSN
Type in the following:
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=512
ImplicitCommitSync=Yes
FIL=MS Access
DriverId=25

Save this file in the root directory of your web application. Notice that I dont give the default drive and DBQ within the actual file DSN, this is so that I can reuse the DSN for every Access DB which  I need a connection to.