Hi guys,
I have a problem with a JDBC connection to a MS Access DB
I am using the JDBC driver "sun.jdbc.odbc.JdbcOdbcDriver". And when I have my mdb file on the XI server directly and use connection parameter "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//<xiserver>/folder/TESTXI.mdb" I can write data into the DB without problems.
But when I have my Access mdb file on a different server which is not the XI Server I get the error "Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//<IP>/Share/TESTXI.mdb': SQLException: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1df0 Thread 0x4b0 DBC 0x887502c Jet'.'"
Do you have any ideas?
I would be grateful for every information.
Thanks
sven
Hi Sven,
Have u gone through this weblog..
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
Thanks and Regards,
Sridhar
Hi,
The directory specified must be accessible by the service user of the Adapter engine, with appropriate read/write permissions..The same applies to any adapter whether it is a File or JDBC.Actually in the first case your directory is accessible by service user whereas in the second case its not.
Regards,
Sudheer.
Hi,
Please refer to this link for that error.
Regards,
Sudheer.
Hi Sven,
Just check if you are able to connect to this IP from the XI server with the user id and password. I'm not sure how but I think you will probably have to use the run command (telnet IP address) and try to ping and see the connection between these two servers. Because, I think that only when this connection is successful, you will be able to access the DB.
Regards,
Sushumna
Add a comment