Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sitka
Aged Yak Warrior
571 Posts |
 Posted - 2003-10-02 : 14:21:07
|
| Anybody seen a means to provide SMB messaging from SQL or IIS.SMB is like Net Send but it is different protocol. In a manufacturing plant Net Send is disabled and many of the PC's at machines or in areas are accessed like ciosks so it would be nice to eliminate email clients on them, but still maintain messaging by IP address etc.Lantalk is a cool thing and I tried it but haven't found a programming reference for it.Voted best SQL forum nickname...."Tutorial-D" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-02 : 19:35:56
|
| If there is a command-line version of the utility then you can call it using xp_cmdshell, like you would with net send. Also, some protocols like SMS text messages usually provide an email interface that accepts the phone number as part of the email address. If you can find (or develop) an SMB utility that can translate that to a machine address you could then use regular email alerts in SQL Server. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-10-03 : 07:51:09
|
| Thanks, the command line utility is the thing I can't find, well it isn't a gimme anyway? Figured for sure there would be one out there. Still looking though. We purchased a few licencese of this LanTalk thing which has a client called LanInfo which is receive only. Keeps the messages that were received in a little inbox and has mail client like functionality but no sending. Anyways now that this messaging is automated I'm left without the command line part. Guess I'll write Lantalk and ask if it command line is available, simply undocumented. I found a few others that may work but always bigger than neccessary overhead, install and complexity to do something simple. Took a demo of Sonork a full featured enterprise Instant messanger, man tooo much stuff. They have a dedicated Http engine and proprietory HTML tags that handle web based messaging forms, huge package. I was looking more along the lines of Server.CreateObject("SimpleLanMessage.4id10ts"). Or like you say xp_cmdshell whatever cause I'm flexible in which server can spawn this. Thanks again though 'cause your advice solidifies the approach. Just need to go hunting.Voted best SQL forum nickname...."Tutorial-D" |
|
|
|
|
|
|
SMB messaging