PERFMON SCRIPTS not working for SQL2005

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  August 10, 2006 at 10:32 am

  #191791

  Hello all,

  I have installed several test 2005 servers and want to enable perfmon on them...I am using the scripts in this article:

  http://www.sql-server-performance.com/ss_performance_monitoring.asp

  When I execute the INSERT statement, I receive this error :

  12:14:22.578DBMS -- Error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.(42000,7403), Batch 3 Line 3

  What EXTRA steps must I perform? I also tried the LINKED-SERVER stuff but I am still getting the SAME EXACT error as stated above.

  Thanks,

  Michelle

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  August 10, 2006 at 10:59 am

  #654381

  I found a resolution that worked just fine for me:

  http://www.huddledmasses.org/jaykul/importing-csv-files-to-ms-sql-2005/

  ...Michelle