how to trace sql anywhere client to database

HOW TO TRACE SQL ANYWHERE CLIENT TO DATABASE HOW TO

Use the AsaConnectionParameters.Hostname property to specify the name of the server to which the connection should be established.

Create the AsaConnectionParameters class object and specify the following properties: Specify connection parameters for the SAP SQL Anywhere database. To create a data source that uses a connection to the SAP SQL Anywhere database, create an instance of the DashboardSqlDataSource class and follow the steps below: On the final page, you can optionally add query parameters and preview data. Then click Next to specify the parameter settings. Select the Stored Procedure option to select one of the stored procedures from the database. If you apply filtering or use query parameters, click Next to specify the parameter settings. Subsequently, the text of the generated query returns to the Data Source wizard. The Query Builder allows you to choose the tables/columns and passes the resulting SQL query to the SQL String editor. Select the Query option and click Run Query Builder… to invoke the Query Builder. You can choose from the following options:

HOW TO TRACE SQL ANYWHERE CLIENT TO DATABASE HOW TO

Specifies the password used to connect to the SAP SQL Anywhere database.Ĭlick Next and specify how to select data from the database. Specifies the user name used to connect to the SAP SQL Anywhere database. To locate the database, click the ellipsis button next to the Database field. Specifies the path to the database that contains data. If you selected the Embedded Server type, the Data Source wizard displays the following connection settings: Specifies the name of the database that contains data. Specifies the password used to authenticate to the SAP SQL Anywhere server. Specifies the user name used to authenticate to the SAP SQL Anywhere server.

Specifies the name of the SAP SQL Anywhere server to which the connection should be established. Specifies the hostname of the SAP SQL Anywhere server to which the connection should be established. If you selected the Server, the Data Source wizard displays the following connection settings: On the next page, select the SAP Sybase SQL Anywhere data provider and choose the Server type. On the first page of the invoked Data Source Wizard dialog, select Database and click Next. To connect to an SAP Sybase SQL Anywhere database in the Dashboard Designer, follow the steps below:Ĭlick the New Data Source button in the Data Source ribbon tab. Create a Data Source in the Data Source Wizard

For information on data providers, refer to the Data Sources article. The appropriate data provider must be installed on the client machine.

How to trace sql anywhere client to database