Visual Basic .Net Using ASP .Net Web Service to connect to a Microsoft Access Database

The question is how do I connect to a MS Access Database using the ASP .net Web Service in Visual Basic .Net.
I have Windows XP professional version and IIS installed.

I'm trying to use the OleDBConnection

Dim conn as New OleDbConnection("\Inetpub\wwwroot\WebService1\Response.mdb")

The connection string is wrong and I'm not sure how to make it right.

Thanks
tjgilbertAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
drichardsConnect With a Mentor Commented:
You need a connection string like:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\Inetpub\wwwroot\WebService1\Response.mdb;"

0
 
tjgilbertAuthor Commented:
Do you know if that connection string is correct for the MS Access 2003?
0
 
drichardsCommented:
It's what I use (with different file name, of course), so I hope it's correct!
0
All Courses

From novice to tech pro — start learning today.