C# Discussion Boards - CodeProject

hello

i dawnload the code (How to Send SMS Messages from C# using an SQL Database) from code project

i follow the step in it i have installed the required gateway which is ozeki gate way , but i face two problem...one is when i run the C# application and it display the follwing message (The SMSC provider is not registered in your local machine)...

the second when i use ozeki gate way i couldn't send message from it. it show the error number 1360,1366,1361 according.

please guide me tosolve this problem as soon as possible

the code in the is

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace mySMSApplication
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
try
{
//Connect to the database
OleDbConnection conn = new OleDbConnection();

Provider=SQLNCLI;Server=.\SQLEXPRESS;User ID=ozekiuser;password=ozekipass;
Database=ozeki;Persist Security Info=True conn.Open();
if (conn.State == ConnectionState.Open)
{
//Send the message
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
string SQLInsert =
"INSERT INTO "+
"ozekimessageout (receiver,msg,status) "+
"VALUES "+
"('"+tbSender.Text+"','"+tbMsg.Text+"','send')";
cmd.CommandText = SQLInsert;
cmd.ExecuteNonQuery();
MessageBox.Show("Message sent");
}

//Disconnect from the database
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

private void Form1_Load(object sender, EventArgs e)
{

}
}
}

modified 15-Feb-13 5:51am.

Please edit your post and do the following:
1. Change title to something more descriptive than "C#". You're in the C# forum, people tend to assume the question is related to C#.
2. Remove the bold text and use the code button in the toolbar (enters the pre tags in the text, your code needs to be between pre tags)
3: Remove User Id and especially password from your connection string and replace with dummy text. Never ever give user id's and password in clear text. Even if it is just a test database.
4: Improve your language a little, even if you're not native English, a space here, a spell check there can work miracles.
5: Maybe related to #4, but I haven't understood the core problem
6: "please guide me tosolve this problem as soon as possible" -> Don't count on it. At best it will work just the opposite way. We're not here to serve you, we're here at our own free will and will help if we can, or want to and we will assign as much time to it as we wish.

On the positive side. You did do some research, you did post some code. Smile | :)

Best of luck.

V.

(MQOTD Rules and previous Solutions )

thank you,,,

i did what you suggest...
" i'm just a beginner in programming field and i will learn from my faults"

With that attitude everything will be just fine Thumbs Up | :thumbsup:

V.

(MQOTD Rules and previous Solutions )

You should post your question in the forum at the end of the article. In that way the author will get notified, and he or she is better placed to help you.

thank you

Member 9641406 wrote:
The SMSC provider is not registered in your local machine

And presumably you did the following which is from the article that you are referring to.

"The system architecture used for SMS messaging consists of a GSM Modem, that is attached to the PC with a phone-to-PC datacable, an SQL-SMS Gateway software installed onto your PC"

C# source of send & get SMS: Download[^] Smile | :)

/* LIFE RUNS ON CODE */