SelectQuery selectQuery = SelectQueryFluentBuilder Using Īccess97ConnectionParameters access97Params = new Access97ConnectionParameters() ĭashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("Data Source 1", access97Params) After you constructed the query in the Query Builder, the text of the generated query is passed to the Data Source wizard. The Query Builder allows you to choose tables/columns and passes the resulting SQL query to the SQL String editor. Specifies the password used to connect to the MS Access database.Īfter you specify connection parameters, click Next and specify how to select data from the database.Ĭlick the Run Query Builder… button to invoke the Query Builder. Specifies the user name used to connect to the MS Access database.
To locate the database, click the ellipsis button next to the Database field. Specifies the path to the database that contains data. On the next page, select the Microsoft Access 97 data provider and specify connection parameters. On the first page of the invoked Data Source Wizard dialog, select Database and click Next. To connect to the MS Access database in the Dashboard Designer, do the following steps:Ĭ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.
0 kommentar(er)
