Connection Strings - Revision history

Chrisw: /* MSSQL Connection String (ASP) */

2014-11-15T07:38:37Z

‎MSSQL Connection String (ASP)

Coryme: /* MySQL Connection String (ASP) */

2014-02-09T18:05:41Z

‎MySQL Connection String (ASP)

Coryme: /* Basic connection string */

2014-02-09T17:53:09Z

‎Basic connection string

Coryme: /* Basic connection string */

2014-02-09T17:52:47Z

‎Basic connection string

Davidd: Connection string examples.

2013-01-25T22:20:31Z

Connection string examples.

Briana at 16:19, 21 November 2012

2012-11-21T16:19:27Z

Briana: Briana moved page Connection Strings (MS Access) to Connection Strings without leaving a redirect

2012-11-21T16:16:17Z

Briana moved page Connection Strings (MS Access) to Connection Strings without leaving a redirect

Carlb: Created page with "==Connection String Examples== ===Using DSN-less method===

Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"

===Using DS..."

2012-11-21T10:09:45Z

Created page with "==Connection String Examples== ===Using DSN-less method=== <pre>Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"</pre> ===Using DS..."

New page

==Connection String Examples==

===Using DSN-less method===
<pre>Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"</pre>

===Using DSN===
<pre>
Conn.Open "MyDSN"

Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"
</pre>

[[Category:Databases-Access]]

@@ Line 108: / Line 108: @@
 ===MSSQL Connection String (ASP)===
 <pre>
-ConnStr="DRIVER={SQL
+ConnStr="DRIVER={SQLServer};SERVER=sql1.hostek.com;UID=db_username;PWD=db_password;DATABASE=db_name"
-Server};SERVER=sql1.hostek.com;UID=db_username;PWD=db_password;DATABASE=db_name"
 Conn.open ConnStr
 </pre>

@@ Line 82: / Line 82: @@
 ===MySQL Connection String (ASP)===
 <pre>
 Dim conDB
@@ Line 88: / Line 89: @@
 Set conDB = CreateObject("ADODB.Connection")
 '--You may need to use OPTION=3 instead of 16834
-conDB.Open "DRIVER=MySQL ODBC 3.51 Driver;SERVER=mysql10.hostek.com;OPTION=16834;USER=db_un;Password=db_pw;DATABASE=db_name"
+conDB.Open "DRIVER=MySQL ODBC 5.1 Driver;SERVER=mysql10.hostek.com;OPTION=16834;USER=db_un;Password=db_pw;DATABASE=db_name"
 '--Set the recordset
 Set rs = CreateObject("ADODB.Recordset")
 </pre>
 ===MSSQL Connection String (ASP)===

@@ Line 25: / Line 25: @@
 How to create connection object in your code using the above connection string:
-  System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient(System.Configuration.ConfigurationManager.ConnectionStrings["SQLServerConnection"].ConnectionString);
+  System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient(System.Configuration.ConfigurationManager.ConnectionStrings
 ====How to override default ASPNet Membership connection string====

@@ Line 16: / Line 16: @@
   <configuration>
     <connectionStrings>
-      <add name="SQLServerConnection" connectionString="Server=myServerName;Database=myDatabaseName;User Id=myUsername;Password=myPassword;" />
+      <add name="SQLServerConnection" connectionString="Server=myServerName;
     </connectionStrings>
   </configuration>
@@ Line 25: / Line 26: @@
 How to create connection object in your code using the above connection string:
   System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient(System.Configuration.ConfigurationManager.ConnectionStrings["SQLServerConnection"].ConnectionString);
 ====How to override default ASPNet Membership connection string====

@@ Line 1: / Line 1: @@
 __FORCETOC__
-==Access Database Connection String Examples==
+==ASP.Net==
-===Using DSN-less method===
+connection string examples for ASP.Net.
 <pre>Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\home\mysite.com\db\myfile.mdb;"</pre>
-===Using DSN===
+====Using DSN====
 <pre>
 Conn.Open "MyDSN"
@@ Line 16: / Line 80: @@
-==MySQL Connection String (ASP)==
+===MySQL Connection String (ASP)===
 <pre>
 Dim conDB
@@ Line 29: / Line 93: @@
-==MSSQL Connection String (ASP)==
+===MSSQL Connection String (ASP)===
 <pre>
 ConnStr="DRIVER={SQL

← Older revision	Revision as of 16:16, 21 November 2012
(No difference)