Configuring Bold BI hosted on IIS for 64-bit ODBC drivers

When Bold BI is hosted on Internet Information Services (IIS), it typically operates in a 32-bit mode by default. This configuration means that only 32-bit System DSN (Data Source Name) values are listed in the Bold BI ODBC connector. However, there are scenarios where you might need to connect to 64-bit System DSN values. This article provides a step-by-step guide to configure Bold BI to list 64-bit System DSN values.

Steps to Connect 64-bit System DSN Values

Step 1: Open IIS Manager

1. Press Start.
2. Type Run and press Enter.
3. In the Run dialog box, type inetmgr and press Enter.
   

Step 2: Navigate to Bold BI Application Site

1. In the IIS Manager, use the navigation pane on the left.
2. Browse to Sites.
3. Select your Bold BI application site, typically named BoldBIOnPremiseEdition.
   

Step 3: Stop the Bold BI Application Site

1. Right-click the Bold BI application site (BoldBIOnPremiseEdition).
2. Select Manage Website > Stop.
   

Step 4: Stop the Bold BI Application Pool

1. Select Application Pools in the IIS Manager.
2. Select and right-click BoldBI.
3. Click Stop.
   

Step 5: Stop Other Application Pools

Repeat Step 4 for the remaining application pools such as BoldBIDesigner, BoldBIJobs, and BoldUMS.

Step 6: Modify Application Pool Settings

1. Select the application pool BoldBI.
2. Click Advanced Settings.
   

Step 7: Disable 32-bit Applications

1. In the Advanced Settings window, find the setting Enable 32-bit Applications.
2. Set this value to False.
   

Step 8: Apply the Same Setting to Other Application Pools

Repeat Step 7 for the other application pools such as BoldBIDesigner, BoldBIJobs, and BoldUMS.

Step 9: Restart the Site and Application Pools

1. Restart the site BoldBIOnPremiseEdition.
2. Restart all other Bold BI application pools:
   • BoldBI
   • BoldBIDesigner
   • BoldBIJobs
   • BoldUMS

Step 10: Verify 64-bit System DSN Values

1. Once the services are restarted, go to the ODBC data source in Bold BI.
2. Verify that the System DSN 64-bit values are now listed.

By following these steps, you can configure Bold BI to list and connect to 64-bit System DSN values, ensuring that your data sources are correctly recognized and utilized by the application.

By ensuring that the application pools are correctly configured to disable 32-bit applications, you can seamlessly integrate 64-bit data sources into your Bold BI environment.

Additional References

• ODBC in Bold BI