ARTICLE

Connection Strings for All Databases

Posted by abdur rehman Articles | Databases & DBA February 17, 2011
This article shows step by step different ways to get connection strings for all types of databases. The article is written for all type of users, beginners, intermediate, experienced
Reader Level:
 

Introduction

Databases are widely used in applications to keep records. A large variaty of Database Management Systems are available in the market and in use. Every DBMS needs a different format of connection string. It's not possible to remember all those formats, so knowing how to get a Connection String for any database makes life easy.

UDL file Method

UDL Files are an easy way to get the desired connection string by simply filling in property pages. The following steps show how to make and use a UDL file for that.

1. Make a New Text Document

1.jpg

2. Open the Text Document, Click on Save As.

2.jpg

3. Write filename as something.udl, file type All files, click Save.

4. Now run something.udl

5. Click on Provider tab. Select the provider and click Next.

database connection string - dontumindit (1).jpg


6. Give the DataBase Path.

database connection string - dontumindit (2).jpg

7. Write Username, Password if any

database connection string - dontumindit (3).jpg


7. Click on Test Connection.

database connection string - dontumindit (4).jpg


8. If it's OK, then close it now.

9. Now open udl file as Text File with Notepad

database connection string - dontumindit (5).jpg

11. The Last line will have the Connection String

database connection string - dontumindit (6).jpg

Visual Studio DataSource Method

1. Add DatagridView to your Form.

2. Click on Arrow in Top Right Corner of DataGridView, Click Choose DataSource, Select Add New DataSource

database connection string - dontumindit (7).jpg

3. Select Database, Click on Next.

database connection string - dontumindit (8).jpg


4. Click on New Connection

database connection string - dontumindit (9).jpg


5. Now Choose DataSource, Click on Continue

database connection string - dontumindit (10).jpg

6. Browse For Database, Provide Username, Password, if any

database connection string - dontumindit (11).jpg

7. Click On Test Connection

database connection string - dontumindit (12).jpg
8. If all is Ok, Click Previous, Copy the Connection String, and Click Cancel, Delete DataGridView if you don't need it.

database connection string - dontumindit (13).jpg


Oracle Connection String

Following is the Correct Format of Oracle Database Connection

 private static string CONNECTION_STRING =
"User Id=myUserID;Password=myPassword;Data Source=(DESCRIPTION=" +
"(ADDRESS=(PROTOCOL=TCP)(HOST=myserver.server.com)(PORT=yourPort#))" +
"(CONNECT_DATA=(SID=yourSID)));"


(For Detailed Study of Connection Strings)

Online Connection strings


SQL Connection Strings


Do suggest/Comment, Help Others

COMMENT USING