SQL Server Performance

Autoreply SMS from database

Discussion in 'ALL SQL SERVER QUESTIONS' started by LeslieJohn, Jan 15, 2013.

  1. LeslieJohn New Member

    I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer’s mobile phone. For example I will use Microsoft SQL Express as the database server. I found a software, OzekiSMS Gateway that can handle SMS receiving and sending. The database connection is the question. How should I organize the data in the database? Is this the best way as they recommend? (http://www.ozekisms.com/index.php?owpn=392&info=users-and-applications/autoreplydatabase-user)

    For example:
    > select * from autoreplymessage;
    id keyword msg
    ---------- ------------------------------ -------------------------------------
    1 default There is no data for this keyword.
    2 red Red is a good color.
    3 blue Blue is not the best option.

    Please share with me your suggestions.

  2. satya Moderator

    Welcome to the forums.
    You need to look into that tool and find how to build up the connection string to the database server & corresponding database to connect.
    I believe the steps within that link clearly states what to do, so what you is your doubt?

Share This Page