Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can I use a JDBC driver installed on another PC ?

 
Frank Sikuluzu
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a Windows 2000 server and a JDBC driver is installed there. On my local PC that uses Windows XP, the same kind JDBC driver can not be succesfully installed. So I am wondering --- Can I map a local drive to 2000 server's JDBC driver directory, and in my java code running on my PC, I specify the JDBC driver as the remote one installed on the 2000 server ?
Furthermore, the real database is installed on Unix box.
So, will this work ?
thanks,
frank
 
Joe Ess
Bartender
Posts: 9279
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Sikuluzu:
On my local PC that uses Windows XP, the same kind JDBC driver can not be succesfully installed.

Not that I'm questioning your skillz, but I all the JDBC drivers (Oracle, MySQL, MS SQL Server) I've worked with just needed a JAR/ZIP file in the classpath. What database and driver are you using? What problem do you have installing on XP?
 
Frank Sikuluzu
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Joe Ess:

Not that I'm questioning your skillz, but I all the JDBC drivers (Oracle, MySQL, MS SQL Server) I've worked with just needed a JAR/ZIP file in the classpath. What database and driver are you using? What problem do you have installing on XP?

Let's put aside the installation problem. I am actually interested in knowing the answer to the following scenario --- Assuming that the JDBC driver is installed on PC #1's "C:\DB_JDBC" directory. On PC #2, I don't install any JDBC driver. On PC #2, I make a network drive map to map local "F" to PC #1's "C:\DB_JDBC". Then on PC #2, I add "C:\DB_JDBC\..jar" into my classpath and then run java code on PC #2. Does this work ?
 
Joe Ess
Bartender
Posts: 9279
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Sikuluzu:

Does this work ?

That scenario is really no different than just copying the files over. If there is some reason you had to install the driver on your XP system (i.e. dll registration, registry keys, license) rather than copy it, those prerequesites would not be met on the XP box. If installation is required then this shouldn't work. Without knowing the database and the type of driver I can't really say anything other than try it and see.
 
Frank Sikuluzu
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Joe Ess:

That scenario is really no different than just copying the files over. If there is some reason you had to install the driver on your XP system (i.e. dll registration, registry keys, license) rather than copy it, those prerequesites would not be met on the XP box. If installation is required then this shouldn't work. Without knowing the database and the type of driver I can't really say anything other than try it and see.

Joe, it is jConnect5 for Sybase. So does it work ?
thanks
 
Joe Pawlak
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe you would use the F: drive instead of the C: drive when mapping PC #2's classpath
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic