URGENT: FoxPro COM Object

From: Faraz Khan (faraz.khan_at_ezdoc.net)
Date: 09/11/04 

Date: 10 Sep 2004 22:02:14 -0700

Please Please Please. I am in time crunch and need to have fast access
to a FoxPro database (*.dbc file). Thru VB, I tried using both OLE-DB
and ODBC drivers for fox pro to insert/update data in that database.
However, there are certain code in the foxpro triggers and field
validation rules that are not supported under ODBC or OLE-DB. So my
app fails.

Up until now I have been editing the stored procedures in foxpro to
comment out the incompatible code that causes the problem. But I can
no longer do that. The 3rd party app which has the foxpro DB has been
updated in such a way that changing the stored procedures codes will
break the 3rd party app, which is not an option anymore.

Someone suggested creating a very simple 1 method COM object using
foxpro. Thet single method will take a string as input and return a
ADO25.Recordset object. The method will exeucte ANY sql passed to it
after connecting to the DBC file. Since the method is written in
foxpro it should have no problems with the stored procedures within
the DBC. Is this possible??

Please help me write this COM object. I have no idea what to do or
how to begin. Please keep in mind that this COM object must not have
any GUI, since its has to run in ASP, ASP.NET as well as VB.NET
console app as a batch.

Relevant Pages

  • Re: Word mail merge with foxpro
    ... > I am trying to connect to a dbf fine not the database. ... >> I do not think you will be able to open a .dbc using ODBC by selecting ... >> using that approach (in the Select Data Source dialog, ... >>> Firstly the files of type drop down does not give a foxpro option. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word mail merge with foxpro
    ... I am trying to connect to a dbf fine not the database. ... > I do not think you will be able to open a .dbc using ODBC by selecting the ... >> but when opening the data source in the mail merge helper I hit problems. ... >> Firstly the files of type drop down does not give a foxpro option. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word mail merge with foxpro
    ... is to switch on ODBC logging in the ODBC administrator. ... Would it be possible to try connecting to a .dbc? ... One thing I am unsure of in FoxPro these days is whether dbf have the same ... Unfortunately with no error messages to give us a ...
    (microsoft.public.word.mailmerge.fields)
  • URGENT: FoxPro COM Object
    ... to a FoxPro database (*.dbc file). ... I tried using both OLE-DB ... there are certain code in the foxpro triggers and field ... break the 3rd party app, which is not an option anymore. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Word mail merge with foxpro
    ... I'm not particularly familiar with FoxPro any more but ... I do not think you will be able to open a .dbc using ODBC by selecting the ... OpenDataSource, e.g. using a User/System DSN called vfpdbc, a .dbc at ... > but when opening the data source in the mail merge helper I hit problems. ...
    (microsoft.public.word.mailmerge.fields)
Loading