programmer2programmer.net
| | | Tips | | | Microsoft Certification | | | Project Idea NEW
| | | Connection Strings | | | Password Recovery | | | SQL Injection | | | Encryption & Decryption | | | | | | LIVE Academic Project | | | Project #1 - VB6, Access | | | Project #2 - VB.Net, SQL | | | Project #3 - ASP, Access | | | Project #4 - C#, SQL | | | Project #5 - VB6, SQL | | | Project #6 - Steganography | | | Download MBA Project | | |
2012 New Projects Ad
| | | | | | University Question Paper and Assignment | | | SMU - Question Paper | | | SMU - Assignment | | | SCDL - Assignment | | | | | | Interview Question Answer | | | General & HR Round | | | Visual Basic 6 | | | VB.Net & C# | | | ASP.Net | | | SQL Server | | |
Oracle and DBA NEW
| | | My SQL | | | |  | 100% Tested
Ready Academic IT Projects | | BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU | | readymadeproject.com |
|
|
|
Microsoft
SQL Server 2005 CE Connection Strings including ODBC, OLE DB and SQL
Client Connection Strings. |
|
|
|
|
|
Largest collection of
Connection Strings on
Internet for -
|
MS SQL Server 2005 Compact Edition (CE) Connection Strings
|
1.
SQL Server 2000
Connection Strings |
| 2. SQL Server 2005
Connection Strings |
| 3.
SQL Server 2005
CE Connection Strings |
|
MS SQL Server 2005 CE Connection Strings including
ODBC, OLE DB and SQL Client Connection Strings.
|
4.
Oracle Connection
Strings |
| 5.
MySQL Connection
Strings |
This is the complied and tested collection of
Microsoft SQL Server 2005 Compact Edition (CE) Connection strings
including
MS SQL Server 2005 CE ODBC Standard Security Connection
String, Trusted connection, OLE DB, OleDbConnection
(.NET) Standard Security Connection Strings, Trusted connection String,
Connecting to an SQL Server instance , Connect via
an IP address, SqlConnection (.NET), Standard
Security, Trusted Connection String |
6.
Postgree SQL
Connection Strings |
| 7.
MS Excel
Connection Strings |
| 8.
MS Excel 2007
Connection Strings |
| 9.
Text/CSV File
Connection Strings |
| 10.MS Access Connection
Strings |
| 11.MS Access 2007
Connection Strings |
| 12.VisualFoxPro/FoxPro 2.6 CS |
| 13.DBF Connection
Strings |
| |
|
|
|
|
|
| |
ODBC Connection
String for SQL Server 2005 CE |
| |
|
Standard Security |
| |
|
|
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data
Source=myPath\myData.sdf;
|
| |
|
|
' VB.NET
Imports System.Data.Odbc
...
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = _
"Driver={SQL Server};" & _
"Server=MySQLServerName;" & _
"Database=MyDatabaseName;" & _
"Uid=MyUsername;" & _
"Pwd=MyPassword"
oODBCConnection = New
Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
|
| |
|
Specifying the
maximum database size and buffer size |
| |
|
|
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data
Source=myPath\myData.sdf;SSCE:Max Database
Size=256;SSCE:Max Buffer Size=1024;
|
| |
|
|
| |
|
Supplying the
database password |
| |
|
|
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data
Source=myPath\myData.sdf; SSCE:Database
Password='myPassword';
|
| |
|
|
|
| |
SqlCeConnection (.NET) Connection String for SQL Server 2005
CE |
| |
|
Standard Security |
| |
|
|
Data Source=MyData.sdf;Persist Security
Info=False;
|
| |
|
|
' VB.NET
Imports System.Data.OleDb
...
Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New
OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
|
| |
|
How to specify the
location of the SDF file |
| |
|
|
Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)
+ "\\MyData.sdf;Persist Security Info=False;
|
| |
|
|
|
| |
|
Encryption enabled |
| |
|
|
Data Source=MyData.sdf;Encrypt Database=True;Password=myPassword;File
Mode=shared read;Persist Security Info=False;
|
| |
|
|
|
| |
|
|
|
|
|
|
|
|
Connection Strings
Main |
|
|
|
(C) Atanu Maity, 2006-2012
|
