dsn creation manually and programmatically

[pspsblog]

If I want to create a connection to database table, do I need to create DSN object manually in control panel and programmatically using connection string in create adodb connection object? Do I need to do both? Is there any advantage of doing both? or just either one method? which is suggested over another to query and for database check points. Can I do it programmatically successfully if I don't have admin access? If I want save the dsn object created programmatically in test data file, how to do that?

[Deep@k]

To establish the connection, there are two different ways. You can choose either one of these.

Advantage of Connection Strings :

Connection Strings : Easy to Modify.
DSN : You may have to have Permission on the System.

Connection Strings : Being the Part of the application.
DSN : Related to System Set Up.

[pspsblog]

Thanks! When I use the connection string in the application, how can I save the dsn object in the test data location?