StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Connect to Dbase 5 Tables

Connect to Dbase 5 Tables

Brad Weaver (Canada) — Thu, 13 Aug 2009 10:48:05 GMT

I am trying to connect the Business Object Mapper to a set of Dbase 5 tables. I tried using the connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\projects\hsfis\sesn0026;Extended Properties=dBASE V;User ID=Admin;Password= "

and when I go to Configure Object -> Get Source I get an error message "Could not find installable ISAM"

How do I go about using Dbase 5 tables in Strataframe?

Thanks! I'm in the early evaluation phase and I'm trying to move from years of Visual FoxPro experience into a solid .Net framework.

RE: Connect to Dbase 5 Tables

Trent L. Taylor — Thu, 13 Aug 2009 10:48:05 GMT

Great! Glad you got it going!

RE: Connect to Dbase 5 Tables

Brad Weaver (Canada) — Thu, 13 Aug 2009 10:09:03 GMT

Thanks for such a quick response. The problem was I was using the wrong Dbase version code. Changed the string to:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\projects\hsfis\sesn0026;Extended Properties=dBASE IV;User ID=Admin;Password=

and I can now enumerate tables and add to my structure. Looks like I've got some work to do on my project now!

Thanks again. I'll let you know in the next few days if I'm a Strataframe convert...

RE: Connect to Dbase 5 Tables

Trent L. Taylor — Thu, 13 Aug 2009 09:11:26 GMT

Well, from looking at your connection string, you are trying to connect to an older dBase file, correct?

The ISAM message is actually coming from the OleDbConnection class from within .NET. In this example, we simply pass through the connection string to the connection and them call the GetSchema (and other) methods to pull back the schema of the table in question. So the OleDB provider that you are using or the tables either needs the connection string to be tweaked or doesn't have proper drivers. We rely on the OLE DB providers to access the data. Here are a couple of articles and discussions that I have found in regards to this message:

[url=http://support.microsoft.com/kb/318161]http://support.microsoft.com/kb/318161[/url]

[url=http://www.webmasterworld.com/forum47/112.htm]http://www.webmasterworld.com/forum47/112.htm[/url]

[url=http://www.dotnetspider.com/forum/4630-Could-not-find-installable-ISAM.aspx]http://www.dotnetspider.com/forum/4630-Could-not-find-installable-ISAM.aspx[/url]

[url=http://www.dotnet247.com/247reference/msgs/22/112430.aspx]http://www.dotnet247.com/247reference/msgs/22/112430.aspx[/url]

In all of these threads and discussions, it is referring to the Jet.OLEDB.4.0 provider. Let me know if you do not make any quick progress on this and I will try and reproduce. In this case I will need you to provide us with some sample databases or tables for testing.