Connect to MS access database

Script version:1.0
Language:ASP
Rating:
7.1 (7 votes cast)
Category:Database
Description:ASP code to connect to MS access database.
Instructions:Change the path to the database in the code eg if the database is in a folder called /db/ then the code should read :

connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mapPath("/") & "\db\databasename.mdb"


IMPORTANT: always remember to close your asp database connection object at the first oportunity and do not use a response.redirect command in the code before the database is closed. This will leave connection objects open and using up server memory. If your server runs out of memory, then your website will no longer parse asp files and only html files and images will work.

Code:




Comments



myke black
www.mykeblack.com
16 September 2008 13:17:51
there are alternatives to the ADODB connection driver, for example there are ODBC connecitons that use the older ADO objects which use a different syntax. This script is also for DSNless connections. There are numerous discussions as to whether DSN connections are more efficient to DSNless connection.

Name: *
Email: (not shown on website)
Website:
Rate this script:
1 2 3 4 5 6 7 8 9 10
worse better
Comment: *
CAPTCHA Image
Change Image
Write the characters in the image above


* = required field

Related Scripts:

Tags

No tags defined for this script. [View tag cloud]

Back to main scripts page








Tag Cloud    Submit a script


Latest Scripts Added

jQuery image swap on mouseover (jQuery)
04 January 2012
This simple bit of code allows you to quickly create image rollovers. The code was modified from a version by Sam Colletts on http://webdevel.blogspot.com/2008/04/rollover-images-with-jquery.html ...

replace XML characters in a string using ASP.Net (ASP.Net)
12 December 2011
Sometimes you need to insert a string into an xml document. Before doing this, you need to ensure that your string does not contain any special xml characters. It is possible to use a CDATA section ...

How to remove title tag in ASP.Net (ASP.Net)
14 October 2011
This is not really a script, but a little trick that you can use to remove the title tag in ASP.net. In ASP.net, when the head tag is rendered, the title tag is automatically added. One of the real ...

ASP sort numerical array (ASP)
12 September 2011
This code is similar to the sort array script which sorts an array alphabetical, however it also sorts arrays based on numberical ordering, for example: dim numbers(4) numbers(0) = ...

Force file download in ASP.Net / c# (ASP.Net)
02 September 2011
this script allows you to force browsers to display a file save dialogue for any file type. It contains a string of allowed file types so users cannot change the querystring to downoad your ...