Re: ODBC, FoxPro and Oracle

hi,
I don't appear to have any problem reading data, but when ever I try to update a record, that is a remote database, foxpro keeps complaing that the record is in use, even though it is not.

I use ms Query, using the same settings and odbc drivers and it's really cool.

steve

Ted Knijff <knijff_at_bigfoot.com> wrote:

> I have no problems using FoxProW or VFP with Oracle. What specifically
> is going wrong and which versions are you using, which ODBC drivers ?
>
> Ted
>
> On Mon, 27 Sep 1999 18:25:22 +0800, spectre_at_hkstar.com (Steve A)
> wrote:
>
> >Hi,
> >I had real problems getting my fox pro to work with the oracle.
> >Reading data was no problem but writing was a real failure.
> >
> >In the end I read using foxpro, but if I want to write data
> >i have procedures stored on the oracle database, tehn pass the records
> >as perams.
> >see below
> >
> >m.or_error=SQLEXEC(ORA_CONS,"{call
> >add_inspection('&magic98','&sup98','&model98','&batch98',"+STR(M.quant98
> >)+;
> >",'"+DTOC(INSPDATE98)+"',"+ALLTRIM(STR(M.company))+",'&therep98','&repin
> >dx98','&rOTindx98',"+ALLTRIM(STR(M.result98))+")}")
> >
> >
> >where add_inspection is an oracle procedure that takes perams, it's a
> >bit shitty but it seems to be more stable and easy to control, than
> >trying to write the data to a remote database.
> >
> >
> >
> >
> ><michael.vad_at_mobilixnet.dk> wrote:
> >
> >> Hi
> >>
> >> I have a FoxPro application running on a server. The application reads and
> >> writes data to the Oracle database via ODBC. The Oracle database is placed
> >> on the same server as the FoxPro application.
> >>
> >> My problem is that at some given point in time the services for the Oracle
> >> are being stopped !!! Most of the time there is no problem. I do not know
> >> what causes the services to be stopped - conflict etc.
> >>
> >> 1. Is there a log file where I can see when and by who the Oracle services
> >> are stopped?
> >> 2. Is there any other way to connec to the Oracle database from my FoxPro
> >> application other than ODBC?
> >>
> >> Thanks
> >> Michael Vad
>
> EMail: knijff_at_bigfoot.com
Received on Tue Sep 28 1999 - 04:53:35 CDT