|
Knowledge
Base Article
Microsoft
Access Connection String Examples
Sample Database Connection Strings
If you
are planning on making a database call from the web the
first thing you will need to do is plan on making a "Database
Connection". Here are some sample database
connection strings to help you get started.
DSN Less connection for Access using Hsphere
<%
dim conn
set conn=server.CreateObject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=" & Server.MapPath("data/gallery.mdb;")&" Jet
OLEDB:Database Password=fyntic1976;"
%>
OLE DB Method for SQL
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename
"
%>
DSN Less connection for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\anydatabase.mdb"
%>
OLE DB Method for Access
<%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
SOURCE=c:\anydatabase.mdb"
%>
File DSN Connection Method for Access
<% set cnn = server.createobject("ADODB.Connection")
cnn.open "FILEDSN=AccessDSN"
%>
Back to Knowledge Base
|
