|
|
You're in the
sql server notification services
group:Windows Messenger
sql server notification services:
I have to appoligize...I had started this question in a different Group and have been re-directed to this one... Does anyone know how I can use Notification Services to create a Windows Instant Message that will be sent to an individual whenever a new record is created within my SQL Server database?...all help would be greatly appreciated. Also, in my research, I read an article that made me believe my server has to be an email server...is this correct?...if so, do you know of any work-around? What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual Studio.Net 2005.
Hello Again:
I was up all night trying to figure out how in the world I can send IMs from the server using Notification Services...no luck...by the way, those examples they give you in the package are awful...first of all, none of them worked properly and, in addition, there's no decent documentation...why not give real world examples!!...my god, there is nothing on the internet (that I could find) where someone explains how this works with an actual IM program...in the Microsoft website Microsoft mentions that it works with Windows Messenger SPECIFICALLY...I mean, why not then have documentation on how that works? Oh well, obviously I need some sleep...please help if you know anything about IM through Notification Services....36 hours straight working on how I can IM users (from the server side) when they complete a form on my web app...I give up!!!! [quoted text, click to view] "Justin" wrote:
> Hello Everyone: > > I have to appoligize...I had started this question in a different Group and > have been re-directed to this one... > > Does anyone know how I can use Notification Services to create a Windows > Instant Message that will be sent to an individual whenever a new record is > created within my SQL Server database?...all help would be greatly > appreciated. > > Also, in my research, I read an article that made me believe my server has > to be an email server...is this correct?...if so, do you know of any > work-around? > > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual > Studio.Net 2005. >
Hi Joe:
I must have posted my reply at the same time you did. If you have time, could you answer a few questions... 1. I see that the samples that come with Notification Solutions include both VisualStudio code and SQL Server stored procedures...how do they interact to send notifications?...does the SQL Server code send the notifications or is it the VisualStudio code or do they work together to create something at run-time....? 2. Code execution (Notification Sending) is done on the server end, right? 3. Could I set it up so that a Windows Messenger IM is sent from the server when a user completes a Web New Order form right? 4. Is there anyway you could forward me sample code for an instant messenger?...I litterally can't find it anywhere I hope you can help me...I'm dyin here...I'm stuck doing another guys work and I don't know butkus about VisualStudio or SQL Server...I know just enough to frustrate myself for 36 hours straight. Thanks [quoted text, click to view] "Joe Webb" wrote:
> On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: > > > Hello Everyone: > > > > I have to appoligize...I had started this question in a different Group and > > have been re-directed to this one... > > > > Does anyone know how I can use Notification Services to create a Windows > > Instant Message that will be sent to an individual whenever a new record is > > created within my SQL Server database?...all help would be greatly > > appreciated. > > > > Also, in my research, I read an article that made me believe my server has > > to be an email server...is this correct?...if so, do you know of any > > work-around? > > > > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual > > Studio.Net 2005. > > > > Thanks! > > > SSNS is very flexible and you can create your own custom components to > implement a variety of formatters, delivery protocols, and event > providers. To send messages via the Windows Instant Messenger, you'll need > to create a custom delivery protocol that employs an API for IM. > > SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built > using v2.0 of the .net framework. This means that you'll either need to > upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll > need to use VS2003 to build your custom components. > > HTH... > > Joe > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > >
Sorry, one last thing...I may be throwing too much out there...what I need is
a simple app (without any bells and whistles) that will send an instant message to one person each time a customer order is completed...that's it...no formatting or anything like that. Just... 1. Recipient 2. Message Text ....where and how do I create this in Notification Services? Sorry for the long-winded sob stories. Any help would be appreciated. Thanks Buddy [quoted text, click to view] "Joe Webb" wrote:
> On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: > > > Hello Everyone: > > > > I have to appoligize...I had started this question in a different Group and > > have been re-directed to this one... > > > > Does anyone know how I can use Notification Services to create a Windows > > Instant Message that will be sent to an individual whenever a new record is > > created within my SQL Server database?...all help would be greatly > > appreciated. > > > > Also, in my research, I read an article that made me believe my server has > > to be an email server...is this correct?...if so, do you know of any > > work-around? > > > > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual > > Studio.Net 2005. > > > > Thanks! > > > SSNS is very flexible and you can create your own custom components to > implement a variety of formatters, delivery protocols, and event > providers. To send messages via the Windows Instant Messenger, you'll need > to create a custom delivery protocol that employs an API for IM. > > SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built > using v2.0 of the .net framework. This means that you'll either need to > upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll > need to use VS2003 to build your custom components. > > HTH... > > Joe > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > >
[quoted text, click to view]
On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: > Hello Everyone: > > I have to appoligize...I had started this question in a different Group and > have been re-directed to this one... > > Does anyone know how I can use Notification Services to create a Windows > Instant Message that will be sent to an individual whenever a new record is > created within my SQL Server database?...all help would be greatly > appreciated. > > Also, in my research, I read an article that made me believe my server has > to be an email server...is this correct?...if so, do you know of any > work-around? > > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual > Studio.Net 2005. > > Thanks! SSNS is very flexible and you can create your own custom components to implement a variety of formatters, delivery protocols, and event providers. To send messages via the Windows Instant Messenger, you'll need to create a custom delivery protocol that employs an API for IM. SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built using v2.0 of the .net framework. This means that you'll either need to upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll need to use VS2003 to build your custom components. HTH... Joe -- Joe Webb SQL Server MVP http://www.sqlns.com
Hello:
Ok, I've been researching and I've managed to get a lot of information on how to create an instance, etc...but, I don't know how to bring it all together. Does anyone know of a good web site with tutorials and examples for this? I am using Sql Server 2000 and I now have copies of both VS.Net 2000 and VS.Net 2005. I've been able to create an instance of Notification Services using their command prompt...I can't seem to get beyond that though. I've tried using an XML file to set up the database so I can forge ahead, but the command prompt keeps throwing errors. The command line I'm entering is "nscontrol create -in appADF.xml"...even when I use the example XML files given with the installation I get an error that "<Application xmlns='http://www.microsoft.com/MicrosoftNotificationServices/ApplicationDefinitionFileSchema'> was not expected"...I must be doing something terribly wrong here because it works when I don't call the file from the command prompt. Thanks [quoted text, click to view] "Joe Webb" wrote:
> On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: > > > Hello Everyone: > > > > I have to appoligize...I had started this question in a different Group and > > have been re-directed to this one... > > > > Does anyone know how I can use Notification Services to create a Windows > > Instant Message that will be sent to an individual whenever a new record is > > created within my SQL Server database?...all help would be greatly > > appreciated. > > > > Also, in my research, I read an article that made me believe my server has > > to be an email server...is this correct?...if so, do you know of any > > work-around? > > > > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual > > Studio.Net 2005. > > > > Thanks! > > > SSNS is very flexible and you can create your own custom components to > implement a variety of formatters, delivery protocols, and event > providers. To send messages via the Windows Instant Messenger, you'll need > to create a custom delivery protocol that employs an API for IM. > > SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built > using v2.0 of the .net framework. This means that you'll either need to > upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll > need to use VS2003 to build your custom components. > > HTH... > > Joe > > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > >
[quoted text, click to view]
On Thu, 12 Apr 2007 03:44:05 -0700, Justin wrote: > Hello: > > Ok, I've been researching and I've managed to get a lot of information on > how to create an instance, etc...but, I don't know how to bring it all > together. Does anyone know of a good web site with tutorials and examples > for this? I am using Sql Server 2000 and I now have copies of both VS.Net > 2000 and VS.Net 2005. > > I've been able to create an instance of Notification Services using their > command prompt...I can't seem to get beyond that though. I've tried using an > XML file to set up the database so I can forge ahead, but the command prompt > keeps throwing errors. The command line I'm entering is "nscontrol create > -in appADF.xml"...even when I use the example XML files given with the > installation I get an error that "<Application > xmlns='http://www.microsoft.com/MicrosoftNotificationServices/ApplicationDefinitionFileSchema'> > was not expected"...I must be doing something terribly wrong here because it > works when I don't call the file from the command prompt. > > Thanks > > "Joe Webb" wrote: > >> On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: >> >> > Hello Everyone: >> > >> > I have to appoligize...I had started this question in a different Group and >> > have been re-directed to this one... >> > >> > Does anyone know how I can use Notification Services to create a Windows >> > Instant Message that will be sent to an individual whenever a new record is >> > created within my SQL Server database?...all help would be greatly >> > appreciated. >> > >> > Also, in my research, I read an article that made me believe my server has >> > to be an email server...is this correct?...if so, do you know of any >> > work-around? >> > >> > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual >> > Studio.Net 2005. >> > >> > Thanks! >> >> >> SSNS is very flexible and you can create your own custom components to >> implement a variety of formatters, delivery protocols, and event >> providers. To send messages via the Windows Instant Messenger, you'll need >> to create a custom delivery protocol that employs an API for IM. >> >> SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built >> using v2.0 of the .net framework. This means that you'll either need to >> upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll >> need to use VS2003 to build your custom components. >> >> HTH... >> >> Joe >> >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com >> >> >> >> >> Hi Justin - I usually recommend that beginners start with the BOL walk-through project. It steps you through creating a SSNS instance from start to finish. It's not the only bit of information you'll need, but it's a good start. There are a couple of books on the market for SSNS - Shyam Pather as a 600+ page book that goes into great detail on the subject. I also have one that is about 1/3 that length designed to get readers up on speed on SSNS very quickly. As for your error message - NSControl wants the ICF, not the ADF. HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com
[quoted text, click to view]
On Wed, 11 Apr 2007 05:32:01 -0700, Justin wrote: > Hi Joe: > > I must have posted my reply at the same time you did. > > If you have time, could you answer a few questions... > 1. I see that the samples that come with Notification Solutions include both > VisualStudio code and SQL Server stored procedures...how do they interact to > send notifications?...does the SQL Server code send the notifications or is > it the VisualStudio code or do they work together to create something at > run-time....? > 2. Code execution (Notification Sending) is done on the server end, right? > 3. Could I set it up so that a Windows Messenger IM is sent from the server > when a user completes a Web New Order form right? > 4. Is there anyway you could forward me sample code for an instant > messenger?...I litterally can't find it anywhere > > I hope you can help me...I'm dyin here...I'm stuck doing another guys work > and I don't know butkus about VisualStudio or SQL Server...I know just enough > to frustrate myself for 36 hours straight. > > Thanks > > "Joe Webb" wrote: > >> On Tue, 10 Apr 2007 20:30:01 -0700, Justin wrote: >> >> > Hello Everyone: >> > >> > I have to appoligize...I had started this question in a different Group and >> > have been re-directed to this one... >> > >> > Does anyone know how I can use Notification Services to create a Windows >> > Instant Message that will be sent to an individual whenever a new record is >> > created within my SQL Server database?...all help would be greatly >> > appreciated. >> > >> > Also, in my research, I read an article that made me believe my server has >> > to be an email server...is this correct?...if so, do you know of any >> > work-around? >> > >> > What I have...1) SQL Server 2000, 2) Windows Server 2003, 3) Visual >> > Studio.Net 2005. >> > >> > Thanks! >> >> >> SSNS is very flexible and you can create your own custom components to >> implement a variety of formatters, delivery protocols, and event >> providers. To send messages via the Windows Instant Messenger, you'll need >> to create a custom delivery protocol that employs an API for IM. >> >> SSNS v2.0 is built using v1.1 of the .net framework. SSNS 2005 is built >> using v2.0 of the .net framework. This means that you'll either need to >> upgrade your SQL Server database to 2005 so you can use VS 2005, or you'll >> need to use VS2003 to build your custom components. >> >> HTH... >> >> Joe >> >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com >> >> >> >> >> 1. The VS samples are projects that contain all the files used by SSNS to create the instance and/or the subscription management application used to add new subscribers and subscriptions. SSNS is whole contained in SSNS (in an extended stored procedure in SSNS 2.0 and fully integrated in SSNS 2005). 2. Right, the server is where SSNS runs. 3. Right. 4. No, I don't have a sample with IM to give you. HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com
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 |