jasperserver 5.5 can not connect ms access 2003

[beesakayawong]

I use iReport 5.1 and Jasperserver 5.5. But I have some problem to connect my database -> MS Access 2003. In iReport I connect it by use odbc connection and it's successful, I can create report but when I deploy my report to jasperserver, my connection failed my setting is

JDBC DRIVER  : JDBC-ODBC Bridge (sun.jdbc.odbc.JdbcOdbcDriver)

URL : jdbc:odbc:myData

and the error is [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Pls. help me to solve this problem.

Thank you very much

 

[ghemmag81]

Hi,

I have the same error and I need to connect jasperserver with MS Access. Could you help us?

Thanks in advance,

Gemma