Hi everyone,

VFP6 or VFP8
WindowXP
MS Server 2003
MS SQL 2000
VPN

I am a new guy to coding with MS SQL and VPN access.

My client's main office using MS Server 2003 and ready to install MS SQL 2000.
His outside office and shop will connect to main office with VPN, then run a

VFP program.

I think that it have to change my VPF program from useing .dbf to SQL.


>>>>Question 1.
Is it call "REMOTE VIEW" ?


>>>>Question 2.
I found some connect MSSQL ways as below:-

A. -SQLSTRING(...)
-SQLEXEC(OCON, "SELECT * FROM LEDGER_FILE WHERE LED_NO=99999" ...)

B. #Define adopendynamic 2
#Define adlockoptimistic 3
orecordset = CREATEOBJECT("ADODB.RECORDSET")
orecordset.OPEN("select * from

LEDGER_FILE","Provider=SQLOLEDB.1;password=;persist secrity info=ture'user

id=sa;initial catalog=pubs;data source=RMH;connect timeout=15",adopendynamic,

adlockoptimistic)

orecordset.movefirst
orecordset.movelast
orecordset.bof
orecordset.eof
orecordset.addnew

The mothed (A) looks very ifficult, but the (B) is easy and as like as .dbf.
Can you tell me, which one is correct and good for me ?
** the no. of records in LEDGER_FILE around 50,000 - 100,000 **


>>>>Question 3
What is the meaning of "Provider=SQLOLEDB.1" ?
What is the stand for ".1" ?