Skip to Content
0
Former Member
May 12, 2008 at 08:30 PM

Cannot create a connection to the database - to Oracle DB- xMII 12.0

562 Views

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