Click here to Skip to main content
Click here to Skip to main content

How to connect with different types of DataBase?

, 25 Nov 2011
Rate this:
Please Sign up or sign in to vote.

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.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Manoj K Bhoir
Software Developer
India India
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..!!
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
Generalvery nice article Pinmemberprashant kolekar2-Dec-11 2:07 
GeneralReason for my vote of 1 Agree with John, Richard and Mika. -... PinmvpSAKryukov26-Nov-11 13:15 
GeneralReason for my vote of 1 See Mika's alternative; something y... PinmvpRichard MacCutchan26-Nov-11 3:03 
GeneralReason for my vote of 1 I'm at a complete loss as to why thi... PinmvpJohn Simmons / outlaw programmer26-Nov-11 1:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 25 Nov 2011
Article Copyright 2011 by Manoj K Bhoir
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid