LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: sgiasemi

Does LAE connect to Microsoft Access Database and how?
Which Node is used?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: maria.pislopez

Lavastorm Professional and Lavastorm Server Editions can connect to an Access database. Lavastorm Public extracts data from flat files only. The "Connecting to a Database" Tech Note details how to connect to an access database: http://www.lavastorm.com/assets/x/50267

Also, the Getting Started page contains some videos and Tech Notes which will help you get started with the product:

http://www.lavastorm.com/gettingstarted


Maria

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dwong80

How do you configure MS Access with JDBC? The document above only shows up to link MS Access using DB Query and ODBC.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: maria.pislopez

Hi there,

You would need to download a JDBC driver for Access. Copy it into C:\Program Files (x86)\Lavastorm\LAE 4.5\lib\java\ext (assuming C:\Program Files (x86)\Lavastorm is the install directory.) You may need to create the ext folder if it doesn't exist. You will need to restart BRE to recognize the driver. The driver documentation should give you the URL and driver information required by the JDBC node.

Maria

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dwong80

Yes, I understand that as that is standard for all JDBC connections. But has anybody actually been able to connect to MS Access via JDBC in Lavastorm graph?

I have the following configured:

DbURL: jdbcdbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=/brain/salesshare/DunsMapping.mdb
DbDriver: sun.jdbc.odbc.JdbcOdbcDriver

But I cannot get this to work. I get the following error message:

errlog:2012-06-21 13:09:42; Level: 4; Type: 0; Desc: "missing required property: null"; File: "DBNode.java"; Line: 83; Context: "connectToDB"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

Which version of the LAE are you using, and where did you get the JdbcOdbcDriver from?
If this is an enterprise installation, which version of Java are you using?

I have tried using the sun.jdbc.odbc.JdbcOdbcDriver without configuring anything in the lib/java/ext directories, since the sun.jdbc.odbc.JdbcOdbcDriver comes with the JDK, and is by default in the classpaths for the JDBC nodes.

I did this with the latest version (4.5.4, currently in development) of the LAE, and also received an error.
However, the error I received is different from the one you received.

The issue I am seeing is an "UnsupportedOperationException".
It looks like the getParameterMetadata call isn't supported by this JDBC driver, and while we are handling some of the errors that are thrown by other drivers where they don't support this operation, we aren't handling the particular exception that is thrown by the sun.jdbc.odbc.JdbcOdbcPreparedStatement class.

I have raised a bug about this in our bug tracking system (issue# 4083).

However, since the error you are receiving looks different, if you could provide any extra information I can see if there is something that can be done to workaround this issue, or if any extra information should be added to issue 4083.

If a workaround can't be found, I guess using the ODBC drivers, using the DB Store, DB Execute and DB Query nodes is probably the best way forward at the moment.

Regards,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: shaunmbg

Hi guys,

What's the current recommendation and syntax for using LAE with Access Databases? Have tried using ODBC and received the following message.

WARN: IM014:1:0:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

sqlrun is able to connect to this DSN (which points to an Access file containing "Table1" and queries the results) without issues which would suggest an LAE error. A DSN is accessible via C:\Windows\System32\odbcad32.exe and C:\Windows\SysWOW64\odbcad32.exe, which demonstrates that both the 64bit and 32bit drivers are accessible.

For what it's worth, have also attempted JDBC connectivity as previous users have, but getting errors such as the following:

ERROR: unable to connect: No suitable driver found for jdbc:C:\Users\atb\Documents\test.accdb

Running on BRE v 6.1.1.0 Build 51, the full nodes used to generate these are in the attached .brn file
Attachments:
AccessNodes.brn

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

We recently came across this issue as well. I assume you're running the 64-bit version of Lavastorm?

What seemed to work for us was:
1. Download (but don't install yet): https://www.microsoft.com/en-us/down....aspx?id=13255
2. Follow these instructions: https://knowledge.autodesk.com/suppo...ft-Office.html

Then define the DSN with C:\Windows\System32\odbcad32.exe

FYI, when using 32-bit Lavastorm, I define my DSN with C:\Windows\SysWOW64\odbcad32.exe

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Pedro Pablo

There is 2 options to connect to Microsoft Access Database:

1- Using DB Query Node:
- configure DSN (easy)

2- Using JDBC Query Node
2.1 Using the sun.jdbc.odbc.JdbcOdbcDriver, since the it comes with the JDK <8, and is by default in the classpaths for the JDBC nodes.
Node Configuration:
DBURL=jdbcdbc:Driver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=F:\\BBDD\\test.accdb
DBDriver=sun.jdbc.odbc.JdbcOdbcDriver
2.2 If you have JDK 8 the Microsoft Access Driver doesnt work. so you need download a driver of third parts, for example ucanaccess.
Download and copy the 5 jar files into "C:\Program Files (x86)\Lavastorm\LAE 4.5\lib\java\ext"
(commons-lang-2.6.jar, commons-logging-1.1.1.jar, hsqldb.jar, jackcess-2.1.3.jar, ucanaccess-3.0.3.1.jar)
Restart BRE
Node Configuration:
DBURL=jdbc:ucanaccess://C:\BBDD\test.accdb
DBDriver=sun.jdbc.odbc.JdbcOdbcDriver