17.6 Database Connections
LANSA and SQL Server - Configuration Options
The Visual LANSA database connection has been enhanced to support windows authentication for Oracle and SQL Anywhere as well as continuing to support Microsoft SQL Server windows authentication.
The database connections also support the User ID and password being specified in the ODBC DSN, if supported by the database so that they are not stored in the Windows registry by Visual LANSA.
The default connection is to use the existing connection information stored in the Windows registry by Visual LANSA. This establishes a connection exactly as previously and is for backward compatibility.
The specific connections attempted by the Visual LANSA for each database type is as follows:
SQL Anywhere
1. Attempt a trusted connection
2. Connect just using the DSN. This presumes that the ODBC DSN contains all the connection information required.
3. Attempt to connect using DBA/SQL. This will be the most common connection made with new installations.
4. If connection to load Other Files, prompt for more connection information, otherwise display an error that ODBC DSN needs to be re-configured and provide an option to start the ODBC Administrator. Either connection is successful or Visual LANSA exits.
Microsoft SQL Server
1. Connect just using the DSN. This presumes that the ODBC DSN contains all the connection information required.
2. Prompt for more connection information. Either connection is successful or Visual LANSA exits.
Oracle
1. Attempt a trusted connection
2. Connect just using the DSN. This presumes that the ODBC DSN contains all the connection information required.
3. Attempt to connect using DBA/SQL. This will be the most common connection made with new installations.
4. Prompt for more connection information. Either connection is successful or Visual LANSA exits
Refer also to LANSA and SQL Server - Configuration Options in the Tips and Techniques on the LANSA web site.