Difference between revisions of "Connection Strings"
From Hostek.com Wiki
(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...") |
m (Briana moved page Connection Strings (MS Access) to Connection Strings without leaving a redirect) |
(No difference)
| |
Revision as of 16:16, 21 November 2012
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 DSN
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;"