Setting up Connection to MS Access DB on Sunone App Server 7

Hi,

I need some help on setting up a connection to a Microsoft Access DB on a sunone app server 7. The DSN for the access DB is given as Test.

Would I have to make changes to the server.xml, or do I need to make changes to the web.xml or both?

I would be using this for setting up the connection object in the code :

conn = DriverManager.getConnection("jdbc:odbc:Test");

Can you please drop some examples for setting these up?

Thanks a lot.

[483 byte] By [java_jamboreea] at [2007-10-3 0:36:06]
# 1
Would prefer the connection to be available by setting it up only in the server.xml...Would it be possible to do this by setting it up under the Resources tag? If yes then please give examples too..
java_jamboreea at 2007-7-14 17:29:51 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...