>I am getting an error on line:
>
>replace &cFldName. with "Something"
>
>in stored procedure used from .net over OleDb.
>
>I don't see a macro as one of unsupported commands in Ole Db. But maybe I am missing something.
Correct. Macro's are not supported in the OLEDB provider. Reference post by Gene Goldhammer on the subject:
http://tinyurl.com/ysg9r.