Unanswered: displaying list of available databases in SQL Server 2000 using VB??
I am creating a userform to compare tables in different databases. How do i go about populating a listbox with all the database names associated with my SQL Server 2000 instance? I would rather populate a list than creating text boxes to select of the databases i know will exist, users will also create new databases so that approach would be flawed.
So anyone know how i can do this using VB? I just want to know how to access the database names since usually you need the database name to connect to SQL Server to begin with
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!