LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Db Query node with MS Access databases

    Employee
    Posted 08-20-2015 04:15

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

    Originally posted by: aop

    Hi,

    How should I set up the Db Query node to import data from MS Access database?

    I understand that I should set DbInterface to odbc and DbService probably to MS Access Database but where to put the path to the db file (.mdb). Or should that specific mdb file be created as a data source in MS Access Database to be able to connect?


  • 2.  RE: Db Query node with MS Access databases

    Employee
    Posted 08-20-2015 05:46

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

    Originally posted by: aop

    Got it to work! Just had to switch to 32-bit version of the odbc control panel...


  • 3.  RE: Db Query node with MS Access databases

    Employee
    Posted 08-20-2015 05:59

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

    Originally posted by: ryeh

    For others searching this topic, this is a good reference: http://www.lavastorm.com/assets/Tech...a-Database.pdf