18.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 specific connections attempted by the Visual LANSA for each database type is as follows:

SQL Anywhere

1.      Attempt a trusted connection

...

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

...