Database Connection String Locations

Jacob_Eastman

If you are moving/changing databases, there are a number of locations that contain connection strings that must be updated. Note the below strings contain sample data.

 

Registry Key Location

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database

• Connection = ODBC;DSN=bpmsql;UID=metastorm;PWD=metastorm;

Note that this references a 32-bit DSN. On 64-bit systems, use C:\WINDOWS\SYSWOW64\odbad32.exe to manage your 32-bit DSNs (the default ODBC Admin tool in Control Panel points to the 64-bit version)

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database Connectors\Oracle DBC

• Connection = Provider=OraOLEDB.Oracle.1;Data Source=bpmoracle;User Id=metastorm;Password=metastorm;FetchSize=100;CacheType=Memory;PLSQLRSet=1;OLEDB.NET=True
• DotNetConnection = Data Source=bpmoracle;User ID=metastorm;Password=metastorm;

or

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database Connectors\SQL Server DBC

• Connection = Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=BPM9;User ID=metastorm;Password=metastorm;
• DotNetConnection = Data Source=.\SQLEXPRESS;Initial Catalog=BPM9;User ID=metastorm;Password=metastorm;

 

Files & Locations

• C:\Program Files (x86)\Metastorm\BPM\Administrative Tools\Service\web.config
• C:\Program Files (x86)\Metastorm\BPM\Deployment\DeploymentService.exe.config
• C:\Program Files (x86)\Metastorm\BPM\Engine\Diagnostics\ProcessDiagnosticsService\Web.config (Optional Component)

Designer:

Metastorm Eye -> Options -> Default Connection:

• Provider: SQL Server
• Server Name: MBPM2008X64
• Use a specific username and Password:
• User name: metastorm
• Password: metastorm
• Database name: BPM9

 

Jerome_Pearce

Discussed in detail here from two years ago:
http://metastorm.processmapping.com.au/post/How-can-you-change-databases-5068386