Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC, ODBC, Drivers, etc.

 
Chris Funkhouser
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've been using the jdbc dbc bridge driver to create an application that connects to an Access database. I'm deploying it using Web Start.
When I run it on my local machine, it works fine. When I try it on a different machine, it looks for the DSN on that machine and doesn't find it.
What I've read in this forum is that I need to get a different driver specifically for Access (or perhaps SQL Server, if I decide to port my data there). But I'm clueless about drivers. Can someone help me out with some step-by-step instructions about what type of driver to get, what it might cost, how to install it, etc.?
Thanks,
Chris
 
Junilu Lacar
Bartender
Posts: 7486
50
Android Eclipse IDE IntelliJ IDE Java Linux Mac Scala Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chris,
No special drivers are needed: the jdbc dbc driver should work fine. What you probably need to do is to configure an ODBC Data Source Name (DSN) on the other machine (the one that you say the application is not working on). The ODBC Data Source Administrator is in the Windows Control Panel.
Junilu
[This message has been edited by JUNILU LACAR (edited December 15, 2001).]
 
karl koch
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i never used odbc.....but make sure you are not connecting to localhost on the other machine. use ip/name of the server.

k
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic