• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Can I use a JDBC driver installed on another PC ?

 
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 9626
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 9626
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I believe you would use the F: drive instead of the C: drive when mapping PC #2's classpath
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic