- Product Manual
- Introduction
- 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
- Cheking the sending
- Ozeki database table layout
- State values
- C# 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
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android
C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code
PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website
SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
Creating a Database user in Ozeki NG - SMS Gateway for the MS SQL Server
This guide explains, how you can create a database user in Ozeki NG - SMS Gateway to your MS SQL database server. This user will be used to SELECT your outgoing messages from the outgoing database table, and to INSERT your incoming SMS messages into the incoming database table.
To start installing and configuring an database user in the Home page move your mouse over the Users and applications menu, and click the Add user menu item as you can see on the Figure 1.
Figure 1 - Adding a new user in Ozeki NG
An interface will open consisting of two panels. The left side panel contains the already installed users and applications. The right side panel contains the users and applications you can install with a brief description next to them. Search the Database user and click the blue 'install' button next to it (Figure 2).
Figure 2 - New databse user in Ozeki NG
Clicking the Install link will bring up the Database user installation panel. Here, you need to enter a unique username in the User name field (Figure 3). Enter a name in the User name text box and click OK.
Figure 3 - New sample SQL user in Ozeki NG
In the Database user configuration page Database connection tab Select OleDb in the Connection string type dropdown menu. After it in the Connection string edit box, enter the following connection string and finally, click OK as Figure 4 shows.
Provider=sqloledb;Server=(local)\SQLExpress;Database=ozekisms;User Id=sqluser;Password=abc123; |
Figure 4 - Click the OK button in Ozeki NG
More information
- ASP.NET and MS SQL Server
- SQL SMS API
- Create database and user
- Data field change
- Graphical User Interface
- Quick Start Guide
- Configuration
- Administrator's guide
- Installation guide of Ozeki SMS gateway
- Message statuses in database
- Database table layout
- Checking the sent SMS status
- Run the SQL SMS example
- Feature list of the Ozeki NG SMS Gateway
- FAQ of the Ozeki NG SMS Gateway