Connection of ASP and MS ACCESS using file dsn

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

Thanks in Advance


vinod

Re: Connection of ASP and MS ACCESS using file dsn

vinodkus@gmail.com wrote:
> 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


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"