Hi!

What parameters youmeant - parameters for view or parameters - user ID and password for connection? If first - just assure that variable with the name you used as parameter for view exists before USE command. If second - take a look to SQLSetProp()/SQLGetProp() function help and check whatis a value of DispLogin option. Several SQLSetProp() options are used when you connect just by connection string. Youhave also provide UID and password as part of the connection string.

HTH.

>Sorry, I face problem agian ...
>
>Even I add the NODATA to the USE statement, but my Remote parameterized view keep asking for it.
>
>
>eg.
>
>USE database1!view1 CONNSTRING (cConnStr) NODATA
>
>
>How to stop the system prompting for the value of parameters?
>
>TIA.