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