Introduction
While developing Ado.Net Applicaions most of the errors comes because of the wrong format of Connection String used to connect the application with the DataBase. I am publishing some Connection String formats to connect with different types of DataBase.
Connection String Formats
To connect with the Ms-Access 2003 DataBase Connection String Format:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Full Path of the DataBase File with Extension (".Mdb");Persist Security Info=True;Jet OLEDB:Database Password=********"
To connect with the Ms-Access 2007 DataBase Connection String Format:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Full Path of the DataBase File with Extension (".accdb");Persist Security Info=True;Jet OLEDB:Database Password=********"
To connect with the SQL Server DataBase Connection String Format:
"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DataBaseName.mdf;
Integrated Security=True;User Instance=True"
To connect with the MYSQL DataBase Connection String Format:
"DataSource=Sever Name;DataBaseName=DataBase File Name;
UserName="Name";Password=*******"
I hope this will help New developers in ADO.Net Programming.
It always seems good to hear about me, but the thing I do is I code. I'm Interested in Designing Windows Based Application, Web Applications and building Mobile Applications. Currently restricting it to Android 4.0 applications, building Internet Based Applications using ASP.NET and contributing to bring the student community to a position which will help technology to reach the greatest heights ever. A very Big fan of Microsoft & Android..!!