>>>He set my DSN up using a Dbase odbc, not foxpro. How did I find this out, because on of the lesser used pages uses the ATC() command for foxpro.
>>
>>Cut out the middle-man, cost and frustration and use a DSN-less connection to the database. Here is an access example (thought I know you are using VFP).
>>
>>http://www.4guysfromrolla.com/webtech/070399-1.shtml
>
>Do you know of any VFP sample code for DSN-less connections. I noticed that the access sample code uses oledb but that is not available in foxpro yet is it.

I found this in another thread but I have not used it.

lnHandle = SQLStringConnect("Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=r:\ultra\prod\quotes.dbf")

lnResult = SQLExec(lnHandle, "Select * from r:\ultra\prod\quotes.dbf", "crsResults")


HTH
Jeff