To connect ibaAnalyzer to an SQL server, you do not need to make any special settings on the database side.
Note |
|
|---|---|
 |
ibaAnalyzer v8.0.0 or higher no longer supports any database connections via ODBC. Databases that have been configured in older PDO files via ODBC must be converted to the actual database provider in ibaAnalyzer and directly connected to the database. |
From the Data source drop-down list, select Create database connection. In the Database connection dialog box, select the required database provider under Database type.
To edit an existing connection, select the connection from the Data source drop-down list. Then click on the editing button.
Enter the other basic settings, see Basic settings for SQL Server.
You can also use the advanced settings to configure a failover partner, see Advanced settings for SQL Server.
Connection name
This line contains the name of the database connection. The name is automatically formed and entered according to the scheme username@database as soon as you have filled in the fields below. Alternatively, you can enter and overwrite the connection name manually.
Timeout
Here you can specify a value for the timeout in seconds for establishing the connection. If the time set here is exceeded, ibaAnalyzer aborts the connection attempt and displays an error message.
Note that once the connection is made, each command sent to the database has an additional timeout, which can be set by the application that makes use of it. There is no generic configuration for the command timeout.
<Test connection>
ibaAnalyzer checks the access to the selected database on the set DB server. If the connection is successful, the message includes the version of the database.