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 |
|
Chainwhip
Starting Member
33 Posts |
 Posted - 2003-07-24 : 08:31:56
|
| Can anyone point me in the right direction?I need to post to a HTTP gateway so that I can send an SMS "text message" out to a table of customers. Let's say if I need to send a text message I call the URL:http://server.com/send?Mobile=123456&Message=Hello+SuckerI probably guess I'll have to run all this through a local package through some ActiveX Script. Anyone know about his or have a better idea? PS The HTTP gateway is not mine - I can't change it. |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-07-24 : 09:00:00
|
| You may post your stuff thru XMLHTTPRequest object.- Vit |
 |
|
|
Chainwhip
Starting Member
33 Posts |
Posted - 2003-07-24 : 17:33:56
|
| Cheers Vit - exactly what I'm after |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-24 : 19:40:25
|
| Just be careful of doing this in a trigger, you can cause the process to hang and your SQL Server could hang or crash. Also be very carefult about creating and destroying your COM objects so that their memory is released.It would probably be better to create a standalone EXE component that uses the XMLHTTP objects, and you pass the parameters through a command line. That way you can kick it off without it using SQL Server's process space. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-07-24 : 23:30:59
|
| I totally agree with Rob. I've "locked up" a SQL server before doing that stuff.Keep COM outta SQL server IMHO. Put it in a separate APP / Service.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL Server sending to a HTTP gateway?