File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes how dsn can be used on deployment server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how dsn can be used on deployment server" Watch "how dsn can be used on deployment server" New topic

how dsn can be used on deployment server

sahitya kovvuri

Joined: Apr 25, 2006
Posts: 1
hi, i have tried out the DSN name for connecting to my Ms-access database .it works perpectly well in my localhost machine. But i dont know how to deploy it in deployment is this DSN setuped in we need to mention anything in our web.xml.i am using servlets .

pls suggest.
Zip Ped
Ranch Hand

Joined: Jul 26, 2005
Posts: 336
The DSN which you setup in the deployment server should map to the location of the Access Database. for eg. if your DB resides on server X, then the DSN should have the //x/DBName.mdb in the path name for the mdb file so that your DSN can access the DB. So unless you have the path name for the database file you wouldn't be able to setup the DSN. The DSN should reside on your deployment server.

I wouldn't recommend using a JDBC: ODBC bridge. It should be used only for testing and prototyping. A type 3 driver is an alternative.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: how dsn can be used on deployment server
jQuery in Action, 3rd edition