Solved

Using DataFactory With An Access Database

Posted on 2007-11-23
5
330 Views
Last Modified: 2008-02-01
Just can't seem to find the information needed for this. Currently developing a vb.net application using the DataFactory to access different types of databases (MSAccess, sql server, oracle etc..). However, not sure how to setup the provider detail to access an MS Access database. Any help would be great.
0
Comment
Question by:cehrnow
  • 3
  • 2
5 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 20338701
Havent got that object, and not sure if you are referring to RDS Data Factory.

Does this access go thru ODBC?

Would you be using ADO ?

This is an example using ADO (not ADO.Net) but I expect the provider would be a similar string?

rs.Open "SELECT * FROM mytable", _
      "Provider=MS Remote;Remote Server=http://MyServer;DSN=MyODBC"
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 20338733
I checked MSDN and found this, has more info that what Ive given.

http://msdn2.microsoft.com/en-us/library/ms677519.aspx
0
 

Author Comment

by:cehrnow
ID: 20340243
This is not RDS but basically trying to get a local connection. Using the DataFactory provider "OleDb Data Provider" and the following connection string..

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\test.mdb";UserName=;Password="

..I get the error: Could not find installable ISAM when trying to access a table.

Any idea how to get connected to this MSAccess database ?
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 20340868
That string looks right. Ive used that in OleDbConnection, didnt bother specifying username and password though as I didn thave security setup.

Have you had a look at the connection strings in here to see if there is anything helpful for datafactory?

http://www.connectionstrings.com/
http://www.carlprothman.net/Default.aspx?tabid=81

0
 

Author Comment

by:cehrnow
ID: 20342847
Problem was with the connection string - I had UserName instead of User Id !!
Many thanks rockiroads.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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