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