Home
RECOMMENDED FOR YOU:
SMS Gateway software
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
Ozeki 10 SMS Gateway

Connection strings for Oracle

You can use these alternative connection strings to connect to your Oracle Database. These are useful if you have a connection problem or if you use another driver for example ODBC or OLE DB.

.NET Oracle connection providers

Standard Security:

Connection string type:Oracle
Connection string:Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;

Trusted Connection:

  • OS Authenticated connection ('Id=/'):
    Connection string type:Oracle
    Connection string:Data Source=MyOracleDB;User Id=/;Password=;

  • OS Authenticated connection using OSAuthent:
    Connection string type:Oracle
    Connection string:Data Source=MyOracleDB;OSAuthent=1;

ODBC Driver for Oracle

Using the current ODBC driver from Microsoft:

Connection string type:ODBC
Connection string:Driver={Microsoft ODBC for Oracle};Server=OracleServer.world; Uid=MyUsername;Pwd=MyPassword;

Using the older ODBC driver from Microsoft:

Connection string type:ODBC
Connection string:Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;

OLE DB Provider for Oracle

Standard Security:

Connection string type:OLE DB
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;

Trusted Connection:

  • OS Authenticated connection ('Id=/'):
    Connection string type:OLE DB
    Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=;

  • OS Authenticated connection using OSAuthent:
    Connection string type:OLE DB
    Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

Info: Please provide the 'Data Source=' a Net8 name which uses a standard naming method like Local Naming or Oracle Names. Local Naming is the alias in the tnsnames.ora file. The Oracle Name is the Net8 Service name.

More information