Skip to Content
0
Former Member
Sep 30, 2005 at 05:53 AM

Legacy_XI_MS Access

20 Views

HI Friends

I asked this question previously but the replies given to this didn't solve my problem.

Iam trying to update the MS Access Table present in my system. I have created a DSN with name XIDSN, and a Table in that with name VendorMaster. I have the done the settings in Control Panel >Administrative Tools >Data Sources.

In XI my JDBC Driver is:

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

my Connection is

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

But my Table is not updated and I get an error in the Adapter Monitoring in RWB as:

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

Configured at 05:43:16 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>

What is the Problem?

Do I have to mention my systems IP Address and port Number in the Connection?

If so, how do I get the port number?

DO I need to mention the Username and Password? If so, how can I know them?

Thanks in Advance.........

Message was edited by: Narayana Raju Sampathirao