Database Name In Connection String

[irasmith]

When creating a connection string and using the Integrated Security option, is it necessary to specify the name of the Database as well?

 

I am asking this as what I am working on would be used in an environment that is set up so that your Win/NT login controls the database you have access to.

 

Given that, I wasn't sure if my own application would need to specify the database or if it could be left out of the connection string totally.

[mocella]

You can initialize to some general database for your connection string, but change it later using:

 

Dim sqlConn As New SqlConnection _("server=localhost;database=TestDB")

 

sqlConn.ChangeDatabase("specifyTheUserDBHere")

[irasmith]

Thank you for the suggestion. I am making note of it for use when my project gets to that point.