LAE

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

Originally posted by: r.borst@utahconsulting.nl

Dear readers,

i�m new to lavastorm and trying to connect to a ACCDB file. i�ve created my DSN file en through excel it�s reporting data trough that connection.

after setting it up in the editor with a correct query and a fake username en password (the odbc connection does not require a password but lavastorm DB Query requires one..). The DBService is ODBC and the DbInterface is empty (doesn�t know what to fill in there..)

After this trying to run the job but i�m receiving a error:
how am i able to fix this error?

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

Originally posted by: awilliams1024

Hi,

The DbService property should be set to the name of the DSN you have created to read the .accdb file. The DbInterface property should be set to 'odbc' (without the quotes).


Note, if you are running the 64-bit version of the Lavastorm application then the driver must also be the 64-bit version.

There appears to be some common issues relating to the use of ODBC connections that depend on the version of Office you have installed (32-bit vs. 64-bit - usually the Office 32-bit version is installed).
However, the reply to the following post by 'BananaRepublic' was quite informative.

http://answers.microsoft.com/en-us/m...cd7dc30?auth=1

Since I am using the 64-bit version of Lavastrorm but do not have the Access component of Office installed I used the 64-bit version of the Access Database Engine redistributable program from the Microsoft site and configured the DSN using the 64-bit Windows 'ODBC Admin' tool.

Access Database Engine redistributable:

https://www.microsoft.com/en-us/down....aspx?id=13255

Regards,
Adrian