Hi friends, I am beginner to Oracle9i JDeveloper. I could not do the Database connection.Please help.After I open the Oracle9i JDeveloper application Step 1: I right Click the Database, to choose New Connection. Step 2:I choose connection Type as Oracle(JDBC) Step 3 river :thin ,Host Name:localhost;JDBC Port:1521;SID RCL Step 4:When I test my connection, I got following error message "IO Exception: The Network Adapter could not establish the connection" I am using MS SQL 2000 as for database and already install JDBC driver. What could be problem ? Please assist.
posted 12 years ago
Well.. From what you have described.. am I to understand that you have attempted to connect to MS SQL Server 2000 from Oracle 9i JDeveloper using the Oracle JDBC Drivers? Oracle JDBC Drivers are specific to ORacle databases. JDBC Port:1521;SID ORCL This line suggests that you have picked the default documented settings for Oracle. This will attempt to connect to an Oracle database called ORCL which is running on your machine and attempt to listen on a port 1521 ( Again specific to Oracle Database Listener Process). You would need to use the JDBC Drivers provided for MS SQL Server 2000, or try to connect to an Oracle database.