text message via sql server 2005 to mobile phone

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 402,024 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,396 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Thread Tools Display Modes

Views: 1906 | Replies: 1

•

Join Date: Apr 2007

Posts: 1

Reputation: vijayanbt is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

vijayanbt

Offline

Newbie Poster

text message via sql server 2005 to mobile phone

Apr 27th, 2007

hai all

i am undertaking a project of sending sms to mobile phone using sql server 2005,pls guide me how to do that,this is urgent please

•

Join Date: Apr 2004

Location: in a galaxy far far away :)

Posts: 121

Reputation: johnroach1985 is an unknown quantity at this point

Rep Power: 5

Solved Threads: 0

johnroach1985 johnroach1985 is offline

Offline

Junior Poster

Re: text message via sql server 2005 to mobile phone

May 1st, 2007

Man you don't do that only using SQL 2005 you have to have a program that will get the data from your database and move it towards the SMS system you are using. This program could be a basic VB script or a complicated C++ program it depends on how complex your SMS system/program you are using. I myself wrote my own using C# what the case was that the company I was working for had an agreement with the SMS service provider. And opened an internet connection with a certain port with a certain username and password. What the program did was is got the message from the database and send it to the destination that was agreed on with the SMS provider. I can't give you the codes because that will create security issues. (Since I had written the code only in 15 min...didn't get the chance to encrypt it....) Good luck ... Hope I was of help.

------

"A rational anachist believes that concepts such as 'state' and 'society' and 'government' have no existence save as physically exemplified in acts of self-responsible individuals.He believese that it is impossible to shift blame,share blame,distrubute blame.... as blame,guilt,responsibility are matters taking place inside human beings singly and nowhere else.But being rational,he knows that not all individuals hold his evaluations,so he tries to live perfectly in an imperfectworld...aware that his effort wil be less than perfect yet undismayed by self-knowledge of self-failure."

-Robert A. Heinlein

-----
John Roach