rewriting c# app to not use MS Access

Posted 2011-02-09 16:55
by Jeff Riley
in the SQL Server Forum

I need to rewrite a c# app that is accessing an SQL 2008 server via linked tables in MS Access. I have an ODBC connection on my pc to the SQL database located at our hosting facility. I am relatively new to c# and .net programming, so I want to do this the most efficient way. I am just not sure whether to use SqlConnection string, OleDbConnection string, or ODBC connection string. The current connection string is listed below. Thanks in advance for your help. Jeff

OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\PackerLabels\\Data\\packerlabel.mdb");