- Product Manual
- Introduction
- SMS technology
- Installation Guide
- Prerequisites
- Download Information
- Installation Steps
- GSM Modem Setup
- Service Provider Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- MySQL
- Oracle
- Connection strings
- Oracle 10G XE
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- Video
- Connection string builder
- Keywords
- MS SQL high speed
- Oracle High Speed
- SQL statements
- Polling technology
- Dynamic Keywords
- Dynamic SMPP parameters
- Autoreply SMS from database
- Autoreply SMS using a script
- Simple autoreply SMS
- SMS from/to file
- SMS through E-mail
- SMS via HTTP Request
- SMS via colour protocol
- Application starter SMS
- SMS Voting
- SMS from MS Outlook
- SMS from/to FTP server
- PDF Request in SMS
- SMS to WCF service
- SMS Forwarder
- RSS to SMS
- Linux
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki brings you fantastic
SMS Gateway technology. We offer SMS Server products for Windows, Linux and Android.
SMS Gateway technology. We offer SMS Server products for Windows, Linux and Android.
Ozeki NG SMS Gateway
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; |
OS Authenticated connect setting user ID to "/":
Connection string type: | Oracle |
Connection string: | Data Source=MyOracleDB;User Id=/;Password=; |
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; |
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> |
OS Authenticated connect setting user ID to "/":
Connection string type: | OleDb |
Connection string: | Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=/;Password=; |
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