asked on

Using DataFactory With An Access Database

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.

rockiroads

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"

rockiroads

I checked MSDN and found this, has more info that what Ive given.

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

cehrnow

ASKER

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 ?

ASKER CERTIFIED SOLUTION

rockiroads

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cehrnow

ASKER

Problem was with the connection string - I had UserName instead of User Id !!
Many thanks rockiroads.