>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.