Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Slow ODBC connection

Slow ODBC connection

From: Steven Rorabaugh <dogbert_at_lamar.ColoState.EDU>
Date: 1997/10/10
Message-ID: <61mfnn$46os@lamar.ColoState.EDU>#1/1

I have an ODBC connection established between a set of Visual Foxpro 3.0 applications running on a PC (WIN95) and an Oracle database running on our LAN server. The connection is an SPX/IPX connection but will eventually become a TCP/IP connection. The ODBC driver is the Oracle ODBC driver supplied with WIN95 (Microsoft-produced, not an Oracle product). I can create a remote view in Foxpro that accesses a table in the Oracle database, but the data transfer takes forever. I have increased the packetsize of the ODBC connection, but this doesn't seem to have any noticeable effect. Does anyone know of any other steps I can take to drastically increase the speed of the data load? Much appreciated. Received on Fri Oct 10 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US