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