Oracle Connection Test
This test is to ensure that your application can connect to an Oracle database.
Please provide the Oracle net service Name, schema name, whether to use Windows Authentication, user name, password and the name of a table.
Server Name
Oracle Net Service Name.
Schema Name
If schema name is a reserved word or contains spaces, it must be enclosed in quotes and is case-sensitive.
Trusted Connection
Windows Authentication
Oracle user name/password
User Name
When using Oracle user name/password.
Password
When using Oracle user name/password.
Table Name
(e.g., Products). First 5 rows will be displayed from this table. If table name is a reserved word or contains spaces, it must be enclosed in quotes and is case-sensitive.
Test Successful?
Errors? Is it one of these?
OraOLEDB.Oracle' provider is not registered
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
ORA-12154: TNS:could not resolve service name
Can't find your error message?
Lookup additional error messages...
Search our knowledge base:
Still having problems?
Submit a Support Case
. Please include a screen shot of the error message.