Tim,
>Yeah, I understand how to create an ado object and use the connections string with an ado connection. I just thought for some odd reason that FoxPro would have native support for the ole db provider.
>
>The reason I am looking at the ole db provider is because I have a stored procedure that I run from crystal reports and I run the same proc from FoxPro. It runs in crystal in about 30 seconds and about 2 mins in FoxPro. I'm not doing anything special I just "exec storedproc p1 p2 p3". I did find out if you do not use the "exec" command before the proc name that sql server will not release the resource until you close the connection.
>
>Do you have any suggestion?
You could try OLEDB library (file #
10002), which provides OLEDB clones of ODBC SPT functions. But I'm not sure that you'll get a significant gain of performance. However, you'll have a chance to compare.