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
vinodkus [ Mo, 10 September 2007 11:59 ] [ ID #1816644 ]

Re: Connection of ASP and MS ACCESS using file dsn

vinodkus [at] 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"
reb01501 [ Mo, 10 September 2007 12:35 ] [ ID #1816645 ]
Webserver » microsoft.public.inetserver.asp.general » Connection of ASP and MS ACCESS using file dsn

Vorheriges Thema: convert sql server data to msacess
Nächstes Thema: Wildcards in ASP Replace String