+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: dsn creation manually and programmatically (/Thread-dsn-creation-manually-and-programmatically)
dsn creation manually and programmatically - pspsblog - 08-02-2009
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?
RE: dsn creation manually and programmatically - Deep@k - 08-06-2009
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.
RE: dsn creation manually and programmatically - pspsblog - 08-09-2009
Thanks! When I use the connection string in the application, how can I save the dsn object in the test data location?