Look in the VFP help file for create connection and sqlexec. I don't have any of my code in front of me, but it's doable.
>Ken,
>
>I may have mislead you. I'm pretty sure DSN-less connections only work in ADO where you substitute the name of the ODBC driver for the provider. Sorry about that.
>
>Bob
>
>>Bob,
>>
>>Can you give me an example of a "DSN-less connection string" usage?
>>
>>TIA,
>>Ken
>>
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright