Creating Access Database Connection String
Published on 3/7/2005 by Site Editor|
Vote this tutorial:
|
More articles in ASP
This tutorial contains a better and clean ASP code to create a sample connection string to an Access database. You may use this sample code in your applications.
First we must modify local id value to display custom date time format.
<%
session.lcid = 2057
%>
session.lcid = 2057
%>
For more information on LOCAL ID values visit this article. We have used british value. Now we will examine and create a custom database string by one by.
<%
1. Const strConPathFolderDb = "databases/"
2. Const strConDatabaseSt = "activeNews"
3. strConMapPath = Server.MapPath(strConPathFolderDb & strConDatabaseSt & ".mdb")
4. strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strConMapPath
%>
1. Const strConPathFolderDb = "databases/"
2. Const strConDatabaseSt = "activeNews"
3. strConMapPath = Server.MapPath(strConPathFolderDb & strConDatabaseSt & ".mdb")
4. strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strConMapPath
%>
1. First we are modifying which folder we will use.
2. Our database name
3. This joins database folder and database name in one string
4. Now strConnectionString variable is your connection string.
Very simple and clean coding.
Have a nice coding ! Comments:
no comments submitted
Latest Posts
- Create and retrieve cookies
- Easy Error Handling in C#
- Filtering results from database
- Filling Data into Select List
- Working with Array Remove An Item
- Custom Paging in ASP Fast And Easy
- Display Top N records from MS Access
- Using GetRows To Get All Records From Table
- VBScript Functions The Len Function
- Free User Registration Form
- Copying Folders using File System Object
- ArrayList object usage with example
- Using SUM Function in An SQL Statement
- Compacting an Access database from ASP code
- Database Driven Login Script
- Methods of Session Object
- Simple XMLRSS Parser Part-II
- Selecting random record from database
- Image downloading from remote servers in ASP
- How to Encrypt String Using MD5


