[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2004-10-07
3
Medium Priority
?
639 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
drichards earned 500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

If you have ever found yourself doing a repetitive action with the mouse and keyboard, and if you have even a little programming experience, there is a good chance that you can use a text editor to whip together a sort of macro to automate the proce…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

656 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