>>Are you sure that you need a DSN? There are many ways of using DSN-less >connections (specially if you are using ADO).
>
>can u plz suggest one of the ways to use dsn-less connection
>i know only one that is specifying the server name in ur connection string. infact its fast too !!!!
>but when i use crystal reports i've to go for dsn. so i end up managing two connection strings, no other choice.
>and then i've to manage machine name too !!! i'm quite confused in choosing and managing one of the way to keep my application configuration file and keeping security in mind.
It's easier to have a DSN when working with CR. Instead of managing 2 connections strings, I would really go creating a DSN on-the-fly with the info contained into the .INI file everytime the application is running.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com