OZEKI OZEKI Phone System 10
Customizable PBX for Windows

Ozeki Phone System 10

How to setup different database servers

Different database servers require various configurations in Ozeki Phone System. When you install an SQL API, you need to select a database connection type and provide a connection string. In this guide you will see different connection types and connection strings related to several database servers.

Microsoft SQL Server

Connection type:

OleDb

Connection strings:

Provider=SQLNCLI;Server=127.0.0.1;Database=OzekiPBX;UID=ozekiuser;PWD=ozekipass;

Provider=SQLOLEDB.1;Data Source=YourComputerName;Persist Security Info=False;Integrated Security=SSPI;User ID=YourUserName;Password=YourPassword;Initial Catalog=CreatedDatabaseName

Microsoft SQL Express

Connection type:

OleDb

Connection strings:

Provider=SQLNCLI;Server=.SQLEXPRESS;User ID=ozekiuser;password=ozekipass;Database=OzekiPBX;Persist Security Info=True

Microsoft Access

Connection type:

OleDb

Connection strings:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=OzekiPBX;Persist Security Info=False

Standard security:

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:mydatabase.mdb;Uid=Admin;Pwd=;

Workgroup:

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:mydatabase.mdb;SystemDB=C:mydatabase.mdw;

Exclusive:

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=;

Admin: To enable certain pragmatically admin functions such as CREATE USER, CREATE GROUP, ADD USER, GRANT, REVOKE and DEFAULTS (when making CREATE TABLE statements) use this connection string.

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:mydatabase.mdb;Uid=Admin;Pwd=;ExtendedAnsiSQL=1;

Locale identifier: Use this one to specify the locale identifier which can help with non-US formatted dates or special character sets. The example bellow uses the en-gb locale identifier (2057)

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:mydatabase.mdb;Locale Identifier=2057;Uid=Admin;Pwd=;

Oracle

Connection type:

OleDb

Connection strings:

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=;

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

MySQL

Connection type:

Odbc

Connection strings:

Driver={MySQL ODBC 5.2 UNICODE Driver};Server=127.0.0.1;Database=OzekiPBX;User=ozeki;Password=qwe123;Option=4;

You can download the latest Odbc driver from the following web page: https://dev.mysql.com/downloads/connector/odbc/.

PostgreSQL

Connection type:

Odbc

Connection strings:

DRIVER={PostgreSQL};SERVER=YourServerIP;port=5432;DATABASE=YourDatabaseName;UID=YourUsername; PWD=YourPassword

Sybase (SQL Anywhere)

Connection type:

OleDB

Connection strings:

Provider=ASAProv.90;UID=MyUsername;PWD=MyPassword;DatabaseFile= DatabaseFileLocationOnYourComputer.db; EngineName=Yourdbenginename;Start= YourDatabaseBinaryLocation.exe -c 32M;AutoStop=Yes

DB2

Connection type:

OleDB

Connection strings:

If you use a TCP/IP connection:

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=130.120.110.001; Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;Default Schema=MySchema; User ID=MyUsername;Password=MyPassword;

If you use APPC connection:

Provider=DB2OLEDB;APPC Local LU Alias=MyLocalLUAlias;APPC Remote LU Alias=MyRemoteLUAlias; Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;Default Schema=MySchema; User ID=MyUsername;Password=MyPassword;

Informix

Connection type:

OleDB

Connection strings:

Provider=Ifxoledbc.2;password=pppppp;User ID=uuuuuu;Data Source=opcrts@alpha;Persist Security Info=true

Amazon SimpleDB

Connection type:

Odbc

Connection strings:

Access Key=your_access_key;Secret Access Key=your_secret_access_key

Filemaker / Filemaker Pro

Connection type:

Odbc

Connection strings:

Driver=FileMaker Pro;AllAsText=0;ApplicationUsingThreads=1;FetchChunkSize=100;FileOpenCache=0; IntlSort=0;MaxTextlength=255;ServerAddress=127.0.0.1;TranslationOption=0;UseRemoteConnection=1;

FoxPro

Connection type:

Odbc

Connection strings:

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:myvfpdb.dbc;Exclusive=No;NULL=NO; Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;

More information

Installing MySQL ODBC | OZML