>Craig--
>
>>CursorAdapter is not magic It will use either ODBC or ADO. Probably the quickest way will be SQL Pass Through (SPT).
>>
>>>What is the simplest way to access Advantage tables (ODBC, CusorAdaptor, etc). I don't need to do much more than import them into VFP tables. I was using VFP COPY FILE. That no longer works when anyone is using the app that creates the tables using Advantage.
>
>
>Craig--
>
>I got the ODBC driver for Advantage installed. The SQLCONNECT in VFP now works. SQLTABLES works. SQLEXEC(4, "EXECUTE PROCEDURE sp_mgGetAllTables()") works.
>
>SQLEXEC (4, 'select * from insured','sam') does not work ("insured" is one of my tables)
>
>Any thoughts?
>
>
>Tim
Have you looked at this?
http://www.sybase.com/files/White_Papers/Sybase_Advantage_VFP_GettingStarted_wp.pdf
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"