Connecting to Mircrosoft Access ODBC

summer

• July 02, 2019 00:00

• Answered

Follow

Hi Team,

When I am trying to connect to the Microsoft Access ODBC, I am getting below error.

I have Microsoft Access Driver 32/64bit installed.

When I replace database_file in [jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=database_file] with absolute path, it is giving me an error as below:


com.cloveretl.server.api.wsjdbc.generated.SqlFault_Exception: Cannot create JDBC driver 'Microsoft Access ODBC'. Cannot find class.


Can you please advise what is the best way to solve this?


Thanks,
Summer

• 

  summer

  • July 02, 2019 23:47

  0

  Comment actions Permalink

  I have connected successfully to Access using Microsoft Access (Not ODBC). However, in the DBInput gives me an error when I am using below query:
  
  [Select name from MsysObjects]
  
  Component [DBInputTable:DBINPUT_TABLE3] finished with status ERROR. (Out0: 0 recs)
  UCAExc:::4.0.2 user lacks privilege or object not found: MSYSOBJECTS
  
  
  This query functions well in ms access itself.
  
  Can anyone please help?
  
  Thanks,
  
  Summer
• 

  darvehng

  • July 03, 2019 16:20

  0

  Comment actions Permalink

  Hi Summer,
  
  Thank you for your inquiry. Based on the error message, it appears the access file has some credentials that you may need to set in the connection. If you're certain the access file isn't protected by user credentials, then kindly try using "Admin" for username and leave the password blank. If this doesn't work, then we would need to see the whole run log, as well as the connection dialog box. You can either print screen the connection dialog box or send us an externalized connection, whichever you prefer. Below is a link to the documentation on how to externalize database connections just in case. We look forward to hearing from you.
  
  https://doc.cloverdx.com/latest/designe ... onnections
  
  Best Regards,
• 

  andras.csore

  • July 03, 2019 18:02

  0

  Comment actions Permalink

  Some hint/tip (from the past).
  1.) As i remember, may (just may) you don't need to have rights for the sysobject.
  (but you cant browse tables, forms may not work at all, etc.)
  But may if you type the sql select or whatever manually (no table browsing) may works.
  2.) Open the file in MSAccess, and some Security/Tools menu point you can add for your user the rights.
  
  Regards: Andras,
• 

  summer

  • July 04, 2019 23:30

  0

  Comment actions Permalink

  Hi,
  
  Thank you for your quick reply.
  
  Please see the attached for the information required.
  
  Hope to hear back from you soon,
  
  Thanks,
  
  Summer

  • Error detail3.png
  • Error detail1.png
  • Error detail2.png
• 

  summer

  • July 04, 2019 23:33

  0

  Comment actions Permalink

  Hi,
  
  Here are more information you may require.
  
  Thanks,
  
  Summer

  • Graph and error.png
  • Query.png
  • Connection.png
• 

  summer

  • July 08, 2019 22:49

  0

  Comment actions Permalink

  Some hint/tip (from the past).
  1.) As i remember, may (just may) you don't need to have rights for the sysobject.
  (but you cant browse tables, forms may not work at all, etc.)
  But may if you type the sql select or whatever manually (no table browsing) may works.
  2.) Open the file in MSAccess, and some Security/Tools menu point you can add for your user the rights.
  
  Regards: Andras,

  
  
  Thank you for your reply Andras,
  
  1.)If I type the query in MS Access itself, it worked fine.
  2.)Just as mentioned in pointed one, I can access MsysObjects without any issue in MS Access. The error happens with Clover/UcanAccess.
  
  Regards,
  
  Summer
• 

  darvehng

  • July 29, 2019 14:39

  0

  Comment actions Permalink

  Hi,
  
  Can you copy the full error log and paste it into a text document and attach it to your response? Also, what was the outcome of using "Admin" as username and leaving the password blank? We look forward to hearing from you.
  
  Best,

Please sign in to leave a comment.