>Hi guys,
>
>I've got a Foxpro database that I'm going to pull information from and put into a single Oracle table. The Oracle computer is remote to the Foxpro computer. I need to just confirm one thing and ask one thing, please.
>
>Which is faster in general -- remote views or SQLCONNECT and SQLEXEC commands? I'm at a point where I could set up my import into Oracle in either fashion, depending on which is more efficient.
IMHO, SPT is more efficient. A remote view does the same but also has the VFP overhead [although minimal].
>No matter which way I jump, either with a remote view or with a SQLConnect, I'm going to need a DSN which means that the Oracle network client is going to have to be loaded on my Foxpro machine, right?
The Oracle Client must be installed along with either the Microsoft ODBC Driver for Oracle [MDAC] or the Oracle ODBC Driver. You do not need to create a DSN, you can use SQLStringConnect instead.
For help with DSN, SQLStringConnect, etc., get
my ODBC DSN class
Mark McCasland
Midlothian, TX USA