Hmmm,

Well then, I'd suggest you create a single userid/password in SQL that your app connects as and hard-code that into the connection or use trusted connections (I think you can do that in a saved connection) and go to SQL as whoever is logged into the PC.

OR (just thought of this) and this may be your solution:

Why not just recreate the connection each time you need it:

DROP CONNECTION ProdSQL
CREATE CONNECTION ProdSQL USERID usr PASSWORD pass ...

You can do a CREATE CONNECTION and feed it the parameters or a connection string.

HTH,
Chad

>Hi Chad,
>
> I've created remote views in my application and those connect via a connection. That's why I need one...
>
>Jim