Initializing ADO.Net SQL connection in Windows Service.

[Carlo Razzeto]

I am trying to initialize an ADO.Net SQL connection to an sql server in my
Windows service and I'm getting the following exception while trying to
initialize the SqlConnection Object. The language is C#.

System.ArgumentException: Unknown connection option in connection string:
user.
at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String
conString, Hashtable values)
at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String
connectionString)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in
c:\documents and settings\carlo razzeto\my documents\visual studio
projects\notifyexpiredresume\expiredresume.cs:line 111

Here is what my connection string looks like and initializer looks like:
private string ConnectionString = "Data Source=(local); User=sa;
Password=****; Initial Catalog=JobSite";
public SqlConnection SQLConnection;


try
{
SQLConnection = new SqlConnection(ConnectionString);
}
catch(Exception ex)
{
EvntLog.WriteEntry("There has been an exception trying to init
SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error);
EvntLog.Dispose();
return;
}

 

[Miha Markic]

Hi Carlo,

Try with this:
workstation id=***;packet size=4096;user id=sa;data source="(local)";persist
security info=True;initial catalog=Northwind;password=***

 

[Carlo Razzeto]

thanks, that pretty much worked...

Carlo

Hi Carlo,

Try with this:
workstation id=***;packet size=4096;user id=sa;data source="(local)";persist
security info=True;initial catalog=Northwind;password=***

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com

I am trying to initialize an ADO.Net SQL connection to an sql server in my
Windows service and I'm getting the following exception while trying to
initialize the SqlConnection Object. The language is C#.

System.ArgumentException: Unknown connection option in connection string:
user.
at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String
conString, Hashtable values)
at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String
connectionString)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in
c:\documents and settings\carlo razzeto\my documents\visual studio
projects\notifyexpiredresume\expiredresume.cs:line 111

Here is what my connection string looks like and initializer looks like:
private string ConnectionString = "Data Source=(local); User=sa;
Password=****; Initial Catalog=JobSite";
public SqlConnection SQLConnection;


try
{
SQLConnection = new SqlConnection(ConnectionString);
}
catch(Exception ex)
{
EvntLog.WriteEntry("There has been an exception trying to init
SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error);
EvntLog.Dispose();
return;
}