Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

Oracle Contents | SearchOracle 10G XE

Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > Oracle > Connection strings

 


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.

Connection strings for Oracle

This page lists alternative connection strings you can use with Oracle database.

.NET Oracle provider.

For Standard security:

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

For a Trusted connection:

OS Authenticated connect setting user ID to "/":

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

OS Authenticated connect using OSAuthent:

Connection string type:Oracle
Connection string:Data Source=MyOracleDB;OSAuthent=1;

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

ODBC Driver for Oracle

For the current Oracle ODBC driver from Microsoft:

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

For the older Oracle 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 (from Oracle).

For Standard security:

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB; User Id=myUsername;Password=myPassword;/td>

For a Trusted connection:

OS Authenticated connect setting user ID to "/":

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=;

OS Authenticated connect using OSAuthent:

Connection string type:OleDb
Connection string:Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;

Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

More information





Next page: Oracle 10G XE
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > Oracle > Connection strings
Legal | Privacy | Terms of use | 2511
18.213.192.104 | 92.118.27.157 | Login