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
_________________________________
There are 2 types of people in the world: