User Selectable databases via ADO
-
Hello, I'm working on an application where the user needs to be able to select an external database to use within the application. I can handle mdb, db files, etc. But I'm not really sure how to handle allowing the user the ability to select and ODBC data source for example. Does ADO have some functionality that would allow me, the developer, to surface a standard dialog that the user could either select an ODBC data source and/or create and OLE DB source to access the data? I guess I'm looking for something similiar to ODBC's SQLConfigDataSource functionality. Perhaps this is my answer??? Thanks, Rob
-
Hello, I'm working on an application where the user needs to be able to select an external database to use within the application. I can handle mdb, db files, etc. But I'm not really sure how to handle allowing the user the ability to select and ODBC data source for example. Does ADO have some functionality that would allow me, the developer, to surface a standard dialog that the user could either select an ODBC data source and/or create and OLE DB source to access the data? I guess I'm looking for something similiar to ODBC's SQLConfigDataSource functionality. Perhaps this is my answer??? Thanks, Rob
I'm not sure now but I remember in
Open()function of your database there is a flag that specify if there is no ODBC database,open a dialog and user can choose database. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down -
I'm not sure now but I remember in
Open()function of your database there is a flag that specify if there is no ODBC database,open a dialog and user can choose database. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors DownFound what I was looking for in the Interactive SQL tool example http://www.codeproject.com/database/isqlado.asp It has some code showing the use of PromptNew. It was exactally what I needed for this project. Rob