File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Network Adapter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Network Adapter " Watch "Network Adapter " New topic

Network Adapter

Sri Priya

Joined: Jul 14, 2003
Posts: 2
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.
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
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.
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.

Best Regards,<br />Nagendra Prasad.
I agree. Here's the link:
subject: Network Adapter
It's not a secret anymore!