Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC vs Remote View - Also, Oracle question
Message
 
 
To
28/01/2002 15:11:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611833
Message ID:
00611853
Views:
24
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform