This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how dsn can be used on deployment server

 
sahitya kovvuri
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 server.how is this DSN setuped in server.do we need to mention anything in our web.xml.i am using servlets .

pls suggest.
 
Zip Ped
Ranch Hand
Posts: 336
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic