[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 642
  • Last Modified:

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
0
tjgilbert
Asked:
tjgilbert
  • 2
1 Solution
 
drichardsCommented:
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now