Fox OLEDB Provider crashes Application Designer (BDC)
-
Friday, September 18, 2009 6:04 PM
I am trying to access some data stored on a Fox Database by using App Designer to connect to it. After trying to use ODBC and seeing that MS consider this driver deprecated and suggests using OLE DB instead I downloaded this provider for Visual Fox Pro and try to connect to the DB.
Everything was going fine on Adding a LOB system, typing the conn string for OLE DB and when I hit Connect I even could see the table list and Add tables by dragging them to the workspace. My guess here was that the provider and conn string were fine since I could actually see the DB objects, but when I hit the OK button and the App Designer should take me to the tree-view Metadata Objects window and let me do my work, instead it just crashes big time!
The error says Application Definition Designer has stopped working with this Details:
Description:
Stopped working
Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01: applicationdefinitiondesigner
Problem Signature 02: 1.0.0.0
Problem Signature 03: 49ac68fa
Problem Signature 04: mscorlib
Problem Signature 05: 2.0.0.0
Problem Signature 06: 498d1a92
Problem Signature 07: dc
Problem Signature 08: 5
Problem Signature 09: A4DH5WWIWWW1YJTMP0C0KV4ZWCALU4IN
OS Version: 6.0.6001.2.1.0.274.10
Locale ID: 1033
I have tried this on Windows server 2003 32bit and on Windows Server 2008 64bit and it happens exactly the same way. I even tried this with ODBC driver, is the same!
The connection String I'm using is:Provider=vfpoledb ; Data Source=C:\DBFFox\Sfm\myVFPDB.dbc ; Mode=ReadWrite|Share Deny None; Collating Sequence=MACHINE;
I need to access this data from this BD and wouldn't like to use another way since we're doing this for a number of databases (Access, Sybase, MSSQL...) using BDC and would like to be standard. Is this possible? What is wrong with this driver/provider? Are there alternatives to access this data?
Thank you.
All Replies
-
Monday, November 30, 2009 11:46 PMI am running into the exact same problem trying to connect to our iSeries. The data connection seems to be correct as I can see the tables but when pressing "OK" it crashes and I can't get past this. Anyone out there experience this? I've been trying to research this problem but coming up empty. Thank you.
-
Wednesday, January 20, 2010 5:16 PMI am also having the same quality issue running the Microsoft Business Data Catalogue Definition Editor on Windows 2003 x64. The utility crashes on load. I did manage to get the tool to run under Windows Vista x32 so wonder if the target platform could be an issue. As a work around, running the tool inside a virtual machine might move things forward, but I am as stumped as you as to the primary problem.Here is the Application Event Log Dump.EventType clr20r3, P1 applicationdefinitioneditor.exe, P2 1.0.0.0, P3 46b12097, P4 system.data, P5 2.0.0.0, P6 4889deaf, P7 2753, P8 29, P9 system.data.sqlclient.sql, P10 NIL.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Suspect the .NET Common Language Runtime (CLR) - clr20r3 to be the culprit.
-
Saturday, February 13, 2010 11:49 AM
I am also facing the same problem, seems that the tool is very horrible (I am using Windows server 2008 32 bit)
-
Tuesday, April 05, 2011 9:18 PMSame problem here...Win7 x64. Is there really no solution to this yet? MOSS 2007 has been out for over 4 years, and there is still no good tool by MSFT to connect a BDC? This is frustrating to say the least.
.png)
