ODBC and VC++.net 2005

[Maileen]

Hi,

I'm writing a VC++.net 2005 application and i would like to use the ODBC
connector.

I would like to allow user to choose the DB he wants to have (MS SQL,
PostgreSQl, MySQL, Oracle,...) by choosing the write ODBC driver.
After that, i want to create a system DSN with information enter by user.

But how can i do that ?

i did not find something in OdbcConnection for creating a system DSN.
do you have some information regarding this topic ?

1. i would like to display all ODBC driver available (like that user can
choose
2. after chosing ODBC driver and setting up connectionstring data,
application should create a Systen DSN.

thanks for help.

Maileen

 

[Tomas Restrepo \(MVP\)]

Maileen,

I'm writing a VC++.net 2005 application and i would like to use the ODBC
connector.

I would like to allow user to choose the DB he wants to have (MS SQL,
PostgreSQl, MySQL, Oracle,...) by choosing the write ODBC driver.
After that, i want to create a system DSN with information enter by user.

But how can i do that ?

i did not find something in OdbcConnection for creating a system DSN.
do you have some information regarding this topic ?

1. i would like to display all ODBC driver available (like that user can
choose
2. after chosing ODBC driver and setting up connectionstring data,
application should create a Systen DSN.

Really, really old sample, but it might point you in the right direction:
http://www.winterdom.com/dev/mfc/odbcview.html

This is mostly basic ODBC api stuff, so it shouldn't have changed all that
much.