Uploading data from MS Access

Uploading data from MS Access

Hi,

I have issue uploading data from Microsoft Access. I searched the forum and could not find a suitable answer.

The MS Access database is located at:  C:\temp\OperationalDatabase.accdb.

I set the configuration file database_connection_params.conf:

# $Id$

DBTYPE=msaccess
HOSTNAME=
PORT=
USERNAME=root
PASSWORD=
DBNAME=SalesDB
MDBFILENAME=C:\temp\OperationalDatabase.accdb


And I receive the following error in the logs:


2011/10/07 17:31:51 NZDT:TESTRUN :: false

2011/10/07 17:31:51 NZDT:2011-10-07 17:31:51.851 :: Connection Props are :

2011/10/07 17:31:51 NZDT:DBTYPE :: msaccess

2011/10/07 17:31:51 NZDT:HOSTNAME :: 

2011/10/07 17:31:51 NZDT:USERNAME :: root

2011/10/07 17:31:51 NZDT:PORT :: 

2011/10/07 17:31:51 NZDT:DBNAME :: SalesDB

2011/10/07 17:31:51 NZDT:MDBFILENAME :: C: empOperationalDatabase.accdb

2011/10/07 17:31:51 NZDT:CONNECTION URL :: jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb); DBQ= C: empOperationalDatabase.accdb ;UserCommitSync=Yes; Threads=3; SafeTransactions=0; PageTimeout=5; MaxScanRows=8; MaxBufferSize=2048; DriverId=281; 

2011/10/07 17:31:51 NZDT:TOTAL NUMBER OF QUERIES :: 1
2011/10/07 17:31:51 NZDT:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


2011/10/07 17:31:51 NZDT:Logging in...

2011/10/07 17:31:51 NZDT:logging into https://accounts.zoho.com
2011/10/07 17:31:53 NZDT:sucessfully loggedin 
2011/10/07 17:31:53 NZDT:Logged in successfully...


2011/10/07 17:31:53 NZDT:Exception occured while establishing connection to the database server

2011/10/07 17:31:53 NZDT:java.lang.RuntimeException: Exception occured while establishing connection to the database server
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:335)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:65)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Not a valid file name.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB.parseXMLAndImportData(ZohoReportUploadDataFromDB.java:324)
... 1 more

I noticed that the file "\" (back slash) in the file has disappeared - highlighted in red above.

Any thoughts on what is going on?

Cheers
Sunil