Rewriting c# app to not use MS Access

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");

0 answers