Skip to Content
Former Member
Sep 30, 2005 at 12:03 PM

JDBC connection to MS Access---Urgent



My problem is not yet solved.

I want to update the MS Access Table through XI

I have given the JDBC Driver as


and connection as


But this give sme an error

<b>Receiver Adapter v1109 for Party '', Service 'TBIT40_MSACCESS_BS':

Configured at 11:59:37 2005-09-30

Processing Error: Accessing database connection 'jdbc:odbc:XIDSN' failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Addtional information: JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant</b>

where XIDSN is my Data Source Name.

How does XI know where XIDSN is?

What should be the Connection that should be specified at the Integartion Directory of XI.

Please respond immediately..

Thanks in Advance