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" %>
