Hi!
This is because your views do not use shared connection. If you have, say, 50 views in the databsae, each will connect to the SQl Server by its own connection handle (connection session). SQL Server do not allows so many connections, usually, or 50 and more connections at the same time slow down the server and cost a lot of $$ for licensing.
There is 'SHARED' option when you create remote view. When editing view in the view designer, there is an option for view in the view properties dialog box (called from the menu).
Make all your views as shared so they all use the same connection handle.
HTH.
>Dear Vlad,
>
>Thanks for your information. The problem is a have designed the remote view on the database designer, which is always ask for the connection name. Eventhough i use SQLEXEC to change the database, when i opened other remote view, it will always connect to old database.
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.