File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Network Adapter " Watch "Network Adapter " New topic
Author

Network Adapter

Sri Priya
Greenhorn

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.
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.


Best Regards,<br />Nagendra Prasad.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Network Adapter
 
Similar Threads
Jdev9.0.3 & Oracle9i(SQLException: Io exception: The Network Adapter could not estab)
Io exception: The Network Adapter could not establish the connection
sid in jdbc oracle connection string
datasource connection in admin console unsuccessful
Oracle JDBC connection in a servlet