Skip to Content
0
Former Member
May 31, 2007 at 08:38 AM

Jdbc connection

12 Views

Hi all,

Here iam using MS access as my DB and i set the configuration part and put the file but in the JDBC adapter iam get an error:

JDBC_RECV Receiver Adapter v2808 for Party '', Service 'File_to_JDBC_RECV':

Configured at 2007-05-31 07:45:12 BST

History:

- 2007-05-31 08:21:41 BST: Error: Accessing database connection 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb': SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver

- 2007-05-31 08:21:41 BST: Processing started

- 2007-05-31 08:16:41 BST: Error: Accessing database connection 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb': SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver

- 2007-05-31 08:16:41 BST: Processing started

- 2007-05-31 08:11:41 BST: Error: Accessing database connection 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb': SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver

I gave Database connection as 'jdbc:odbc:Driver = {Microsoft Access Driver(TestDB.mdb)};DBQ= //ndainfaeas03/XIDemo/TestDB.mdb'

Any suggestions.

thanx,

krish.