Re-Installing ADO components

[OceanDesigner]

Following some advice I received in this forum a few weeks ago, I have coded the following set of lines:

<!--#include file="includes/connect.inc" -->
<%
  Set oPkg = Server.CreateObject("DTS.Package")
%>
<!--#include file="includes/disconnect.inc" -->
[\CODE]

I get an error that I tracked down to the following MSN article:  [URL unfurl="true"]http://support.microsoft.com/default.aspx?scid=kb;en-us;315453#appliesto.[/URL]  It basically tells me that ADO components are either not installed, or not installed correctly, and further tells me to re-install the database components.  I can't figure out how to do that, and I can't find instructions on MSN, SQL Server BOL or IIS help.  Do I have to reinstall IIS altogether, or can I somehow just deal with the database components?

 

[MoLaker]

Try reinstalling MDAC or updating MDAC - depending upon what version of Windows you have, that might resolve the problem. Usually, one would just update to the latest version, but with some earlier versions of O/S and applications, it might not be appropriate. It's probably best to reinstall the level you have unless you have reason to upgrade.

Component checker to determine what MDAC version you have

http://support.microsoft.com/default.aspx?scid=kb;EN-US;301202

MDAC download page

http://msdn.microsoft.com/data/downloads/updates/default.aspx