Re: VFP and Oracle

From: <sbesnard_at_krier.fr>
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 sql

pass-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