Connect to Dbase 5 Tables


Author
Message
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Great! Glad you got it going!
Brad Weaver (Canada)
Brad Weaver (Canada)
StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)
Group: Forum Members
Posts: 2, Visits: 21
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...
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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:



http://support.microsoft.com/kb/318161



http://www.webmasterworld.com/forum47/112.htm



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



http://www.dotnet247.com/247reference/msgs/22/112430.aspx



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.
Brad Weaver (Canada)
Brad Weaver (Canada)
StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)StrataFrame Beginner (2 reputation)
Group: Forum Members
Posts: 2, Visits: 21
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search