I am attempting to connect to an Oracle 10.2.0.2 database to do an SQL Query.
I have added the JDBC adapter ojdbc14.jar and deployed it successfully.
I data services I have create a new IDBC Connector Type and I changed the following settings.
Username:
Password:
JDBCDriver: oracle.jdbc.driver.OracleDriver
ServerURL: jdbc:oracle:thin:@hostname:1521:dvlcyt
where the hostname is the name of the server and dvlcyt is the database name.
I check the status and it claims it is running. It also says tere are 0 available connections.
When I goto Workbench and select the data source to be my new oracle connection and select SQL query I get the error message "cannot create a connection to the database"
Can anyone help.
Thanks
Skip Ford