>I basically took the code from a thread discussiong oledb so I assumed it was the code for an oledb connection. If it is not, how do I connect using OleDB? Thanks.

SQLStringConnect() and SQLExec() are SPT commands, which uses ODBC connection. In VFP there is no native support for OLEDB connections. You have to use ADO or file #10002.