Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes getting started Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting started " Watch "getting started " New topic
Author

getting started

Vladimir Kositsky
Ranch Hand

Joined: Nov 03, 2000
Posts: 116
Hi!
I am trying to make initial set up for my system(Windows98,SQL 7, JDK 1.2.2)to run sample JDBC programs.
I need advise how set class path( i've got ClassNotFoundException) and i suggest i have some problems with JDBC-ODBC bridge, 'couse i've got SQLException as well
How can i make sure that this driver is installed? I was looking for it in Control Panel -> ODBC, it does not appear there.
Thanks in advance
venu patlori
Greenhorn

Joined: Jan 27, 2001
Posts: 12
hi! Vladimir
go the windows autoexec.bat file ,open the file and set the classpath and path in this way.check out for the jdk version you have.
set path=c:\jdk1.3\bin;.;c:\weblogic\bin;c:\windows\command;%path%
set classpath=c:\jdk1.3\lib\tools.jar;.;c:\weblogic\lib\weblogicaux.jar;c:\weblogic\lib\weblogicbeans.jar;%classpath%
you must create a dsn in odbc for the particular database you use. and use the same in you java code along with the driver.
Vladimir Kositsky
Ranch Hand

Joined: Nov 03, 2000
Posts: 116
Hi Venu,
thank for reply!
Could you give me more details about dsn?
Should i use MS Access?
Vladimir
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting started
 
Similar Threads
Type 4 JDBC Driver for MS_Access
JDBC-ODBC with Oracle
JDBC/ODBC MS Access connection
Invalid Cursor State
set up of CLASSPATH on jdk1.3