Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server MSSQL Connection String For ODBC, OLEDB, SqlConnection

MSSQL Connection String For ODBC, OLEDB, SqlConnection

Below is a list of examples of database connection strings to use with various SQL Server data providers (ODBC, OLE DB, OleDbConnection (.NET), SqlConnection (.NET)) in your application.

1. ODBC Connection String

Driver={SQL Server}; Server=database_host; DATABASE=database_name; Uid=database_user; Pwd=database_user_password;

Driver={SQL Server}; Server=database_host; Database=database_name; Uid=database_user; Pwd=database_user_password;

2. OLE DB, OleDbConnection (.NET) Connection String

Provider=sqloledb; DATA SOURCE=database_host; Initial Catalog=database_name; USER ID=database_user; Password=database_user_password;

Provider=sqloledb; Data Source=database_host; Initial Catalog=database_name; User ID=database_user; Password=database_user_password;

3. SqlConnection (.NET) Connection String

DATA SOURCE=database_host; Initial Catalog=database_name; USER ID=database_user; Password=database_user_password;

Data Source=database_host; Initial Catalog=database_name; User ID=database_user; Password=database_user_password;

Feb 16, 2012Hoan Huynh
View Download List In Google Chrome And FirefoxFirefox How to enable Saved Tabs before closing
You Might Also Like:
  • Asp.net Load Connection String Dynamically For Different Environments
  • How To Track Website With Multiple Google Analytisc Accounts
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • MSSQL Split String Function
  • String To Lower Case In PHP, JavaScript And .Net (CSharp)
  • String To Upper Case In PHP, JavaScript And .Net (CSharp)
  • MSSQL Split Function returns table data
  • MSSQL Trim Function
  • C# Get List of databases in SQL Server
  • Replace String With NText Or Text Data Type In MS SQL Server
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

10 years ago SQL ServerODBC, OLEDB, OleDbConnection, SqlConnection240
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,542 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,885 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,736 views
JQuery Allow only numeric characters or only alphabet characters in textbox
15,059 views
C# Read Json From URL And Parse/Deserialize Json
11,789 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development