Charlotte Foust
cfoust at infostatsystems.com
Mon Jun 11 10:27:16 CDT 2007
Oh, sorry. I misunderstood. We don't allow our users that kind of freedom in SQL Server, we just use SQLOleDb as the provider for our SQL Server connections, and the user has to know the name of the database involved. Charlotte -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, June 11, 2007 8:09 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Get list of servers, databases and tables in a database No, I mean programmatically. Basically I am looking to populate a combo with servers, then when I select a server, populate a combo with databases, select a database, populate a combo with tables etc. I am writing an application for the import / export / import of data. Flat files into SQL Server, data back out to "CSV" for address validation, data back in from CSV. ATM I am hard coding all the locations but eventually I must get this thing more automated so I am just boning up on how to browse through database objects. I am looking at code right now for the SQLDMO object which looks like it will serve the purpose. It is not part of .NET but I can reference it from my project. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, June 11, 2007 10:55 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Get list of servers, databases and tables in a database View menu, Server Explorer. Charlotte -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, June 11, 2007 6:49 AM To: dba-vb at databaseadvisors.com; dba-sqlserver at databaseadvisors.com Subject: Re: [dba-VB] Get list of servers, databases and tables in a database I forgot to specify that I am using VB.Net for this. So I need to know how to do all this inside of VB.Net. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, June 11, 2007 9:26 AM To: dba-sqlserver at databaseadvisors.com; dba-vb at databaseadvisors.com Subject: [dba-VB] Get list of servers, databases and tables in a database I need to allow a user (me) to navigate through my servers, databases and tables in databases to select a specific table, for example to export to CSV. Does anyone know how to determine instances of database servers, then get lists of databases in those servers, then get tables in a specific database? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com