Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: +36 1 371 0150
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

Allow authentication Contents | SearchStart Ozeki NG GUI

Home > Product Manual > Developers Guide > SQL SMS API > ASP.NET and MS SQL Server > Create database and user

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Developers Guide
  Tutorials
  ASP SMS API
  PHP SMS API
  HTTP SMS API
  SQL SMS API
  ASP.NET and MS SQL Server
  Allow authentication
  Create database and user
  Start Ozeki NG GUI
  Create a database user in NG
  wwwroot
  Data field change
  Cheking the sending
  Ozeki database table layout
  State values
  C Sharp SMS API
  AJAX SMS API
  Delphi SMS API
  Cpp SMS API
  Java SMS API
  VB.NET SMS API
  Python SMS API
  Perl SMS API
  TCL/TK SMS API
  Coldfusion SMS API
  VB 6 SMS API
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
  Cookie policy
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

Create the database with tables and the user in MS SQL Server

In SQL Server Management Studio Express, click the New Query icon.



Into the new SQL panel, enter this:

create database ozekisms;

Then click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.



We have to create the tables. Delete text "create database ozekisms;" and enter the following:

use ozekisms;

create table ozekimessagein (
id int identity(1,1),
sender varchar(30),
receiver varchar(30),
msg varchar(1024),
senttime varchar(100),
receivedtime varchar(100),
operator varchar(100),
msgtype varchar(160));

create table ozekimessageout (
id int identity(1,1),
sender varchar(30),
receiver varchar(30),
msg varchar(1024),
senttime varchar(100),
receivedtime varchar(100),
status varchar(20),
operator varchar(100),
msgtype varchar(160));

Then, click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.



Finally, create the user (named sqluser with the abc123 password) that will have permission to log in and access the tables above. The text is this (do not forget to delete the previous text):

use ozekisms;
create login sqluser with password='abc123';
use ozekisms;
create user sqluser for login sqluser;
use ozekisms;
grant select,insert,update,delete on ozekimessagein to sqluser;
grant select,insert,update,delete on ozekimessageout to sqluser;

Then click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.

Related information

Message statuses in database
Database table layout





Next page: Start Ozeki NG GUI
Copyright © 2000 - 2017 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com