web stats
MS Access Connection - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2013, 07:43 AM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default MS Access Connection

I'm trying to connect Mirth to a Microsoft Access database. We are trying to validate the software and having problems connecting. We would need an audit trail so we would eventually be needing to get the supported version but we need proof of concept first. If there is any extra information that you can give me in connecting to the MS Access database using the jdbcdbc driver I would appreciate it. I get an error every time I try to "get tables".
Reply With Quote
  #2  
Old 10-08-2013, 09:34 AM
brentm brentm is offline
Mirth Employee
 
Join Date: Jan 2012
Posts: 85
brentm is on a distinguished road
Default

Can you post the full error message?

Also what version of Mirth Connect are you using?

Thanks
Reply With Quote
  #3  
Old 10-08-2013, 12:08 PM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default

Mirth version: 2.2.3.6825

The exact error: "Could not retrieve database metadata. Please ensure that your driver, URL, username, and password are correct."
Reply With Quote
  #4  
Old 10-09-2013, 10:07 AM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default

Basically I am having issues with Mirth's connection to the MS Access ODBC driver. I've tried looking through other posts and documentation but I would like a little further verification on the fields.

The Username and Password. Are these for the database, the driver, or Mirth?

The URL: Can I get an example other than the template? Is it just the name of the DSN? I've tried many different formats of the URL to get it to connect.

Thanks,
John
Reply With Quote
  #5  
Old 10-09-2013, 10:11 AM
cory_cole cory_cole is online now
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,361
cory_cole is on a distinguished road
Default

jdbcostgresql://localhost:5432/mirthdb
Reply With Quote
  #6  
Old 10-09-2013, 10:33 AM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default

Quote:
Originally Posted by cory_cole View Post
jdbcostgresql://localhost:5432/mirthdb
Is it the same for the jdbc-odbc bridge?
Reply With Quote
  #7  
Old 10-09-2013, 11:01 AM
wayneh wayneh is offline
OBX.3 Kenobi
 
Join Date: May 2012
Posts: 102
wayneh is on a distinguished road
Default

Are you trying to make your connection in a transformer? If so, you can create the connection with the following

var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('sun.jdbc.odbc.JdbcOdbcDriver','jdbc:odbc:DSN','u sername','password');

dbConn.close();

Replace DSN with your data source name

Perhaps you can create an MDB without a password and try to connect to that first. Also what string formats have you tried?

Edit: Take a look at this and see if it helps http://www.selikoff.net/2011/07/26/c...n-64-bit-java/

Last edited by wayneh; 10-09-2013 at 11:09 AM.
Reply With Quote
  #8  
Old 10-09-2013, 01:48 PM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default

I read that article and decided to move everything to 32 bit to try and eliminate x86/x64 issues. I've tried many different URLs and this one has gotten me something more interesting in the error log:

URL
Code:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:/Users/[myname]/documents/Database1.accdb
error
Code:
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
Now I should note the test database that I'm trying to connect to is a .accdb but the system I'm wanting to connect to is a .mdb. But getting connected to one will get me progress.
Reply With Quote
  #9  
Old 10-09-2013, 02:25 PM
wayneh wayneh is offline
OBX.3 Kenobi
 
Join Date: May 2012
Posts: 102
wayneh is on a distinguished road
Default

Are you getting the error when making the connection, or running a query? With the "Optional feature not implemented" error, its possible the connection was made but a particular query you are running is throwing that error.
Reply With Quote
  #10  
Old 10-10-2013, 05:54 AM
jsnow jsnow is offline
Mirth Newb
 
Join Date: Oct 2013
Posts: 6
jsnow is on a distinguished road
Default

Quote:
Originally Posted by wayneh View Post
Are you getting the error when making the connection, or running a query? With the "Optional feature not implemented" error, its possible the connection was made but a particular query you are running is throwing that error.
I was just hitting "Get Tables" on the SQL Creation window.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 05:07 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation