Various Connection Strings to Connect to an Access DB

If you want to call a database from within an asp page the that is to tell your asp page where your database is. Here are a few samples of database connection strings that could be used to help you connect to your database
I have also indicated where the code starts and finishes. I have used [] as the normal < > makes it impossible to see the code in the finished article as the page thinks it is real code so does not display it. If you want to use any of the code remember to change the square brackes [] to <>

OLE DB Method for SQL

'code start

[%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=dbname.mdb "
%]

'code finish

DSN-Less connection for Access

'code start

[%
set cnn = server.createobject("ADODB.Connection")
cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:yourdatabase.mdb"
%]

'code finish

OLE DB Method for Access

'code start

[%
set cnn = server.createobject("ADODB.Connection")
cnn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:yourdatabase.mdb"
%]

'code finish

File DSN Connection Method for Access

'code start

[% set cnn = server.createobject("ADODB.Connection")
cnn.open "FILEDSN=AccessDSN"
%]

'code finish

Don't forget when you download an application this info should be included. Remember to RENAME the database as others can download the application from where you did and see what the default name is if your page is live ie on the web and you have not renamed the database they could easily download your database and add or change information contained in the database. I had this happen a few years ago and all the links pointed to porn sites luckily I did not have many visitors in those days. So remember change the database name and possibly the directory that the database is in.

John Hutchison
If the code above does not display please see the orginal article. This article can be found at http://www.searchhuts.co.uk/portal/articles/activenews_view.asp?articleID=12

Life Style Blog
GPS Shop
Life Style Blog