Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Stock Sample, task 5

 
   Database Help (Home) -> Notification Services RSS
Next:  Adding Subscriptions using SP instead of API?  
Author Message
Anthony Small

External


Since: Apr 08, 2004
Posts: 32



(Msg. 1) Posted: Fri Apr 09, 2004 2:29 am
Post subject: Stock Sample, task 5
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Does anyone have any idea why the error below would occur?

"ODBC: Msg 0, Level 16, State 1
Cannot load the DLL
Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the
DLLs it references.
Reason: 126(error not found)."

It happens when I run task 5 of the stock sample.

Specifically when I run
EXEC NSPrepareRuleFiring 0, 0
EXEC NSExecuteRuleFiring 0, 0

Thanks in advance

Tony S.

 >> Stay informed about: Stock Sample, task 5 
Back to top
Login to vote
Anthony Small

External


Since: Apr 08, 2004
Posts: 32



(Msg. 2) Posted: Fri Apr 09, 2004 3:08 am
Post subject: Re: Stock Sample, task 5 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Forgive me, the instance service was not started

Tony S.

"Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
news:eSjMljbHEHA.2556@TK2MSFTNGP12.phx.gbl...
 > Does anyone have any idea why the error below would occur?
 >
 > "ODBC: Msg 0, Level 16, State 1
 > Cannot load the DLL
 > Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of the
 > DLLs it references.
 > Reason: 126(error not found)."
 >
 > It happens when I run task 5 of the stock sample.
 >
 > Specifically when I run
 > EXEC NSPrepareRuleFiring 0, 0
 > EXEC NSExecuteRuleFiring 0, 0
 >
 > Thanks in advance
 >
 > Tony S.
 >
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Stock Sample, task 5 
Back to top
Login to vote
Anthony Small

External


Since: Apr 08, 2004
Posts: 32



(Msg. 3) Posted: Fri Apr 09, 2004 3:21 am
Post subject: Re: Stock Sample, task 5 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Sorry, my original problem still stands. The service is running and the
problem still persists.
I'd appreciate any help if anyone knows about the original odbc dll error
Thanks in advance.

Tony S.

"Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
news:%23cGKd5bHEHA.2376@TK2MSFTNGP12.phx.gbl...
 > Forgive me, the instance service was not started
 >
 > Tony S.
 >
 > "Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
 > news:eSjMljbHEHA.2556@TK2MSFTNGP12.phx.gbl...
  > > Does anyone have any idea why the error below would occur?
  > >
  > > "ODBC: Msg 0, Level 16, State 1
  > > Cannot load the DLL
  > > Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of
the
  > > DLLs it references.
  > > Reason: 126(error not found)."
  > >
  > > It happens when I run task 5 of the stock sample.
  > >
  > > Specifically when I run
  > > EXEC NSPrepareRuleFiring 0, 0
  > > EXEC NSExecuteRuleFiring 0, 0
  > >
  > > Thanks in advance
  > >
  > > Tony S.
  > >
  > >
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Stock Sample, task 5 
Back to top
Login to vote
Anthony Small

External


Since: Apr 08, 2004
Posts: 32



(Msg. 4) Posted: Sun Apr 11, 2004 11:24 am
Post subject: Re: Stock Sample, task 5 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm talking to myself here but....
I resolved this problem by un-registering and re-registering the extended
stored proc pointing it to the correct directory used by my sql
installation. Some time ago (I had forgotten) that I changed the SQL
default instances and the XP install script was pointing to the path of the
original instance. The new NS XP settings were not picked up even though I
had recently reinstalled NS. The installation process keeps the previous
files it seems.

Tony S.

"Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
news:OkK81AcHEHA.1608@TK2MSFTNGP11.phx.gbl...
 > Sorry, my original problem still stands. The service is running and the
 > problem still persists.
 > I'd appreciate any help if anyone knows about the original odbc dll error
 > Thanks in advance.
 >
 > Tony S.
 >
 > "Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
 > news:%23cGKd5bHEHA.2376@TK2MSFTNGP12.phx.gbl...
  > > Forgive me, the instance service was not started
  > >
  > > Tony S.
  > >
  > > "Anthony Small" <anthonysmall "at" boltblue "dot" com> wrote in message
  > > news:eSjMljbHEHA.2556@TK2MSFTNGP12.phx.gbl...
   > > > Does anyone have any idea why the error below would occur?
   > > >
   > > > "ODBC: Msg 0, Level 16, State 1
   > > > Cannot load the DLL
   > > > Microsoft_SqlServer_NotificationServices_XP_2_0_3008_0.dll, or one of
 > the
   > > > DLLs it references.
   > > > Reason: 126(error not found)."
   > > >
   > > > It happens when I run task 5 of the stock sample.
   > > >
   > > > Specifically when I run
   > > > EXEC NSPrepareRuleFiring 0, 0
   > > > EXEC NSExecuteRuleFiring 0, 0
   > > >
   > > > Thanks in advance
   > > >
   > > > Tony S.
   > > >
   > > >
   > > >
   > > >
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Stock Sample, task 5 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL-NS 2005 StockBroker Sample doesn't notify - From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions exactly as stated in the book, I get success on the TEST and setup_all and I get no errors when aI start the service as described on pg. 69-70. I run the Test.sql file that..

Is the trace flag (8720) needed? - I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to....

High-level requirement for a pub-sub app - Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible futur...

Mapi error - I am trying set up notfication so it emails when jobs fail etcc. I am using sql server 2000 service pack 3A i have set up a mail profile and when I go into enterprise manger and go to test sql mail it says it opens and closes my mapi connection fine.....

How to get notification instance from another machine - Hi I want to run my webapplication at machine1, which should access the notification instance created at machine2. I dont see any server configuration in notificationservices properties. How this can be done? Thanks
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]