>>Thanks - I am using this...
>>>>STORE SQLSTRINGCONNECT("Provider=sqloledb; Data Source=SBS01; "+;
" Initial Catalog=NORTHWIND; User Id='sa'; Password='password'") TO gnConnHandle
>>
>
>>But when this code runs it's brings up "Select Data Source" window for me to select a DSN!
>you can't use SQLOLEDB from Visual FoxPro, you have to use ODBC.You can't with SPT, Connections & RemoteViews, you can with ADO.
You can use ADO from VFP, also using with CursorAdapters+ADO making this issue just easy.