| NOTE: This site is no longer maintained. Upgrade to ipMonitor v9 here. |
To access a Microsoft SQL Server Database, you do not need to download and install an additional OLE DB Provider.
| "The Microsoft SQL Server™ 2000 includes a native Microsoft OLE DB Provider for SQL Server used by OLE DB applications to access the data in SQL Server. In SQL Server version 6.5 and earlier, ADO applications had to use the OLE DB Provider for ODBC layered over the Microsoft SQL Server ODBC driver. Although ADO applications can still use the OLE DB Provider for ODBC with the SQL Server ODBC driver, it is more efficient to only use the OLE DB Provider for SQL Server." |
More information about Microsoft SQL Server can be found at Microsoft Corporation:
http://msdn2.microsoft.com/en-us/library/ms950403.aspx
However, please note that Microsoft Data Access Components (MDAC) version 2.6 or later is required to connect to Microsoft SQL Server.
To check the MDAC version used on the system, use the MDAC Component Checker Utility available from Microsoft:
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en.
If needed, download the current version of MDAC from Microsoft:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
For additional information regarding the ADO and ADO - QA Monitors, refer to the Monitors section of ipMonitor's Context-Sensitive Help system, and then select Monitor Types. The Context-Sensitive Help can be accessed by clicking the Help link located in the top right corner of ipMonitor's Administration web interface.
For information on other features and concepts related to those discussed in this article, refer to the following ipMonitor resources:
< Back
Last Updated: March 16, 2007 | What did you think of this topic?