New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

New SQL-NS 2005 Book

Folks,

I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/.

This book has been completely updated for the 2005 release:

- All source code examples are now designed to work with the 2005 programming model and tools

- New chapters have been added to cover the new 2005 features (such as the NMO API, Hostable Execution Engine, and User-Defined Matching Logic)

I hope you find this useful. As always, I appreciate receiving any feedback you may have.

Thanks

-shyam

Hi Shyam,

I bought your book, and it's really good book which can tell me more detail.

Right now I met a problem when I was testing SMTP delivery channel in chapter 10. with local smtp service, the musicStore worked as expected, but if I changed to use another computer in the same domain, nothing happened. Checking the application event view, it said:

Notification Class Name: NewSong

Notification Status Info: The e-mail address or SMTP server value is not valid.

SMTP Server: 192.168.1.128

Message Recipients: emily@.work.com

I have tried other setting for SMTPServer in InstanceConfiguration.xml, like "\\myServer", "myServer.myDomain" and "myServer.myDomain.local", but all got the same result. I have checked online book and some forum, but nothing helpful. Could you help it out? Thanks in advance.

Regards,

Chris

|||

HI shyam,

Just got the book this week and im finding it very useful and helpful. The std MSDN examples are very short on documentation. I dont seem to have one issue though, Im currently going through chapter 6 and am finding that the scheduled subscriptions for the Music Store sample are not working.

Working through the database i can see that my NewSongByGenreSubscriptionProcessingTimes table is not being filled in. I looked a little deeper into the SQl statements and ran this

SELECT subscriptions.SubscriptionId, subscriptions.Created
FROM [SongAlerts].[NewSongByGenre] subscriptions

This unfortunately returns nothing, which looks to be the problem as my chronicle always stays empty. I've used your tool to add the scheduled subscriptions and unfortunately that does seem to work, its adding subscriptions, so i cant understand why the query above doesnt fire.

A little deeper and i see the two tables NSCurrentNewSongByGenreSubscriptions and NSFiringNewSongByGenreInterval are empty? dont really know what they do.

Dont suppose you can test and confirm that Chapter 6 does work correctly. I've been over it 3 times and am about to get a work mate to try on their machine, but so far no luck.

Aside from that little niggle, its an excellent book, the chapter on Custom Delivery Channels was worth it alone. :)

|||

For those who consider buying this book to prepare for their new project on SQL Server Notification Services, here's what I have to say:

1. I bought the author's previous book (on SQL NS 2.0 - for SQL Server 2000). Before I got it, I had only a very dim idea about what NS is and what it can do.

2. Two weeks later, I had a fully functional prototype of my application. It had only a subset of the real huge project's functionality (the project is truly HUGE!..), including a custom content formatter and a custom event provider. But it worked, and we are now just extending it. I mean, no need to refactor the code or start from scratch. Well, to tell you the truth, in those 2 weeks I worked quite a bit more than 8 hours a day, but it was worth it. My boss is still trying to throw some tricky questions on me (like, "What happens with our application IF..."), and there have been no questions so far that I was unable to answer. The book is just great!

3. My advice to you: work through all the samples (at least, in the first half of the book, or until you get a clear idea on how all the pieces of NS fit together). It's not nearly as bad as it sounds: the explanations and step-by-step instructions on how to do every little thing are so good that even a complete moron would be able to get it (and none of us are morons... I think... ;-)

4. I usually buy technical books only when I need to get up to speed with a particular technology as fast as possible. Shyam Pather's book exceeded all my expectations. The book reads as easily as my favorite science fiction books (and way easier than "The Lord of the Rings"). And almost as interesting as they are.

sql

New SQL Server Setup - 32 or 64bit windows 2003?

Hi folks,
Just wondering if anyone can offer me any advice on a new SQL server
setup I am putting together. We are trying to squeeze as much
performance out of a new server as possible.
We are looking at getting a DL380 with a quad core xeon, 4gb ram and
looking to run windows 2003 server standard r2 edition. The question
is whether to go with the 32 bit
version of windows or the 64bit version. We will be running SQL 2000
in 32 bit mode anyway so is there really any benfit in running the 64
bit version of windows? One supplier has mentioned
that it isn't really worth it unless we are running with at least 8gb
of RAM in the machine. Anyone any ideas?
On the disk arrangements I am looking at the following setup. 2 x
72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
running the log files and then 3 x 146gb SAS drives
running the datafiles running RAID 5. What do you think? Is this
suitable?
Any tips or ideas greatfully received!
Thanks in advance
Hi
If you have 64bit processors that are are supported SQL Server, then using
64bit all the way through is going to give you better performance. I am not
sure why you rule out 64bit SQL Server?
John
"Fox1977" wrote:

> Hi folks,
> Just wondering if anyone can offer me any advice on a new SQL server
> setup I am putting together. We are trying to squeeze as much
> performance out of a new server as possible.
> We are looking at getting a DL380 with a quad core xeon, 4gb ram and
> looking to run windows 2003 server standard r2 edition. The question
> is whether to go with the 32 bit
> version of windows or the 64bit version. We will be running SQL 2000
> in 32 bit mode anyway so is there really any benfit in running the 64
> bit version of windows? One supplier has mentioned
> that it isn't really worth it unless we are running with at least 8gb
> of RAM in the machine. Anyone any ideas?
> On the disk arrangements I am looking at the following setup. 2 x
> 72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
> running the log files and then 3 x 146gb SAS drives
> running the datafiles running RAID 5. What do you think? Is this
> suitable?
> Any tips or ideas greatfully received!
> Thanks in advance
>
|||On 12 Mar, 08:48, John Bell <jbellnewspo...@.hotmail.com> wrote:[vbcol=seagreen]
> Hi
> If you have 64bit processors that are are supported SQL Server, then using
> 64bit all the way through is going to give you better performance. I am not
> sure why you rule out 64bit SQL Server?
> John
> "Fox1977" wrote:
>
>
Thanks John,
We have decided to take the plunge and go with x64 for server and SQL

New SQL Server Setup - 32 or 64bit windows 2003?

Hi folks,
Just wondering if anyone can offer me any advice on a new SQL server
setup I am putting together. We are trying to squeeze as much
performance out of a new server as possible.
We are looking at getting a DL380 with a quad core xeon, 4gb ram and
looking to run windows 2003 server standard r2 edition. The question
is whether to go with the 32 bit
version of windows or the 64bit version. We will be running SQL 2000
in 32 bit mode anyway so is there really any benfit in running the 64
bit version of windows? One supplier has mentioned
that it isn't really worth it unless we are running with at least 8gb
of RAM in the machine. Anyone any ideas?
On the disk arrangements I am looking at the following setup. 2 x
72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
running the log files and then 3 x 146gb SAS drives
running the datafiles running RAID 5. What do you think? Is this
suitable?
Any tips or ideas greatfully received!
Thanks in advanceHi
If you have 64bit processors that are are supported SQL Server, then using
64bit all the way through is going to give you better performance. I am not
sure why you rule out 64bit SQL Server?
John
"Fox1977" wrote:
> Hi folks,
> Just wondering if anyone can offer me any advice on a new SQL server
> setup I am putting together. We are trying to squeeze as much
> performance out of a new server as possible.
> We are looking at getting a DL380 with a quad core xeon, 4gb ram and
> looking to run windows 2003 server standard r2 edition. The question
> is whether to go with the 32 bit
> version of windows or the 64bit version. We will be running SQL 2000
> in 32 bit mode anyway so is there really any benfit in running the 64
> bit version of windows? One supplier has mentioned
> that it isn't really worth it unless we are running with at least 8gb
> of RAM in the machine. Anyone any ideas?
> On the disk arrangements I am looking at the following setup. 2 x
> 72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
> running the log files and then 3 x 146gb SAS drives
> running the datafiles running RAID 5. What do you think? Is this
> suitable?
> Any tips or ideas greatfully received!
> Thanks in advance
>|||On 12 Mar, 08:48, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> If you have 64bit processors that are are supported SQL Server, then using
> 64bit all the way through is going to give you better performance. I am not
> sure why you rule out 64bit SQL Server?
> John
> "Fox1977" wrote:
> > Hi folks,
> > Just wondering if anyone can offer me any advice on a new SQL server
> > setup I am putting together. We are trying to squeeze as much
> > performance out of a new server as possible.
> > We are looking at getting a DL380 with a quad core xeon, 4gb ram and
> > looking to run windows 2003 server standard r2 edition. The question
> > is whether to go with the 32 bit
> > version of windows or the 64bit version. We will be running SQL 2000
> > in 32 bit mode anyway so is there really any benfit in running the 64
> > bit version of windows? One supplier has mentioned
> > that it isn't really worth it unless we are running with at least 8gb
> > of RAM in the machine. Anyone any ideas?
> > On the disk arrangements I am looking at the following setup. 2 x
> > 72gb SAS drives RAID 1 running the system, 2 x 72gb SAS drives RAID 1
> > running the log files and then 3 x 146gb SAS drives
> > running the datafiles running RAID 5. What do you think? Is this
> > suitable?
> > Any tips or ideas greatfully received!
> > Thanks in advance
Thanks John,
We have decided to take the plunge and go with x64 for server and SQL

New request is not allowed to start

Hi folks,
We have an Access front end that happily does all its reading, riting
and rithmetic onto a SQL Server 2005 BE.
There is a timer event on one of the user forms that polls to see if
the DBA wants to kick you out (a flag on a table that gets set by an
Administrators task, and if it is on, then users get a message).
This all works fine, unless the user is running one of the two stored
procedures that take a long while to execute (up to 60 seconds).
When that happens, if the execution time of the sp is longer than the
polling time interval (20 seconds), a conflict seems to occur, and we
get the message "New request is not allowed to start because it should
come with a valid transaction descriptor."
We have tried putting the statement SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED; into the stored proc, but it doesn't seem to have
helped.
Any ideas on how we can solve the problem?
Can we somehow run the procedure as a batch that is initiated by the
front-end, but doesn't need to maintain a connection with it?
We were required by the Powers That Be to open a single connection on
our front end for any DB access, rather than open a connection for
each form or process. Could this have something to do with it?
Any ideas gratefully received, Ray<ray@.aic.net.au> wrote in message
news:1194497708.231234.313780@.z24g2000prh.googlegroups.com...
> Hi folks,
> We have an Access front end that happily does all its reading, riting
> and rithmetic onto a SQL Server 2005 BE.
> There is a timer event on one of the user forms that polls to see if
> the DBA wants to kick you out (a flag on a table that gets set by an
> Administrators task, and if it is on, then users get a message).
> This all works fine, unless the user is running one of the two stored
> procedures that take a long while to execute (up to 60 seconds).
> When that happens, if the execution time of the sp is longer than the
> polling time interval (20 seconds), a conflict seems to occur, and we
> get the message "New request is not allowed to start because it should
> come with a valid transaction descriptor."
> We have tried putting the statement SET TRANSACTION ISOLATION LEVEL
> READ UNCOMMITTED; into the stored proc, but it doesn't seem to have
> helped.
> Any ideas on how we can solve the problem?
> Can we somehow run the procedure as a batch that is initiated by the
> front-end, but doesn't need to maintain a connection with it?
> We were required by the Powers That Be to open a single connection on
> our front end for any DB access, rather than open a connection for
> each form or process. Could this have something to do with it?
> Any ideas gratefully received, Ray
>
Have you considered using
ALTER DATABASE SET SINGLE_USER WITH
[
ROLLBACK AFTER integer [ SECONDS ]
| ROLLBACK IMMEDIATE
| NO_WAIT
];
?
David Portas|||Well, no, I hadn't considered that because the problem can occur when
only one user is connected to the database.
I'm sure that the conflict is not between User A and User B.
As far as I can see (and our error trapping seems to confirm this),
the problem is that Stored Proc 1 executed by User A causes a conflict
with Stored Proc 2 also executed by User A (the polling process).
So thanks for your suggestion, but I am hoping to find a way to allow
the user to initiate and receive notifications from two separate
processes. Perhaps one needs to run independently somehow, just by
being initiated at the front end? Or do we need multiple connections
from the front end?
Thanks,
Ray|||Just for the record, in case anybody else encounters this, we opened a
separate connection in the Access front end and did the polling
through it, which resolved the problemo.

New request is not allowed to start

Hi folks,
We have an Access front end that happily does all its reading, riting
and rithmetic onto a SQL Server 2005 BE.
There is a timer event on one of the user forms that polls to see if
the DBA wants to kick you out (a flag on a table that gets set by an
Administrators task, and if it is on, then users get a message).
This all works fine, unless the user is running one of the two stored
procedures that take a long while to execute (up to 60 seconds).
When that happens, if the execution time of the sp is longer than the
polling time interval (20 seconds), a conflict seems to occur, and we
get the message "New request is not allowed to start because it should
come with a valid transaction descriptor."
We have tried putting the statement SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED; into the stored proc, but it doesn't seem to have
helped.
Any ideas on how we can solve the problem?
Can we somehow run the procedure as a batch that is initiated by the
front-end, but doesn't need to maintain a connection with it?
We were required by the Powers That Be to open a single connection on
our front end for any DB access, rather than open a connection for
each form or process. Could this have something to do with it?
Any ideas gratefully received, Ray
Well, no, I hadn't considered that because the problem can occur when
only one user is connected to the database.
I'm sure that the conflict is not between User A and User B.
As far as I can see (and our error trapping seems to confirm this),
the problem is that Stored Proc 1 executed by User A causes a conflict
with Stored Proc 2 also executed by User A (the polling process).
So thanks for your suggestion, but I am hoping to find a way to allow
the user to initiate and receive notifications from two separate
processes. Perhaps one needs to run independently somehow, just by
being initiated at the front end? Or do we need multiple connections
from the front end?
Thanks,
Ray
|||Just for the record, in case anybody else encounters this, we opened a
separate connection in the Access front end and did the polling
through it, which resolved the problemo.

New request is not allowed to start

Hi folks,
We have an Access front end that happily does all its reading, riting
and rithmetic onto a SQL Server 2005 BE.
There is a timer event on one of the user forms that polls to see if
the DBA wants to kick you out (a flag on a table that gets set by an
Administrators task, and if it is on, then users get a message).
This all works fine, unless the user is running one of the two stored
procedures that take a long while to execute (up to 60 seconds).
When that happens, if the execution time of the sp is longer than the
polling time interval (20 seconds), a conflict seems to occur, and we
get the message "New request is not allowed to start because it should
come with a valid transaction descriptor."
We have tried putting the statement SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED; into the stored proc, but it doesn't seem to have
helped.
Any ideas on how we can solve the problem?
Can we somehow run the procedure as a batch that is initiated by the
front-end, but doesn't need to maintain a connection with it?
We were required by the Powers That Be to open a single connection on
our front end for any DB access, rather than open a connection for
each form or process. Could this have something to do with it?
Any ideas gratefully received, Ray<ray@.aic.net.au> wrote in message
news:1194497708.231234.313780@.z24g2000prh.googlegroups.com...
> Hi folks,
> We have an Access front end that happily does all its reading, riting
> and rithmetic onto a SQL Server 2005 BE.
> There is a timer event on one of the user forms that polls to see if
> the DBA wants to kick you out (a flag on a table that gets set by an
> Administrators task, and if it is on, then users get a message).
> This all works fine, unless the user is running one of the two stored
> procedures that take a long while to execute (up to 60 seconds).
> When that happens, if the execution time of the sp is longer than the
> polling time interval (20 seconds), a conflict seems to occur, and we
> get the message "New request is not allowed to start because it should
> come with a valid transaction descriptor."
> We have tried putting the statement SET TRANSACTION ISOLATION LEVEL
> READ UNCOMMITTED; into the stored proc, but it doesn't seem to have
> helped.
> Any ideas on how we can solve the problem?
> Can we somehow run the procedure as a batch that is initiated by the
> front-end, but doesn't need to maintain a connection with it?
> We were required by the Powers That Be to open a single connection on
> our front end for any DB access, rather than open a connection for
> each form or process. Could this have something to do with it?
> Any ideas gratefully received, Ray
>
Have you considered using
ALTER DATABASE SET SINGLE_USER WITH
[
ROLLBACK AFTER integer [ SECONDS ]
| ROLLBACK IMMEDIATE
| NO_WAIT
];
?
--
David Portas|||Well, no, I hadn't considered that because the problem can occur when
only one user is connected to the database.
I'm sure that the conflict is not between User A and User B.
As far as I can see (and our error trapping seems to confirm this),
the problem is that Stored Proc 1 executed by User A causes a conflict
with Stored Proc 2 also executed by User A (the polling process).
So thanks for your suggestion, but I am hoping to find a way to allow
the user to initiate and receive notifications from two separate
processes. Perhaps one needs to run independently somehow, just by
being initiated at the front end? Or do we need multiple connections
from the front end?
Thanks,
Ray|||Just for the record, in case anybody else encounters this, we opened a
separate connection in the Access front end and did the polling
through it, which resolved the problemo.