I used to be 100% DSN-less connections advocate until I deployed an application to a group that had different versions of Oracle drivers installed that of course had slightly different driver names. When you use a DSN-less connection string, the name of the driver used in the string has to be an exact match of a driver installed on that machine.

The biggest pro of a DSN is you specify which driver to use when you create the DSN on the user's PC. Then all you have to do is make sure the the user creates the exact same DSN name that your application's connection is using.

>Hello Everyone,
>
>I am trying to overcome the need for switching between a number of DSN connection settings that point to different servers, ie., dev, training, live.
>
>The existing remote views use connection objects. I know there are techniques to create DSN less connections but I am unsure how to do this. Also, how would I make the existing RV's use the new DSN less connections ?
>
>Any help very much appreciated.
>
>Many thanks,
>
>Regards
>
>Angie.