This article describes how to configure a BRCM project to connect to the SQL database without the need to create an ODBC Data Source Name (DSN), or have BRCM create it for you.
An advantage of this method is that it eliminates the need to create a DSN on each BRCM workstation.
1. Open the BRCM.cfg file available in the Standards folder of any WorkSet.In this instance go to C:\ProgramData\Bentley\BRCM CONNECT Edition\Configuration\Workspaces\BRCM Metric Example\Worksets\BRCM_EU_EN\Standards\BRCM and open BRCM.cfg file.2.The BRCM.cfg file contains a line that specifies the ODBC connection string pointed by BRCM_DB_CONNECTSTRING and requires a DSN of BRCMUser to exist and function.
3.Instead of specifying a DSN, the connect string could be specified as follows:
BRCM_DB_CONNECTSTRING=Driver={SQL Server};Server=(local)\BENTLEYECAD;Database=BRCM;UID=BRCMUser;PWD=BRCM
The ODBC driver "{SQL Server}", Server name, and Database name are specified instead of a DSN. Note -1.The driver name is enclosed in curly brackets. This is all the information necessary to connect to the database, so an ODBC DSN is not necessary.
2.When BRCM is integrated with ProjectWise, the connection string is specified in the workspace configuration block instead of the .cfg file.