Benchmark Factory allows you to create a connection to a Microsoft SQL Server database using native database provider connectivity or ODBC connectivity.
To create a SQL Server native connection
Note: For a list of operating systems that support the SQL Server native provider distributed with Benchmark Factory (native client 11.0), see https://msdn.microsoft.com/en-us/library/cc280356(v=sql.120).aspx. If your client operating system is not supported, use ODBC connectivity.
Enter the following connection information.
Native tab | |
Server Name |
Enter the name or the IP address of the server. Click the drop-down arrow to retrieve a list of servers running SQL Server that are currently active on the network. |
Authentication |
Select the type of authentication to use. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Connection Name |
Enter a name to use to identify this connection in the My Connections pane. |
Reconnect Options |
Click Reconnect Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options. |
Note: BFScripts have been enabled on the User Name and Password fields.
To create a SQL Server ODBC connection
Enter the following connection information.
ODBC tab | |
Data Source Name |
The name of the MS SQL Server ODBC data source. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Connection Name |
Enter a name to use to identify this connection in the My Connections pane. |
Reconnect Options |
Click Reconnect Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options. |
Note: BFScripts have been added to the Data Source name field in the ODBC Connection dialog. BFScripts have been enabled on the User Name and Password fields.
To create a SQL Server DB-Library connection (obsolete)
Note: For connections to SQL Server 2005 (or later), the SQL Server native connection or ODBC connection is preferred. Microsoft SQL Server is no longer including the DB-Library for database client connectivity.
Enter the following connection information.
DB-Library (Obsolete) | |
Server Name |
The name or the IP address of the server. |
Authentication |
Select the type of authentication to use. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.
Note: To review or modify an existing connection, click Edit Connections in the main toolbar. Select a connection and click .
Benchmark Factory allows you to create a native SAP database connection.
To create an SAP database connection
Enter the connection information. Review the following for additional information:
Note: BFScripts have been enabled on the User Name and Password fields.
Native | |
Server Name |
The name or the IP address of the server. |
Database |
The name of the database to which you wan to connect. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Connection Name |
Enter a name to use to identify this connection in the My Connections pane. |
Reconnect Options |
Click link to specify timeout and reconnect options. See Connection Timeout and Reconnect Options. |
Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.
Note: To review or modify a connection, click Edit Connections in the main toolbar. Select a connection and click .
Benchmark Factory allows you to create an ODBC connection to a MySQL database.
To create a MySQL connection
Enter the connection information. Review the following for additional information:
Note: BFScripts have been added to the Data Source name field in the ODBC Connection dialog. BFScripts have been enabled on the User Name and Password fields.
ODBC | |
Data Source Name |
The name of the MySQL ODBC data source. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Connection Name |
Enter a name to use to identify this connection in the My Connections pane. |
Reconnect Options |
Click link to specify timeout and reconnect options. See Connection Timeout and Reconnect Options. |
Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.
Note: To review or modify a connection, click Edit Connections in the main toolbar. Select a connection and click .
Benchmark Factory supports almost all databases that you can connect to using an ODBC 3.0 or later driver. Create an ODBC connection to access these databases.
To create an ODBC connection
Enter the connection information. Review the following for additional information:
Note: BFScripts have been added to the Data Source name field in the ODBC Connection dialog. BFScripts have been enabled on the User Name and Password fields.
ODBC | |
Data Source Name |
The name of the ODBC data source. |
User Name |
Enter the user name to use for this connection. |
Password |
Enter the password associated with the user name. |
Connection Name |
Enter a name to use to identify this connection in the My Connections pane. |
Reconnect Options |
Click link to specify timeout and reconnect options. See Connection Timeout and Reconnect Options. |
Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.
Note: To review or modify a connection, click Edit Connections in the main toolbar. Select a connection and click .
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center