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

JDBC connection to MS Access---Urgent

30 Views

Hi

My problem is not yet solved.

I want to update the MS Access Table through XI

I have given the JDBC Driver as

<b>sun.jdbc.odbc.JdbcOdbcDriver</b>

and connection as

<b>jdbc:odbc:XIDSN</b>

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