>I gather you didn't "wrap" the sqlexec command? If so, then making it create the CA on the fly would solve the issue.
>
>>>Antonio,
>>>
>>>Thank you for the explanation. Am I correct to assume that if their organization were using Cursor Adapter, making change from ODBC to OleDb would be possible (without a major rewrite)?
>>
>>I think yes, if we would use CA for data access, then switch between drivers would have been easier.
We have our function around sqlexec (in both dll and our VFP apps). How would we convert it on the fly (we're using ODBC connection and re-use same handle for all commands).
If it's not broken, fix it until it is.
My Blog