>Take a look at sqlconnect(),sqlexecute(),sqldisconnect() in the help file.
>Basics are as follows.
>
>Make coonect to remote system using DSN on DNSless String
>
>gn=sqlconnect('YOURDSNNAME','YOURUSERNAME','YOURPASSWORD')
>
>get date
>
>sqlexec(gn,'SELECT * FROM YOURDATA','TEMPCURSORNAME')
>
>Do your thing here
>
>sqldisconnect(gn)
>
>
>This is a vast over simplification. Read the help.
>
>
>
>Jeff
>
>>>>>>Hello all,
>>>>>>
>>>>>>I've been using VFPCOM for the past week and initially I thought it was going to do a clean job. I'm trying to use the function RSToCursor() to create a cursor from a SQL 7 table, and for some reason is bringing only values in two or three columns rather than in all of the fields. It is bringing all the records I'm expecting, but not their full values.
>>>>>>
>>>>>
>>>>>RSTocursor is flaky in more than one respect. Any reason you're using ADO instead of SPT for this?
>>>>
>>>>Hi Erik,
>>>>
>>>>I'm building a COM object which is getting data from a SQL backend and one of the requirements is not to have a VFP database holding any views or connections to it; is there any other way to connect to SQL and do processing rather than ADO?.
>>>>
>>>
>>>You can use SQL PassThrough and have your data returned in a VFP cursor directly...
>>
>>I haven't done anything with SPT yet, is there anything available here at the UT that I can use for directions? Or any site that has documentation/samples?
>>
>>Thanks

Thanks Jeff, this is a really good point to start from.