Top ASP 101 Stories An Overview of ASP.NET Connections, Commands, And Procedures What is ASP? QUICK TIP: On Error Don't Resume Next Show All Tips >>  ASP 101 Updates

Quick Tips

Keeping your ADO components up to date may seem like a trivial thing, but it's really not. In addition to new features that can make your coding easier, the latest drivers almost always contain bug fixes and performance enhancements over the previous version.

While you may not want to be on the "bleeding" edge and update your MDAC stack the day the new versions come out, you should try and stay somewhat current.

You can get the latest version from Microsoft's Universal Data Access webpage. If you're not sure what version you have, this little ASP script can help you find out.

<%@ Language=VBScript %>
<%
Option Explicit
Dim cnnVersionTest
Set cnnVersionTest = Server.CreateObject("ADODB.Connection")
Response.Write "ADO Version: " & cnnVersionTest.Version
Set cnnVersionTest = Nothing
%>

For more detail on your installed drivers or to troubleshoot your installation, you might want to download Microsoft's Component Checker Tool.

If you have a tip you would like to submit, please send it to: webmaster@asp101.com.