all groups > sql server notification services > august 2004 >
You're in the

sql server notification services

group:

Walkthru: Task 8 not working


Re: Walkthru: Task 8 not working Shyam Pather [MSFT]
8/17/2004 10:12:25 AM
sql server notification services:
Mert,
Most likely, you do not have SQLXML installed. This is a prerequisite for
installing NS.

You can download SQLXML 3.0 SP2 from
http://www.microsoft.com/downloads/details.aspx?familyid=4c8033a9-cf10-4e22-8004-477098a407ac&displaylang=en

Thanks
-shyam

Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

RE: Walkthru: Task 8 not working James Wu
8/17/2004 4:55:02 PM
Do you have CLR2.0 on you box? Are you running NS2.0 or NS Yukon? This error
can occur if you run NS2.0 file system watcher against CLR2.0 because of a
breaking change in the CLR.

The workaround is to configure NSService.exe so that it will only run
against CLR 1.1. To do so, you can add the following to NSService.config
under the product install directory:

<startup>
<supportedRuntime version="v1.1.4322"/>
</startup>

You may need to restart the NS service.

[quoted text, click to view]
Walkthru: Task 8 not working Mert Sakarya
8/17/2004 5:34:47 PM
Hi, I am trying to walk through the walkthroughs, but I got stuck at Task 8.

When I copy the "EventData.xml" to "Events" folder, it becomes an .err file
and at EventViewer, Notification Services fires the following error event
where the description is: "QueryInterface for interface
SqlXmlBulkLoad.ISQLXMLBulkLoad' failed."
IT'S NOT WORKING HEEELP!!!

Mert


The event log:

<NotificationServicesEvent>
<Description>
The FileSystemWatcher event provider failed to submit events.
</Description>
<Context>
<EventParameters>
<ProviderName>StockEP</ProviderName>
<EventFileName>C:\Program Files\Microsoft SQL Server Notification
Services\v2.0.3008.0\Samples\Stock\Test\Events\EventData.xml</EventFileName>
<EventClassName>StockEvents</EventClassName>
</EventParameters>

</Context>
<Description>
QueryInterface for interface 'SqlXmlBulkLoad.ISQLXMLBulkLoad' failed.
</Description>
<Instance>StockInstance</Instance>
<ApplicationName>Stock</ApplicationName>
<Component>Event collection</Component>
<Thread>12</Thread>
</NotificationServicesEvent>


Re: Walkthru: Task 8 not working Mert Sakarya
8/17/2004 9:08:39 PM
I have it. And it is the same.
I can run a script like;

Dim objBL
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
objBL.ConnectionString = "provider=SQLOLEDB;data
source=localhost;database=XXXX;integrated security=SSPI"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "schema.xsd", "data.xml"
set objBL=Nothing


[quoted text, click to view]

Re: Walkthru: Task 8 not working Mert Sakarya
8/19/2004 2:37:39 PM
This was the reason.
Now I know that, I must use "v1.1.4322" when developing for NS.

Thank you guys!

[quoted text, click to view]

AddThis Social Bookmark Button