Database Connectionstrings

Do you have a hard time remembering database connection strings?
You are not alone!  Here is an easy-to-use reference of connection
strings for numerous databases and data stores.





select your database

 MS SQL Server
 MS SQL Express
 MS Access
 Oracle
 IBM DB2
 MySql
 Sybase
 Interbase
 Informix
 Excel
 Text
 dBase Dbf
 Visual FoxPro

  Code samples are in C#. You must provide the values in red


Microsoft SQL Server

Show code

// ODBC DSN

Show code

// ODBC -- Standard Connection

Show code

// ODBC -- Trusted Connection

Show code

// OleDb -- Standard Connection

Show code

// OleDb -- Trusted Connection

Show code

// OleDb -- via IP Address

Show code

// .NET DataProvider -- Standard Connection

Show code

// .NET DataProvider -- Trusted Connection

Show code

// .NET DataProvider -- via IP Address

Microsoft Sql Express

Show code

// .NET Data Provider -- Default Relative Path
// Standard Connection

Show code

// .NET Data Provider -- Default Relative Path
// Trusted Connection

Show code

// .NET Data Provider -- Custom Relative Path
// Standard Connection

Show code

// .NET Data Provider -- Custom Relative Path
// Trusted Connection

Show code

// .NET Data Provider -- Absolute Path
// Standard Connection

Show code

// .NET Data Provider -- Absolute Path
// Trusted Connection

Microsoft Access

Show code

// ODBC DSN

Show code

// ODBC -- Standard Security

Show code

// ODBC -- Workgroup (System Database)

Show code

// ODBC -- Exclusive Use

Show code

// OleDb with MS Jet -- Standard Security

Show code

// OleDb with MS Jet -- Workgroup (System Database)

Show code

// OleDb with MS Jet -- With Password

Oracle

Show code

// ODBC DSN

Show code

// ODBC -- New Microsoft Driver

Show code

// ODBC -- Old Microsoft Driver

Show code

// ODBC -- Oracle Driver

Show code

// OleDb -- Microsoft Driver

Show code

// OleDb -- Oracle Driver -- Standard Connection

Show code

// OleDb -- Oracle Driver -- Trusted Connection

Show code

// .NET DataProvider from Microsoft
// -- Standard Connection

Show code

// .NET DataProvider from Microsoft
// -- Trusted Connection

Show code

// .NET DataProvider from Oracle
// -- Standard Connection

Show code

// .NET DataProvider from Oracle
// -- Trusted Connection

IBM DB2

Show code

// ODBC DSN

Show code

// ODBC without DSN

Show code

// OleDb -- Microsoft Driver

Show code

// OleDb -- IBM Driver

Show code

// .NET DataProvider from IBM

MySql

Show code

// ODBC DSN

Show code

// ODBC -- MyODBC Driver -- local database

Show code

// ODBC -- MyODBC Driver -- remote database

Show code

// ODBC -- MySQL ODBC 3.51 Driver

Show code

// OleDb

Show code

// .NET DataProvider from CoreLab

Sybase

Show code

// ODBC DSN

Show code

// ODBC -- Sybase System 12 (12.5) ODBC Driver

Show code

// ODBC -- Sybase System 11 ODBC Driver

Show code

// ODBC -- Intersolv 3.10 ODBC Driver

Show code

// ODBC -- SQL Anywhere

Show code

// OleDb -- Sybase Adaptive Server Enterprise (ASE)

Show code

// .NET DataProvider from Sybase

Interbase

Show code

// ODBC DSN

Show code

// ODBC -- EasySoft ODBC Driver -- local machine

Show code

// ODBC -- EasySoft ODBC Driver -- remote machine

Show code

// ODBC -- Intersolv ODBC Driver -- local machine

Show code

// ODBC -- Intersolv ODBC Driver -- remote machine

Informix

Show code

// ODBC DSN -- INFORMIX 3.30 ODBC Driver

Show code

// ODBC without DSN -- INFORMIX 3.30 ODBC Driver

Show code

// ODBC Informix-CLI 2.5 ODBC Driver

Show code

// OleDb -- IBM Informix OleDb Provider

Excel

Show code

// ODBC DSN

Show code

// ODBC without DSN

Show code

// OleDb with MS Jet

Text

Show code

// ODBC DSN

Show code

// ODBC without DSN

Show code

// OleDb with MS Jet

dBase Dbf

Show code

// ODBC DSN

Show code

// ODBC without DSN

Visual FoxPro

Show code

// ODBC DSN

Show code

// ODBC without DSN -- Database container (dbc)

Show code

// ODBC without DSN -- Free table directory

Show code

// OleDb -- Database container (dbc)

Show code

// OleDb -- Free table directory




If you like to comment on any of the connection strings please contact us.





   Better Code 
   Better Career 
   Better Lifestyle 

.NET
Design Pattern
Framework 4.5


.NET Design Pattern Framework 4.5
C# and VB

     Here's what you get:
  • Gang of Four Patterns
  • Head First Patterns
  • Enterprise Patterns
  • Multi-Tier Patterns

  • Repository Pattern
  • Unit-of-Work Pattern
  • Active Record Pattern
  • CQRS Pattern

  • Model View Controller
  • Model View Presenter
  • Model View ViewModel

  • SparkTM RAD Platform
  • Art Shop MVC application
  • More...

Upgrade your .NET Design Pattern Skills Upgrade your .NET skills

Click here for details

-- Instant Access --
Instant Download