Database Problems
This topic introduces the different types of database problems you could run into when developing Logi Studio, as well as possible solutions.
Problems Connecting to Database
- If using non-native connections (JDBC, ODBC, OLEDB, etc.) confirm that the Connection String has a valid DataSource value.
- Confirm that the database server is started and accessible via the network.
- Check that the password is being saved in the database connection string. This must be part of the connection string to ensure that a connection is established.
- If connecting to a database via OLEDB, make sure to use the appropriate provider. For SQL Server, this is the SQL Server Provider. If you have a choice of OLEDB or ODBC providers, we recommend using the OLEDB provider for all databases. For help creating an OLEDB connection string, use the "Connection String" wizard.
-
If using a native Connection element, ensure that you're using the right
one. For example, there is a Connection.MySql element for use with MySQL
databases, Connection.SqlServer for MS SQL Server, etc.
Creating a Single Result Set From Two Databases:
- When JOINing tables, ensure that SELECT statements avoid ambiguous results by qualifying column names with table identifiers.
- A UNION of query results can be created by adding additional datalayers to elements like the Data Table element. This will combine the results into a single result set.