Connect VB with SQL (Local + unknown database name)

Question

Basically I want to know if it is possible to connect my VB app with SQL server on the same Computer (Local) and interrogate it for a list of database names.

I just want to know if that is possible.

sqlConn.ConnectionString = Data Source=local;Initial Catalog=unknownDatabase;User Id=knownUsername;Password=knownPassword;"

Fill DataBase Names to Drop Down

User Selects DB Name

Change Connection to now Known DatabaseName

Try this: stackoverflow.com/questions/147659/…

TGH
– TGH

2013-06-06 03:09:31 +00:00
Commented Jun 6, 2013 at 3:09 — TGH
– TGH, Commented Jun 6, 2013 at 3:09

Tom Studee · Accepted Answer · 2013-06-06 03:08:43Z

2

Of course it is possible.. You can create a connection to a local SQL instance the same way you'd create a connection to a remote one.

Then to get a list of the databases on the server, execute "SELECT Name FROM master.sys.databases"

answered Jun 6, 2013 at 3:08

Tom Studee

10.5k4 gold badges42 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

UPGRAYEDD Over a year ago

When I try creating a connection to SQl, it asks for the database name tho..?

Tom Studee Over a year ago

@UPGRAYEDD try setting initialcatalog=master, since you know master has to exist.

UPGRAYEDD Over a year ago

cool, Ill go ahead and code it tonight and try it at work in the morning, Thanks!

Collectives™ on Stack Overflow

Connect VB with SQL (Local + unknown database name)

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related