StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Connect to Dbase 5 Tables
Connect to Dbase 5 Tables
Post Reply
Like
0
Connect to Dbase 5 Tables
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Trent Taylor
Trent Taylor
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
Great! Glad you got it going!
Reply
Like
0
Brad Weaver (Canada)
Brad Weaver (Canada)
posted 15 Years Ago
ANSWER
Post Details
Share Post
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...
Reply
Like
0
Trent Taylor
Trent Taylor
posted 15 Years Ago
ANSWER
Post Details
Share Post
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.
Reply
Like
0
Brad Weaver (Canada)
Brad Weaver (Canada)
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
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.
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search