Want to grab a list of available databases on a given server

[_AnonCoward]

I have MSDE running on my system and I want to get a list of databases
for that server programmatically. I'm using vb.net and I want to view,
add, delete and modify databases on a server from within a class.
I'm aware I can use the "Server Explorer" feature in Visual Studio, but
that isn't what I'm looking for. Any references or suggestions on where
to start are appreciated.

TIA

Ralf

[Stu]

Look up SQLDMO on the web; not sure how it will work with MSDE, but
it's the object model for working with SQL Server programmatically.

Stu

[_AnonCoward]

Thanx. A quick review looks promising. 'Preciate the help.
"Stu" <st**************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
: Look up SQLDMO on the web; not sure how it will work with MSDE, but
: it's the object model for working with SQL Server programmatically.
:
: Stu

[_AnonCoward]

This seems to be exactly what I'm looking for. I do have a problem
however. I have MSDE running on my system, but I have no idea what to
use for user id and password. Any suggestions?
"Stu" <st**************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
: Look up SQLDMO on the web; not sure how it will work with MSDE, but
: it's the object model for working with SQL Server programmatically.
:
: Stu
:

[Erland Sommarskog]

_AnonCoward (ab*@xyz.com) writes:

This seems to be exactly what I'm looking for. I do have a problem
however. I have MSDE running on my system, but I have no idea what to
use for user id and password. Any suggestions?

I don't know DMO, but you should be able to log with integrated security.
Anything else would be very very strange.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Joe Cool]

On Tue, 07 Jun 2005 20:03:18 GMT, "_AnonCoward" <ab*@xyz.com> wrote:

This seems to be exactly what I'm looking for. I do have a problem
however. I have MSDE running on my system, but I have no idea what to
use for user id and password. Any suggestions?
Any user that is listed in Security Logins in the Enterprise Manager.

You can use the sa account and it's password, or you can create a new
account, or you can use integrated security if you installed SQL to
use Windows authentication.


"Stu" <st**************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googleg roups.com...
: Look up SQLDMO on the web; not sure how it will work with MSDE, but
: it's the object model for working with SQL Server programmatically.
:
: Stu
:

[Joe Cool]

On Tue, 07 Jun 2005 17:52:02 GMT, "_AnonCoward" <ab*@xyz.com> wrote:

I have MSDE running on my system and I want to get a list of databases
for that server programmatically. I'm using vb.net and I want to view,
add, delete and modify databases on a server from within a class.
I'm aware I can use the "Server Explorer" feature in Visual Studio, but
that isn't what I'm looking for. Any references or suggestions on where
to start are appreciated.

I have used the Information Schema to do this with:

select catalog_name as name from information_schema.schemata

This worked fine with SQL7, but I have had some problems with it with
SQL2K. User databases don't show up in the Information Schema until
they have been accessed.

[Ross Presser]

On Tue, 07 Jun 2005 22:18:30 GMT, Joe Cool wrote:

On Tue, 07 Jun 2005 17:52:02 GMT, "_AnonCoward" <ab*@xyz.com> wrote:

I have MSDE running on my system and I want to get a list of databases
for that server programmatically. I'm using vb.net and I want to view,
add, delete and modify databases on a server from within a class.
I'm aware I can use the "Server Explorer" feature in Visual Studio, but
that isn't what I'm looking for. Any references or suggestions on where
to start are appreciated.

I have used the Information Schema to do this with:

select catalog_name as name from information_schema.schemata

This worked fine with SQL7, but I have had some problems with it with
SQL2K. User databases don't show up in the Information Schema until
they have been accessed.

A alternative that would work with SQL 6.5 and up would be

SELECT name from master.dbo.sysdatabases

Almost certainly *won't* work with any non-MS RDBMS, though.