- Classic ASP file upload limit of 200kb in IIS 7L
- Find Column with Lower Case Text
- 0x8007232B DNS Name Does Not Exist Error on Windows Activation
- How to update a column with incrementing numbers
- How to get top N rows for each group?
- How to put a column into a delimited form
- How to export results of a stored procedure to a txt file
- Parsing delimited words from a column
- How to get N-th max value
- How to get a random row from a table
Home :: Tips & Tricks :: Active Server Pages
Use Access 2000 as your ADO Provider in ASP
Databases provide the key between boring, static pages and exciting, dynamic ones. When you move an ASP to the production server, you'll no doubt want to use a robust database like SQLServer to handle the large amount of data your Web sites will require.
However, for development, you may not always need such a heavy-duty program. Enter Microsoft Access. This tiny whiz of a database provides a great way to test your data-driven pages during development. If you've just begun to use Access 2000, though, you may have wondered how to make it your ASP ADO Provider. Fortunately, it's as easy as changing a few digits. Previously, with Access 97, the Provider string looked as follows:
strConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & Server.MapPath("myDB.mdb")
To utilize Access 2000, simply change this string to
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("myDB.mdb")
Source: Mike D. Jones