Omnis Network, LLC Hosting over 200,000 Accounts since 1999 Live Support 877.393.Host

Home Web Hosting Domains Design Services Affiliates Contact Us
Search Results
Title:
Access DSN Connections
Article:
Without DSN
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:mydatabase.mdb"
%> 
OLE DB
<%
Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:mydatabase.mdb"
%> 
File DSN
<% Set Cnn = Server.CreateObject("ADODB.Connection")
Cnn.open "FILEDSN=ADSN"
%> 
With DSN and no User ID/Password
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%> 
With DSN and User ID/Password
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname","username","password"
%> 
Without DSN, using a physical path as a reference
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=c:mydatabase.mdb"
Conn.Open DSNtest
%> 
Without DSN, using Server.MapPath
NOTE: Server.MapPath is the path from the Web server root. By default, this is C:InetpubWwwroot.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest & "DBQ=" & Server.MapPath("/databases/mydatabase.mdb")
Conn.Open DSNtest
%> 

References:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300382
Keywords:

access dsn connection

Contact Omnis Network Manage Your Account
    https://manage.omnis.com

Technical Support
    Tech Support Contact Form
    support@omnis.com

Call Us Toll-Free
    1-877-393-HOST (4678)

Reach Us By Mail
    3655 Torrance Blvd Suite 230
    Torrance CA, 90503
Browse Knowledge Base
Search Knowledge Base Select the search type:
All Articles
How To
Problem
Bug
FAQ
Keywords:

Any word may be in article
All words must be in article

  HACKER SAFE certified sites prevent over 99.9% of hacker crime.       We accept Visa, Mastercard, Discover, AMEX, Check and Paypal