>>>I did try that and it didn't work.
>>>
>>>When I turn off ODBC login prompts, I get tbe following error message:
>>>
>>>Connectivity Error: [Microsoft][ODBC Driver Manager]Data Source Name not found and no default driver specified.
>>>
>>>Does Foxpro's connection string support not include the OLEDB provider?
>>I just reviewed my examples where I use OLE-DB providers and in all of them I am going via ADO connection (instead of SQLStringConnect.)
>>
>>That does not mean that SQLStringConnect does not support OLE-DB providers, but it does mean that I don't know the answer to your question :(
>
>The SPT functions in FoxPro cannot be used with OLEDB providers (at least out of the box), only with ODBC drivers. I don't think that changed with VFP7.
Thanks for the info!