Page History: Database Connection String
Compare Page Revisions
Page Revision: Fri, 12 Jun 2015 15:20
The CAREWare business tier connects to the database using a database connection string setting stored in the BusinessTierSetting.xml file. This setting can be adjusted by editing the BusinessTierSettings.xml file or by using the CW Admin utility.
The default file path for the BusinessTierSettings.xml file is C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier\BusinessTierSettings.xml. This file can be edited using notepad or other text document application. Make sure the data source = the (server name\database instance name). The default password for the cwbt login account is CWtemp100%. Once the database connection string is corrected, save the file and restart the business tier. The database connection can be tested using the CW Admin utility.
The CW Admin utility can be used to edit the database connection string and test the connection between the business tier and the database. The CW Admin utility is located at C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier\CW Admin by default. To open the utility, right click
CW Admin and click
Run as Administrator.
Once the CW Admin utility is open, click
Stop Server.
Click the database connection string to highlight it and click
Edit.
Once the database connection string has been edited, click
Save, and then click Start Server.
To test the database connection string, click the
Database Info tab. Enter the SA password for the database.
Click
Test your current connection string.
If there is an error, type the error message in the search window for the Jprog.com/wiki search field to search for solutions.
Back to
Business Tier