Creation of User DSN

[RaajaOfSelf]

Iam doing a MFC project .I need to launch the diaolog box which prompts the user to create the DSN ( which is normally done by manually clicking control panel->Administrative Tools->ODBC). How do i launch the Dialog box which prompts the user to create a new USER DSN .:) "Nothing worthwhile is ever achived without Deep thought and hardwork "-JRD Tata

[HJo]

From the top of my head there are a couple of ways to do it: - SQLDriverConnect() in the ODBC API - CDatabase::Open() / OpenEx() It is probably possible to get it from other database APIs as well... Hope it helps!

[RaajaOfSelf]

HJo, CDatabase::Open gives an option to OPEN .But it also gives an option to SELECT the DSN too .WHat i require is the dialog box which prompts the user to ADD,Remove ,COnfigure DSNs. ANyway ,thanks a lot for the suggestion

[Bartosz Bien]

Check out the function named ConfigDSN :cool: Regards, BB