>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.
>
Basically, they are the same speed because remote views are really just a nice wrapper to SPT. Everything is still done using the ODBC driver.
>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?
Instead of the using SQLConnect, you can use SQLStringConnect and you don't need the DSN to be on everyone's PC. Ex.
lnconn = sqlstringconnect([Driver={Oracle ODBC Driver};DBQ=MyDomain.World;UID=SomeUser;PWD=Password])
In either case, you still need the Oracle ODBC driver installed on all PCs. You will simply access it directly instead of via the DSN.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao