...
If the connection has not been established, you can correct the connection string manually:Steps for assembling the
| Expand |
|---|
| title | Scenario of connection string assembling |
|---|
|
- Go to the Provider tab in the Data Link Properties window
- Select Microsoft OLE DB Provider for ODBC Drivers
- On the Connection tab, select Use connection string and click Build...
- In the Select Data Source window, click New next to the empty file name
- Select PostgreSQL ODBC Driver (Unicode). If there is no such option, then select PostgreSQL Unicode. Click Next.
- Fill in an arbitrary data source file name. This file will not be used when working. Click Next and Finish.
- The driver setup window will appear:
- Enter your login and password. You can use the data for the postgres superuser.
- Leave the Server and Port fields empty and the default value: localhost:5432
- If you leave the Database field blank, then postgres will be used as the default database. Therefore, it is better to specify the name of the database that you created to work with r_keeper.
- Click OK.
- The Data Link Properties window will reopen. Check the connection again and click OK.
|
- Add a link to the created connection to the database in the report server: Options > OLAP reports > Reporting Servers.
On the same tab, specify the user and password.
- Make sure the export works. Go to Service > Data Export > Export to Other Database.
Enter the database, password, and username and click Test.
The rest of the report server settings are standard. - Write UseSQL = 1 in the rk7srv.INI file and restart the reference server.
The connection is established. Now you can work, for example, with cubic reports.
