|
|
You're in the
sql server notification services
group:Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass'
sql server notification services:
I installed Notification Services 2000 and trying to get an example app running that came with the book "The Rational Guide to SQL Server Notification Services". When I drop an XML event file into the watched directory, it immediatley changes to a ".err" file. The Event Log shows this error: <NotificationServicesEvent> <Description> The FileSystemWatcher event provider failed to submit events. </Description> <Context> <EventParameters> <ProviderName>FswRecallEP</ProviderName> <EventFileName>C:\SQLNS\ABC\Events\TestEvent.xml</EventFileName> <EventClassName>SafetyRecall</EventClassName> </EventParameters> </Context> <Description> Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). </Description> <Instance>ABCOwners</Instance> <ApplicationName>Recalls</ApplicationName> <Component>Event collection</Component> <Thread>16</Thread> </NotificationServicesEvent> I thought I found the answer when I came across this forum message: Notification Services in SQL 2000 requires the .NET Framework 1.1. If you have version 2.0 (only - without a side-by-side copy of version 1.1), you will see this problem. The reason is that one of the methods we call when loading the XML event loading components has been made obsolete in the 2.0 ..NET Frameworks. If you want to go with the .NET Frameworks 2.0, you should use the version of Notification Services in SQL Server 2005 - that version is designed to work on .NET 2.0. I had only the .NET Frameworks 2.0, installed so I installed .NET Frameworks 1.1 and re-installed SQLXML 3.0 but I still get the same error. Any help/suggestions would be appreciated. Thanks in advance! gary
Hi Gary -
First off, thanks for buying the book. I hope you find it worthwhile! As you've already discovered, SQLNS v2.0 SP1 works with v1.1 of the ..net framework and SQL Server 2000. SQLNS 2005 uses v2.0 of the .net framework and SQL Server 2005. What version(s) and editions of SQL Server do you have installed? And what version(s) of the .net framework do you have installed? Thanks! Joe -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) [quoted text, click to view] On Wed, 1 Feb 2006 15:01:14 -0500, "g" <gfix@ohiogratings.com> wrote:
>Hi, >I installed Notification Services 2000 and trying to get an example app >running that came with the book "The Rational Guide to SQL Server >Notification Services". >When I drop an XML event file into the watched directory, it immediatley >changes to a ".err" file. >The Event Log shows this error: ><NotificationServicesEvent> > > <Description> > > The FileSystemWatcher event provider failed >to submit events. > > </Description> > > <Context> > ><EventParameters> > > <ProviderName>FswRecallEP</ProviderName> > > <EventFileName>C:\SQLNS\ABC\Events\TestEvent.xml</EventFileName> > > <EventClassName>SafetyRecall</EventClassName> > ></EventParameters> > > </Context> > > <Description> > > Unable to cast COM object of type >'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type >'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the >QueryInterface call on the COM component for the interface with IID >'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: >No such interface supported (Exception from HRESULT: 0x80004002 >(E_NOINTERFACE)). > > </Description> > > <Instance>ABCOwners</Instance> > > <ApplicationName>Recalls</ApplicationName> > > <Component>Event collection</Component> > > <Thread>16</Thread> > ></NotificationServicesEvent> > >I thought I found the answer when I came across this forum message: > >Notification Services in SQL 2000 requires the .NET Framework 1.1. If you >have version 2.0 (only - without a side-by-side copy of version 1.1), you >will see this problem. The reason is that one of the methods we call when >loading the XML event loading components has been made obsolete in the 2.0 >.NET Frameworks. > >If you want to go with the .NET Frameworks 2.0, you should use the version >of Notification Services in SQL Server 2005 - that version is designed to >work on .NET 2.0. > >I had only the .NET Frameworks 2.0, installed so I installed .NET Frameworks >1.1 and re-installed SQLXML 3.0 but I still get the same error. > >Any help/suggestions would be appreciated. > >Thanks in advance! > >gary
Hi Joe,
I have SQL Server Developer Edition Version 2000 SP3 on Windos XP Pro Version 2002 SP2 with .NET Framework 1.1 and 2.0 installed. thanks! gary [quoted text, click to view] "Joe Webb" <joew@webbtechsolutions.com> wrote in message news:19ahu1pgqod58398hu93500s1qeqknohi3@4ax.com... > Hi Gary - > > First off, thanks for buying the book. I hope you find it worthwhile! > > As you've already discovered, SQLNS v2.0 SP1 works with v1.1 of the > .net framework and SQL Server 2000. SQLNS 2005 uses v2.0 of the .net > framework and SQL Server 2005. > > What version(s) and editions of SQL Server do you have installed? And > what version(s) of the .net framework do you have installed? > > Thanks! > > Joe > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > ~~~ > Get up to speed quickly with SQLNS > http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 > > I support PASS, the Professional Association for SQL Server. > (www.sqlpass.org) > > > > > On Wed, 1 Feb 2006 15:01:14 -0500, "g" <gfix@ohiogratings.com> wrote: > >>Hi, >>I installed Notification Services 2000 and trying to get an example app >>running that came with the book "The Rational Guide to SQL Server >>Notification Services". >>When I drop an XML event file into the watched directory, it immediatley >>changes to a ".err" file. >>The Event Log shows this error: >><NotificationServicesEvent> >> >> <Description> >> >> The FileSystemWatcher event provider >> failed >>to submit events. >> >> </Description> >> >> <Context> >> >><EventParameters> >> >> <ProviderName>FswRecallEP</ProviderName> >> >> >> <EventFileName>C:\SQLNS\ABC\Events\TestEvent.xml</EventFileName> >> >> <EventClassName>SafetyRecall</EventClassName> >> >></EventParameters> >> >> </Context> >> >> <Description> >> >> Unable to cast COM object of type >>'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type >>'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the >>QueryInterface call on the COM component for the interface with IID >>'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following >>error: >>No such interface supported (Exception from HRESULT: 0x80004002 >>(E_NOINTERFACE)). >> >> </Description> >> >> <Instance>ABCOwners</Instance> >> >> <ApplicationName>Recalls</ApplicationName> >> >> <Component>Event collection</Component> >> >> <Thread>16</Thread> >> >></NotificationServicesEvent> >> >>I thought I found the answer when I came across this forum message: >> >>Notification Services in SQL 2000 requires the .NET Framework 1.1. If you >>have version 2.0 (only - without a side-by-side copy of version 1.1), you >>will see this problem. The reason is that one of the methods we call when >>loading the XML event loading components has been made obsolete in the 2.0 >>.NET Frameworks. >> >>If you want to go with the .NET Frameworks 2.0, you should use the version >>of Notification Services in SQL Server 2005 - that version is designed to >>work on .NET 2.0. >> >>I had only the .NET Frameworks 2.0, installed so I installed .NET >>Frameworks >>1.1 and re-installed SQLXML 3.0 but I still get the same error. >> >>Any help/suggestions would be appreciated. >> >>Thanks in advance! >> >>gary >>
Haven't seen this before.
Have you doublechecked the other v2.0 requirements such as MDAC & SQLXML? See "Installing Notification Services" in BOL. HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) [quoted text, click to view] On Tue, 7 Feb 2006 11:24:39 -0500, "g" <gfix@ohiogratings.com> wrote:
>Hi Joe, >I have SQL Server Developer Edition Version 2000 SP3 on Windos XP Pro >Version 2002 SP2 >with .NET Framework 1.1 and 2.0 installed. >thanks! >gary > >"Joe Webb" <joew@webbtechsolutions.com> wrote in message >news:19ahu1pgqod58398hu93500s1qeqknohi3@4ax.com... >> Hi Gary - >> >> First off, thanks for buying the book. I hope you find it worthwhile! >> >> As you've already discovered, SQLNS v2.0 SP1 works with v1.1 of the >> .net framework and SQL Server 2000. SQLNS 2005 uses v2.0 of the .net >> framework and SQL Server 2005. >> >> What version(s) and editions of SQL Server do you have installed? And >> what version(s) of the .net framework do you have installed? >> >> Thanks! >> >> Joe >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com >> >> >> ~~~ >> Get up to speed quickly with SQLNS >> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 >> >> I support PASS, the Professional Association for SQL Server. >> (www.sqlpass.org) >> >> >> >> >> On Wed, 1 Feb 2006 15:01:14 -0500, "g" <gfix@ohiogratings.com> wrote: >> >>>Hi, >>>I installed Notification Services 2000 and trying to get an example app >>>running that came with the book "The Rational Guide to SQL Server >>>Notification Services". >>>When I drop an XML event file into the watched directory, it immediatley >>>changes to a ".err" file. >>>The Event Log shows this error: >>><NotificationServicesEvent> >>> >>> <Description> >>> >>> The FileSystemWatcher event provider >>> failed >>>to submit events. >>> >>> </Description> >>> >>> <Context> >>> >>><EventParameters> >>> >>> <ProviderName>FswRecallEP</ProviderName> >>> >>> >>> <EventFileName>C:\SQLNS\ABC\Events\TestEvent.xml</EventFileName> >>> >>> <EventClassName>SafetyRecall</EventClassName> >>> >>></EventParameters> >>> >>> </Context> >>> >>> <Description> >>> >>> Unable to cast COM object of type >>>'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type >>>'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the >>>QueryInterface call on the COM component for the interface with IID >>>'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following >>>error: >>>No such interface supported (Exception from HRESULT: 0x80004002 >>>(E_NOINTERFACE)). >>> >>> </Description> >>> >>> <Instance>ABCOwners</Instance> >>> >>> <ApplicationName>Recalls</ApplicationName> >>> >>> <Component>Event collection</Component> >>> >>> <Thread>16</Thread> >>> >>></NotificationServicesEvent> >>> >>>I thought I found the answer when I came across this forum message: >>> >>>Notification Services in SQL 2000 requires the .NET Framework 1.1. If you >>>have version 2.0 (only - without a side-by-side copy of version 1.1), you >>>will see this problem. The reason is that one of the methods we call when >>>loading the XML event loading components has been made obsolete in the 2.0 >>>.NET Frameworks. >>> >>>If you want to go with the .NET Frameworks 2.0, you should use the version >>>of Notification Services in SQL Server 2005 - that version is designed to >>>work on .NET 2.0. >>> >>>I had only the .NET Frameworks 2.0, installed so I installed .NET >>>Frameworks >>>1.1 and re-installed SQLXML 3.0 but I still get the same error. >>> >>>Any help/suggestions would be appreciated. >>> >>>Thanks in advance! >>> >>>gary >>>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |