Re: ODBC, FoxPro and Oracle

My problem is that at some given point in time the services for the Oracle are being stopped That means that the programs stop and cannot connect to the server...
The ODBC driver is 2.05.0301 from ORACLE73 v 2.5

Michael Vad

Ted Knijff <knijff_at_bigfoot.com> wrote in message news:37f07235.1278714_at_news.compuserve.com...
> 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:09:39 CDT