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:
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.