What is a File DSN/Datasource and how do I create one?
A File Datasource can be thought of as a pointer (file location) to a database. When developing Active Server Pages (ASP) that access databases you need to reference a Datasource so the ASP can find the database. To create a datasource, create a file in your site with a .dsn extension. The filename is the name of your datasource. For example, if you name your datasource TEST.DSN the name of your datasource is TEST. The contents for your file should contain the following: [ODBC] DRIVER=Microsoft Access Driver (*.mdb) ReadOnly=0 UserCommitSync=Yes Threads=3 SafeTransactions=0 PageTimeout=5 MaxScanRows=8 MaxBufferSize=512 ImplicitCommitSync=Yes FIL=MS Access DriverId=25 You can copy and paste the above information in the actual DSN you are creating. The parameters can be changed but aren’t supported, therefore will make no difference. Once you have created your datasource, you now need to create the connection string to be used in your Active Server Pages.
