Re: ODBC, FoxPro and Oracle

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 - 02:46:00 CDT