Connection of ASP and MS ACCESS using file dsn

[vinodkus]

dear sir/madam
Can any one help me how to connect ASP and MS ACCESS using FILE
DSN.

Thanks in Advance


vinod

 

[Bob Barrows [MVP]]

dear sir/madam
Can any one help me how to connect ASP and MS ACCESS using FILE
DSN.

There is no need to even try. Use a DSNless connection string:
Either:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb

Or, for Access 2007:
Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb