Re: VFP and Oracle
Date: 1998/04/14
Message-ID: <6h034i$ddi$1_at_nnrp1.dejanews.com>#1/1
In article <01bd61fa$63b7a560$e940d6c3_at_bp>,
"Bastien piroue" <bastien.piroue_at_gsi-pat.de> wrote:
>
> Hello,
>
> I have a problem concerning VFP and Oracle 8 - Server.
>
> We have an application where an interface to remote Databases is
> implemented. All works fine with MS SQL - Server and, with some work, also
> with ORACLE 7.3.3. But: Our customer wants to use the Oracle 8.0.4.0 -
> Server - Version. By putting thze data via the ODBC - driver 8.04, 8.041,
> 8.042 or 8.042, VFP crashes when issuing the tebleupdate command, which
> tells the ODBC driver to put the data to the server. Sometimes, the first
> tableupdate - command crashes, sometimes the 20'th command crashes.
>
> I can't imagine, that VFP and Oracle 8.0.4 won't work together. Any ideas?
>
Hello !
I do have some performance problems with VFP 5.0a and Oracle 8.0.4 It will be great to share experience on this subject (vfp - odbc - oracle).
Here is my configuration :
Client :
* Platform : Windows 95 * ODBC Driver : INTERSOLVE 3.10 32-bit Oracle8 (3.10.0000) * Application : VFP 5.0(a) (version date = 24/01/97)
Server :
* Platform : Windows NT
* Oracle 8.0.4.0.0
Can you tell me :
- which configuration do you have ? - are you satisfied with odbc & vfp performances ? - have you ever try a similar experience as mine (use a remote view or a sqlpass-through command of an Oracle 8 table that has hundred records and 255 fields ; we want to have ALL the data at once ; and it takes ages). If so, I would be interested to know about performances. Tell me also if wanting "all the data at once" is a nonsense when we do ODBC or if it's reasonable.
Here is my code with an SQL pass-through command:
close data
a=seco()
lnDescConn=SQLStringConnect("DSN=SERV_ORPI;UID=SB;PWD=SB;SRVR=SERVEUR_NT")
if lnDescConn>0
? SQLExec(lnDescConn,"SELECT * FROM EBIENGEN","vueEbiengen") = SQLDisconnect(lnDescConn)
endi
b=seco()
? b-a
It takes 30 seconds !
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 00:00:00 CEST