OLE DB Method for SQL
<%
set cnn = servercreateobject(ADODBConnection)
cnnopen PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename
%>
DSN Less connection for Access
<%
set cnn = servercreateobject(ADODBConnection)
cnnopen DRIVER={Microsoft Access Driver (*mdb)};DBQ=c:\anydatabasemdb
%>
OLE DB Method for Access
<%
set cnn = servercreateobject(ADODBConnection)
cnnopen PROVIDER=MICROSOFTJETOLEDB;DATA SOURCE=c:\anydatabasemdb
%>
File DSN Connection Method for Access
<% set cnn = servercreateobject(ADODBConnection)
cnnopen FILEDSN=AccessDSN
%>
