OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

Video Contents | SearchKeywords

Home > Product Manual > Installation Guide > Users and applications > SMS from/to database > Connection string builder

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  Service Provider Connections
  Users and applications
  Standard user
  SMPP user
  SMS from/to database
  MSSQL
  MySQL
  Oracle
  Sybase SQL Anywhere
  PostgreSQL
  Pervasive SQL
  Date Format Strings
  Scheduled SMS
  SQL templates
  Informix
  Access
  Video
  Connection string builder
  Keywords
  MS SQL high speed
  Oracle High Speed
  SQL statements
  Polling technology
  Dynamic Keywords
  Dynamic SMPP parameters
  Autoreply SMS from database
  Autoreply SMS using a script
  Simple autoreply SMS
  SMS from/to file
  SMS through E-mail
  SMS via HTTP Request
  SMS via colour protocol
  Application starter SMS
  SMS Voting
  SMS from MS Outlook
  SMS from/to FTP server
  PDF Request in SMS
  SMS to WCF service
  SMS Forwarder
  RSS to SMS
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 
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.

Database connection string builder


Download:ConnectionStringBuilder.exe (770 Kb)
Download:ConnectionStringBuilder.zip (340 Kb)

The database connection string builder tool can be used to create database connection strings. These connection strings can be specified in the "Database user" configuration form to create an SQL to SMS gateway configuration. In this webpage you can find information on how to use the database connection string builder.

To build a connection string, you must start the downloaded tool, then you should click on the "Build database connection string" button. This will bring up the "Database.connectionstring" form (Figure 1).


Figure 1 - Start the building

On the "Database.connectionstring" form select "Use connection string", then click on the "Build" button (Figure 2).


Figure 2 - Select connection string

On the next form you should select the database driver you wish to use. If you want to use an ODBC connection, you can select the "Microsoft OleDb provider for ODBC drivers" item (Figure 3).


Figure 3 - Select ODBC connection string

On the ODBC configuration form, you should select "Use connection string" as your choice, then click on the "Build..." button (Figure 4).


Figure 4 - Build ODBC connection string

When you build an ODBC connection string it is important to create a Machine datasource. A machine datasource is available for a background service, such as the Ozeki NG SMS Gateway. User datasources are only available for a logged in user, so they cannot be used in an SQL to SMS gateway configuration. To start select the "Machine datasource" tab, then click "New" (Figure 5).


Figure 5 - Build a machine data source

During the building the "System datasource" option should be selected. A system datasource is a machine datasource, which means it can be accessed by background services (Figure 6).


Figure 6 - Select system data source

From this point the configuration is pretty straightforward. You must select the ODBC driver that matches your database server and you must fill in the connection parameters, such as the hostname, the username and the password. Once this is done you must click OK on all forms to get your connection string.

Dig deeper!
People who read this also read...





Next page: Keywords
Copyright © 2000 - 2014 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