How to send and receive SMS from PostgreSql Database server

This page gives an overview on how to configure an ODBC connection to the PostgreSql Database server. Once the connection is configured, you can send or receive SMS messages using SQL queries.

Step 1 - Install OZEKI SMS for Windows

Step 2 - Download and install the PostgreSql ODBC driver. This driver can be found at http://www.postgresql.org or from this location: psqlodbc-07_03_0200.zip

installation of postgresql
Figure 1 - The installation og PostgreSql

Step 3 - Open the Windows Control Panel from the START menu.

Step 4 - Select administrative tools and click on ODBC Data Sources.

Step 5 - In the ODBC data sources form click on Add

how to add odbc data source
Figure 2 - Adding ODBC data source

Step 6 - In the ODBC data sources form click on Add

how to create new data source
Figure 3 - Creating new data source

Step 7 - Select the PostgreSQL driver and click on Finish

connection information form for psql odbc driver
Figure 4 - Connection information form

Step 8 - Fill in the connection information

Step 9 - Open OZEKI SMS and install the Database plugin from the Plugins menu.

how to install plugins in ozeki sms server
Figure 5 - Installing the Database plugin

Step 10 - Configure the database plugin by selecting it and clicking on Configure.

how to configure plugins in ozeki sms server
Figure 6 - Configure the Database plugin

Step 11 - Click on the Build database connection button.

how to build a database connection in ozeki sms server
Figure 7 - Building a database connection

Step 12 - Select Microsoft OLE DB Provider for ODBC Drivers.

selecting the connection provider for database connection
Figure 8 - Selecting the connection provider

Step 13 - Select the PostgreSQL30 database name.

database connection properties in ozeki sms server
Figure 9 - Selecting PostgreSQL30 as database name

Step 14 - Click on OK to finish the procedure.

More information