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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.