Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC Driver

 
Ambrose Tati
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to do some database access from within Java. Can anybody please tell me where to download the jdbc driver I need?
My environment is:
JDK1.3
Windows98
Personal Oracle7
Is there an Personal Oracle7 jdbc driver for Win98?
Many thanks in advance.
Ambrose
 
deepak mag
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Ambrose Tati:
I am trying to do some database access from within Java. Can anybody please tell me where to download the jdbc driver I need?
My environment is:
JDK1.3
Windows98
Personal Oracle7
Is there an Personal Oracle7 jdbc driver for Win98?
Many thanks in advance.
Ambrose


Hi,
You don't need any drivers. You can use normal JDBC connection to establish the link.
Follow the folling steps
1. Create a DSN (my_DSN) on your machine.
2. Use this code to create connection
dbCon = DriverManager.getConnection("jdbc dbc:my_DSN", "username", "pass");
3. Use "sun.jdbc.odbc.JdbcOdbcDriver"
It work for me. I have been using it from quite some time.
Good luck
DM
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!