Best DB access

Hi,

I would like to write an application which allows users :
- to select a DB type (MS SQL, Oracle, ...)
- to create DB and users accounts

however, i would like to know what is the best method to do that.
1. we can ask to user to create an ODBC system DSN and after in application let user to setup the DSN.

2. directly into application to create a particular module which will allows users to insert all data regarding connection string to DB.

Maybe it exists some other solutions but i do not know.
Please could you let me know how to make it as much as flexible and professional ?
keeping in memory that several DB accounts will be used for executing stored procedures (for example)

thanks a lot,

Maileen
.

Relevant Pages