Solved

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

Posted on 2004-10-07
3
632 Views
Last Modified: 2013-11-25
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
Comment
Question by:tjgilbert
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
drichards earned 125 total points
ID: 12252066
You need a connection string like:

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

0
 

Author Comment

by:tjgilbert
ID: 12253048
Do you know if that connection string is correct for the MS Access 2003?
0
 
LVL 19

Expert Comment

by:drichards
ID: 12254089
It's what I use (with different file name, of course), so I hope it's correct!
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Studio community 2015 2 83
Paint/Redraw window while dragging 16 85
Problem to open text file 11 136
Infrastructure development vs software development 3 77
In Easy String Encryption Using CryptoAPI in C++ (http://www.experts-exchange.com/viewArticle.jsp?aid=1193) I described how to encrypt text and recommended that the encrypted text be stored as a series of hexadecimal digits -- because cyphertext may…
In this article, I will show how to use the Ribbon IDs Tool Window to assign the built-in Office icons to a ribbon button.  This tool will help us to find the OfficeImageId that corresponds to our desired built-in Office icon. The tool is part of…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question