SQL Server Express connection string to use with SqlClient.SqlConnection

Question

1.00/5 (2 votes)

See more:

Hi everyone!

I have googled this and even checked http://www.connectionstrings.com/[^]... but it seems I am having a really slow day, so please bear me.

I am trying to connect to an SQL Server Express database using System.Data.SqlClient.SqlTransaction (*)

So, this is the connection string I am using:

Dim objConn As SqlClient.SqlConnection = New SqlConnection("Source=my_server; Initial Catalog=ASSET_TEST; User Id=thisapp; Password=nottherealone;")

Exception is raised:

"Palabra clave no admitida: 'source'."

wich translates into

"Keyword not addmited: 'source'."

However, everything goes just fine if I connect to the same database using:

VB

Dim objCon As OleDbConnection = Nothing
Dim sCnn As String

Try
    sCnn = "Provider=SQLOLEDB;Data Source=my_server;Initial Catalog=ASSET_TEST;User Id=thisapp;Password=nottherealone"
    objCon = New OleDbConnection(sCnn)
    objCon.Open()

Does anyone know what's wrong with the first connection string?

Thank you for reading my super long question!

(*) I hope this is possible as MSDN states that "The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server" ... and I hope it includes the express edition as well.

Posted 10-Aug-11 9:46am

iris.frigole

Add a Solution

4 solutions

Solution 3

This is an example of what I use;
connectionString="Data Source=.\SQLEXPRESS;initial catalog=JAXCODERDB;Integrated Security=SSPI;User Instance=False" providerName="System.Data.SqlClient"

Posted 10-Aug-11 10:04am

Mike Hankey

Comments

iris.frigole 10-Aug-11 22:50pm

Yes!

Solution 4

Instead of DataSource you used Source and as a result you got this error message...

Posted 10-Aug-11 23:25pm

Humayun Kabir Mamun

Solution 2

http://social.msdn.microsoft.com/Forums/es/vbes/thread/8b86657d-8bab-435a-81eb-de4bed9f8b83[^]

Posted 10-Aug-11 9:55am

Monjurul Habib

Comments

iris.frigole 10-Aug-11 22:51pm

Long thread that I did not read, as the 1st reply solved my problem, but thanks for providing the link in Spanish!

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)

luisnike19 · Accepted Answer · 2011-08-10T09:54:00

Solution 1

Try

Dim objConn As SqlClient.SqlConnection = New SqlConnection("Data Source=my_server; Initial Catalog=ASSET_TEST; User Id=thisapp; Password=nottherealone;")

Posted 10-Aug-11 9:54am

luisnike19

Comments

iris.frigole 10-Aug-11 22:50pm

Yes... Data Source instead of Source did the trick! Thank you!