Configuring database node to connect to remote databases using the LAE Desktop

Please use the attached document for instructions on how to configure the DB Query node to connect to SQL Server, MS Access and Oracle databases and how to connect to a database using JDBC with the JDBC Query node. 

If you have remaining questions or concerns after reading the document then you can raise a support ticket and our support team will be happy to help.

This document should be used on LAE Desktop installations only. For information on how to configure the JDBC node to connect to remote databases on the Server version, please follow this link: Server Connecting to Remote Database

TROUBLESHOOTING:

 The JDBC node has several processes that it must go through before a connection will succeed.  Each step may need its own troubleshooting.

• Locate and open the JAR driver file(s)
• Find the requested DbDriver within the JAR file(s)
• Establish a TCP/IP connection to the server
• Establish a Database connection on the server
• Log into the server
• Send the Query
• Receive the response back from the database

We strongly recommend that you read the message after every failure. There are 5 or 6 steps to the process of performing a JDBC Query and after you pass each step, you may get a NEW error on the next step of the process, such as:

- locating the jdbc driver
- locating the server
- finding the right port on the server
- logging in with username xxxx
- logging in with password xxxx
- properly formatted SQL query
- do the requested tables exist
- do the requested columns exist

If you still cannot establish a connection, we recommend you seek help from you Database Administrator and / or your Network Administrator.