Connection string for sql server 2008 express database

Question

0.00/5 (No votes)

See more:

I am creating a database programmatically in a vb.net winform project. I am wondering what is the connection string I use? The one I used up to now has been:

VB

connectionString = "Data Source=.\SQLExpress;Initial Catalog=Master;Integrated Security=True;MultipleActiveResultSets=True"

This has worked because before I had the database already created in SQL Server 2008 express, so I was just connecting to the database that was there using the above connection string. Initially when I created the project, it would connect to the database and use the database accordingly, but now I want to create the database programmatically first in the project and then let it do what it's supposed to do. Should I be changing the connection string and if so, what should I change it to, to do this?

Posted 7-Aug-14 4:10am

Member 10804519

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-08-07T04:26:00

Solution 1

Change the "Initial Catalog" from "Master" to the name for your new Database.

Posted 7-Aug-14 4:26am

OriginalGriff

Comments

Member 10804519 7-Aug-14 10:45am

That won't work, I need the connection string to connect to SQL Server when the database isn't created. I can't replace 'Master' with my new database if the database doesn't exist.

OriginalGriff 7-Aug-14 10:56am

Then you need to tell us exactly what you are trying to do when you ask a question! :laugh:
Remove the "initial catalog" part completely and it should just connect. Then provided you have suitable permissions, you can just create the DB.

Member 10804519 7-Aug-14 11:28am

Do I leave the 'Initial Catalog=myDatabase' part in the connection string where I am creating the tables for the database?

OriginalGriff 7-Aug-14 11:38am

Yes - or use the "USE databasename" command in your cretae table query

Member 10804519 7-Aug-14 12:06pm

Thank you very much. I understand now and you've helped me a lot.

OriginalGriff 7-Aug-14 12:07pm

You're welcome!