Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Mon, 30 Jun 2008 10:44:18 -0700 (PDT),    group: microsoft.public.sqlserver.tools        back       


SQL Server 2005 Management Studio Error   
HI,

I keep getting a "Class Not Registered" error when I try and use the
Import Export wizard.  I've reinstalled several times but I'm still
having trouble.  The complete error message is below:

===================================

This wizard will close because it encountered the following error:
(Microsoft SQL Server)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

===================================

Class not registered

------------------------------
Program Location:

   at
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
   at
Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
wizardInputs)
   at
Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean
fSources, WizardInputs wizardInputs)
   at
Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
   at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
   at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
nextPage)
   at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object
sender, EventArgs e)
date: Mon, 30 Jun 2008 10:44:18 -0700 (PDT)   author:   unknown

Re: SQL Server 2005 Management Studio Error   
Hello Todd,

According to my experience, you have not applied SQL Server 2005 Service 
Pack 2 to your Client Tools.

You'll probably get rid of this error when you apply the SP2 to your Client 
Tools.

-- 
Ekrem Önsoy



 wrote in message 
news:d84c9913-29bb-403d-b645-257a059dfd62@z72g2000hsb.googlegroups.com...
> HI,
>
> I keep getting a "Class Not Registered" error when I try and use the
> Import Export wizard.  I've reinstalled several times but I'm still
> having trouble.  The complete error message is below:
>
> ===================================
>
> This wizard will close because it encountered the following error:
> (Microsoft SQL Server)
>
> ------------------------------
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476
>
> ===================================
>
> Class not registered
>
> ------------------------------
> Program Location:
>
>   at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
>   at
> Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
> wizardInputs)
>   at
> Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean
> fSources, WizardInputs wizardInputs)
>   at
> Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
>   at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
>   at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> nextPage)
>   at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object
> sender, EventArgs e)
>
date: Mon, 30 Jun 2008 21:36:05 +0300   author:   Ekrem Önsoy

Re: SQL Server 2005 Management Studio Error   
How exactly are you launching the wizard?  Are you doing so against a local
or a remote instance?  Using what authentication method?  What version is
the server where you are launching the wizard (you can see this in its top
node in Object Explorer)?  What is the version of your client tools (you can
see this in Help|About of SSMS)?






On 6/30/08 1:44 PM, in article
d84c9913-29bb-403d-b645-257a059dfd62@z72g2000hsb.googlegroups.com,
"todd.lowney@bankofamerica.com"  wrote:

> HI,
> 
> I keep getting a "Class Not Registered" error when I try and use the
> Import Export wizard.  I've reinstalled several times but I'm still
> having trouble.  The complete error message is below:
> 
> ===================================
> 
> This wizard will close because it encountered the following error:
> (Microsoft SQL Server)
> 
> ------------------------------
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399
> .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=Unca
> ughtException&LinkId=20476
> 
> ===================================
> 
> Class not registered
> 
> ------------------------------
> Program Location:
> 
>    at
> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
>    at
> Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs
> wizardInputs)
>    at
> Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean
> fSources, WizardInputs wizardInputs)
>    at
> Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
>    at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
>    at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> nextPage)
>    at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object
> sender, EventArgs e)
>
date: Mon, 30 Jun 2008 14:40:22 -0400   author:   Aaron Bertrand [SQL Server MVP] a

Re: SQL Server 2005 Management Studio Error   
On Jun 30, 2:40 pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> How exactly are you launching the wizard?  Are you doing so against a local
> or a remote instance?  Using what authentication method?  What version is
> the server where you are launching the wizard (you can see this in its top
> node in Object Explorer)?  What is the version of your client tools (you can
> see this in Help|About of SSMS)?
>
> On 6/30/08 1:44 PM, in article
> d84c9913-29bb-403d-b645-257a059df...@z72g2000hsb.googlegroups.com,
>
>
>
> "todd.low...@bankofamerica.com"  wrote:
> > HI,
>
> > I keep getting a "Class Not Registered" error when I try and use the
> > Import Export wizard.  I've reinstalled several times but I'm still
> > having trouble.  The complete error message is below:
>
> > ===================================
>
> > This wizard will close because it encountered the following error:
> > (Microsoft SQL Server)
>
> > ------------------------------
> > For help, click:
> >http://go.microsoft.com/fwlink?ProdName=Microsoft䤂﹉&ProdVer=...
> > .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=U­nca
> > ughtException&LinkId=20476
>
> > ===================================
>
> > Class not registered
>
> > ------------------------------
> > Program Location:
>
> >    at
> > Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfo­s()
> >    at
> > Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInp­uts
> > wizardInputs)
> >    at
> > Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean
> > fSources, WizardInputs wizardInputs)
> >    at
> > Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
> >    at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
> >    at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
> > nextPage)
> >    at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object
> > sender, EventArgs e)- Hide quoted text -
>
> - Show quoted text -


I have SP2 on my client tools.  The version is 3042.  I'm connecting
to a remote server using Windows Authentication.  The server version
is 3239.  I get the error for when I right click on a [database name]-
>Tasks->Import Data or Export Data.  I'm wondering if there is a
registry issue with my client tools install.
date: Mon, 30 Jun 2008 12:49:02 -0700 (PDT)   author:   unknown

Re: SQL Server 2005 Management Studio Error   
todd.lowney@bankofamerica.com wrote:
> On Jun 30, 2:40 pm, "Aaron Bertrand [SQL Server MVP]"
> <ten....@dnartreb.noraa> wrote:
>> How exactly are you launching the wizard?  Are you doing so against a local
>> or a remote instance?  Using what authentication method?  What version is
>> the server where you are launching the wizard (you can see this in its top
>> node in Object Explorer)?  What is the version of your client tools (you can
>> see this in Help|About of SSMS)?
>>
>> On 6/30/08 1:44 PM, in article
>> d84c9913-29bb-403d-b645-257a059df...@z72g2000hsb.googlegroups.com,
>>
>>
>>
>> "todd.low...@bankofamerica.com"  wrote:
>>> HI,
>>> I keep getting a "Class Not Registered" error when I try and use the
>>> Import Export wizard.  I've reinstalled several times but I'm still
>>> having trouble.  The complete error message is below:
>>> ===================================
>>> This wizard will close because it encountered the following error:
>>> (Microsoft SQL Server)
>>> ------------------------------
>>> For help, click:
>>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=...
>>> .00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=U­nca
>>> ughtException&LinkId=20476
>>> ===================================
>>> Class not registered
>>> ------------------------------
>>> Program Location:
>>>    at
>>> Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfo­s()
>>>    at
>>> Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInp­uts
>>> wizardInputs)
>>>    at
>>> Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean
>>> fSources, WizardInputs wizardInputs)
>>>    at
>>> Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
>>>    at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
>>>    at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage
>>> nextPage)
>>>    at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object
>>> sender, EventArgs e)- Hide quoted text -
>> - Show quoted text -
> 
> 
> I have SP2 on my client tools.  The version is 3042.  I'm connecting
> to a remote server using Windows Authentication.  The server version
> is 3239.  I get the error for when I right click on a [database name]-
>> Tasks->Import Data or Export Data.  I'm wondering if there is a
> registry issue with my client tools install.
> 

Hmmm, that means you have a lower version of the client tools accessing 
a higher version on the database.  Generally, I have seen this cause 
multiple problems.

Any chance you could upgrade your client tools to the same version that 
you are connecting to?  By the version number, I am guessing either CU6 
or CU7.
date: Mon, 30 Jun 2008 22:10:39 -0700   author:   Jeffrey Williams

Re: SQL Server 2005 Management Studio Error   
I tried upgrading my client tools, but I still get the same error.  I
did try to create a new SSIS package in BIDS and got a "Class Not
Registered" error message when I try to create a new OLEDB connection
manager.  It did not have any technical details with the error.  I've
tried reinstalling Mgmt Studio several times, and I've also tried
removing SSIS and installing it again.  I get the same error each
time.  Any more ideas ???  Thanks to all for trying!!
date: Mon, 7 Jul 2008 07:02:37 -0700 (PDT)   author:   Todd

Re: SQL Server 2005 Management Studio Error   
I resolved the problem :)  A co-worker suggested that I run the MDAC
Component Checker tool, which showed that I was missing the
oledb32.dll.  I looked in "C:\Program Files\Common Files\System\Ole
DB" and the DLL was there, so I registered it and the problem was
fixed!!  Thanks to everybody who tried to help.



MDAC Component Checker tool:
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
date: Wed, 9 Jul 2008 10:21:21 -0700 (PDT)   author:   Todd

Re: SQL Server 2005 Management Studio Error   
Thanks for the feedback, I'll document it in my web site.

-- 
Ekrem Önsoy



"Todd"  wrote in message 
news:f84be327-54d4-40d5-85bf-9e784273c942@r66g2000hsg.googlegroups.com...
>I resolved the problem :)  A co-worker suggested that I run the MDAC
> Component Checker tool, which showed that I was missing the
> oledb32.dll.  I looked in "C:\Program Files\Common Files\System\Ole
> DB" and the DLL was there, so I registered it and the problem was
> fixed!!  Thanks to everybody who tried to help.
>
>
>
> MDAC Component Checker tool:
> http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
>
date: Wed, 9 Jul 2008 20:56:17 +0300   author:   Ekrem Önsoy

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us