• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

JDBC-ODBC with Oracle

 
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Can I use JDBC-ODBC bridge with Oracle 8i database ? How do I know if it is already present on my Windows 98 computer or I've to install it ?
When I try to set USER DSN in the Control Panel, I see 3 Drivers:
1)Microsoft ODBC Driver for Oracle
2)Microsoft ODBC for Oracle
3)Oracle ODBC Driver
Which of these should I use ?
Is there any other setting I need to do before I can run my JDBC program ?
Regards,
Vishakha
 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you've installed Java 1.2 or higher on the PC then you have the JDBC/ODBC bridge.
As for which ODBC driver you should use I would suggest that you try them all and see which one works for you. I've had success with the Oracle ODBC driver.
Is there any reason that you don't want to use the type 4 (pure Java) driver supplied with Oracle?
Col
 
Vishakha Ahuja
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks col. I'm not sure how to use type 4. The book I'm referring to uses JDBC-ODBC with MS Access, so I thought of trying with Oracle also.
I'll try type 4 if i knew how to connect ?
 
Col Bell
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The readme that comes with it is terse but does explain whats needed.
You can get the latest drivers from here
Basically you need to put the classes12.zip file in your classpath.
The driver name you need is "oracle.jdbc.driver.OracleDriver".
The URL will be of the form jdbc racle:thin:@<server>:<port>:<database_name>
where you need to replace <server> with the name of the Oracle server, <port> with the port number of the listener (usually 1521) and <database_name> is the SID of the database.
Col
 
Col Bell
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That should have been "the URL will be of the form"
 
I didn't say it. I'm just telling you what this tiny ad said.
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic