Can you post the complete stacktrace when you tried using a custom DSC. Use err.printStackTrace in your test.java
Cannot make much from the stacktrace.
- Is the Access and JBoss are running on same system
- If yes then under same user account
Access and JBoss are both running on the same server
The ODBC connection to Access is setup as a System DSN - which is supposed to be accessible to all users including NT Services.
Is there same way that JBoss wouldn't have access to the System DSN???
OK I solved this. This was only happening on the Win2K3 server - not on my local dev instance
On the server I set the JBoss service to run under the local admin account (in the Services Panel) - after a service restart the jdbc odbc connection worked fine. It must have been some permissions with the system account