• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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