Best Database access method

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

  • Best DB access method
    ... to select a DB type (MS SQL, Oracle, ...) ... we can ask to user to create an ODBC system DSN and after in application let user to setup the DSN. ... keeping in memory that several DB accounts will be used for executing stored procedures ...
    (microsoft.public.vc.mfc)
  • Best DB access
    ... to select a DB type (MS SQL, Oracle, ...) ... we can ask to user to create an ODBC system DSN and after in application let user to setup the DSN. ... keeping in memory that several DB accounts will be used for executing stored procedures ...
    (microsoft.public.data.ado)
  • Best DB access method
    ... to select a DB type (MS SQL, Oracle, ...) ... we can ask to user to create an ODBC system DSN and after in application let user to setup the DSN. ... keeping in memory that several DB accounts will be used for executing stored procedures ...
    (microsoft.public.vc.database)
  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)