FAQ

Login – cwtemp Password – TEMPCW100
This is also the Version 4.1 System Administrator user name and password needed for the conversion utility.

Return to Top

Where can I download the .NET Framework 1.1?

Version 1.1.4322.2032 or better is needed and it can be downloaded from Microsoft .NET Framework Version 1.1 Redistributable Package. Once you have installed the Redistributable Package you will need to download and install Service Pack 1 .

Return to Top

How do I upgrade the business tier?

Go to Start>Control Panel>Add/Remove Programs.
Locate the RW CAREWare Business Tier, select it, click Remove, and then Yes.
Download the current CAREWare Business Tier from the HRSA website.
Locate the install file on your computer and double click on it. If you are prompted by a pop up window asking 'The publisher could not be verified. Are you sure you want to run this software?' click “Run”.
Click “Next”, check “Everyone” for the program to be accessed by everyone who uses this computer or “Just Me” for the program to be accessed by only the current user logged into the computer. Click “Next”.
Click “Next” again, read the End User License Agreement and select “I Agree” if you do. Click “Next” again.
When prompted to start the business tier click “Yes”, click “Ok” when the service was started successfully.
Click “Close” when installation is completed.
Login to CAREWare. You will be prompted to update the current tiers. Select “Yes” and allow the update to complete.
Log back into CAREWare. You have now successfully updated CAREWare.

Return to Top

Can anyone who has access to the CAREWare data base view a client's personal identifying information?

No, CAREWare encrypts key personal identifying information before sending it to the database. If you do not want to encrypt these fields a CAREWare administrator can turn this feature off.

Return to Top

Can CAREWare 4.1 Merge Databases?

Yes with the use of Store and Forward. This will only merge two provider domains into the CW_Data database. This will not merge the two domains together into one domain.

Return to Top

Is CAREWare 4.1 free?

Yes, CAREWare 4.1 is totally free under our End User License Agreement (EULA). Not only is the software free, but we also provide free technical support and software upgrades for 4.1.

Return to Top

Where can I download CAREWare 4.1?

CAREWare 4.1 can be download from HRSA

Please be sure to check out other useful CAREWare 4.1 resources that are also available on the web site.

Return to Top

Is technical support available for CAREWare 4.1?

Yes, free technical support is provided for 4.1. The CAREWare help desk is open on Monday through Friday from 12 PM to 5 PM Eastern Standard Time (EST). You can reach the help desk during these hours at 877-294-3571. If you can't reach us by phone, you can email the help desk at cwhelp@jprog.com

Return to Top

Do you provide training for CAREWare 4.1?

We do not currently provide on site training for CAREWare, but we do have online training sessions available for download. These sessions can be downloaded from HRSA . Contact John Milberg for further information.

Return to Top

What is required to run CAREWare 4.1?

To run CAREWare 4.1 you must have Microsoft's .Net Framework v1.1 installed on your computer. Hardware requirements for 4.1 are not very stringent, so if your computer is fairly new, you should not have a problem.
You may to install the following applications in order for CAREWare to work properly:
MDAC 2.8
XML Parser 6.0
Windows Installer 3.1

Return to Top

When I log into 4.1, I can view the client data but I can't change it. All fields appear to be disabled (gray). What am I doing wrong?

You are either logging into the central administrator domain or logging into the provider domain, but your user account does not have the necessary permissions to update (edit) a client record. (Central administrators can only view data; they can't edit data.) You can check the user permissions by going to the Provider/User manager permissions section. Also check the user manual for further information on creating users and assigning rights to different parts of the application.

Return to Top

When I try to log in I get an error message saying "The underlying connection was closed"

Usually this is caused because the business tier service is not running.

Return to Top Open the CW Admin utility in the business tier directory and go to the “Services” tab. Highlight the RW CAREWare Business tier service and press “Start Service”. You could also be trying to connect to the wrong computer or your network is down.

Return to Top

How do I install CAREWare?

The simplest way to install CAREWare is to download the CAREWare installer and user manual from the HRSA web site.

You will also need to download and install the last .NET framework from Microsoft before installing CAREWare.

To actually install CAREWare double click on the CAREWare Setup file. You will be prompted to unzip the files to C:\CW_Setup. Change the directory if you wish. "Run after extraction: rwcarewareinstaller.exe" is the default next action. Click “Finish”. When prompted to run the CAREWare installer, click “Yes”.

When asked to choose which type of install you would like, chose Express Install to install all components of CAREWare. You will then be prompted to install each tier of CAREWare (Business, Client, Database, and Conversion Utility). After all tiers are installed and the database created, you will be able to run CAREWare from the Start menu.

This has been only a brief over view of the CAREWare installation process. More detail can be found in the User Manual and the System Administrators Guide to CAREWare. Both are available for download from the HRSA web site above. If you have specific questions regarding the installation of CAREWare you can email the Help Desk here at cwhelp@jprog.com or call 1-877-294-3571 between 1pm and 5pm Eastern Standard Time (EST), Monday though Friday for live support.

Return to Top

How do I start the business tier?

Go to the CAREWare Business Tier directory (Default location: C:\Program Files\CAREWare\RW CAREWare Business Tier) and open CW Admin.exe. Go to the “Services” tab and find the RW CAREWare Business Tier service. Highlight the service and click “Start Service”.

Return to Top

Return to Top

When I change the allow search results value in the business tier settings file nothing happens, how do I make the changes take affect?

The allow search results value in the Business Tier Settings file is the maximum number of results that the business tier will return for a given search. In order to change the number of patients in the list, you must also change the max results value.

Go to the business tier directory and open the CW Admin utility. Press “Stop Server”, then change the Table Name to LocalNumberStorage and look for the tag MaxSearchResults. Click on the tag and then press “Edit” to edit the number of search results to return. After changing the number of results to return click “Save” and then “Start Server” for the changes to take affect.

Return to Top

When I log into CAREWare I get an error message that says "SQL Server does not exist or Access Denied", what did I do wrong?

This error message has two resolutions. In order to resolve this error you will need to go to the business tier directory and open the CW Admin utility.

Click on the “Services” tab and verify that the SQL Server instance is started and running. If it is not, then highlight the instance (default name is MSSQL$CAREWare) and then click “Start Service”.
OR
Click on the “Server Settings” tab in the CW Admin utility and then press “Stop Server”. Click on DatabaseConnectionString and then the edit button. This will allow you to view the entire string. You will need to verify that the hostname and SQL Server instance name are correct in the DatabaseConnectionString. To do so check the following:

The hostname can be retrieved by going to Start>Run and typing CMD then press enter. This will bring up the command line. From the command line type HOSTNAME and then press enter. The name displayed is the hostname for the computer you are currently using.
To retrieve the SQL Server instance name simply go to the Services tab and view the MSSQL$XXXXX (where X is the name) service. By default this should display as MSSQL$CAREWare.

Return to Top

Will CAREWare run on a Windows 98 system?

We have experienced countless problems when running CAREWare on a Windows 98 system. Because of this, we will not be able to provide technical support for CAREWare users who use the Windows 98 operating system.

Return to Top

The client sync cannot maintain a secure channel

In the server.config there is a connectionAgeLimit which is set to 120 by default. Increase this number to 600 to resolve the error. This exception is a result of a slow server, or a request that takes longer than the allowed timeout.

Note: You must restart the business tier after making changes to the server.config.

Return to Top

What is the SA password and what does it do?

The SA password is created during the installation of CAREWare. It is a user defined password for the SQL Server database. Once a password is provided it cannot be changed unless the current password is known.
The System Administrator password is used for SQL Server database and you set it during a fresh install of the database. Once it is provided it cannot be changed unless you know the password. The installation is asking you to provide a new password. Write this password down and keep it in a safe place. You will not need the password to log in to CAREWare, only to manage the database.
If you lose the SA password the CAREWare Help Desk strongly suggests that you exhaust all attempts to recover the password before attempting to detach and reattach the database as outlined in the Sys Admin User manual. If all attempts to retrieve the password are exhausted, refer to the System Administrator User Manual pages 22-23.

Return to Top

How do I tell which version of CAREWare or .NET framework I have?

At the main login screen of CAREWare you can find the version number of CAREWare displayed prominently under the program title. The build number can be found directly underneath the version number. The .NET framework number can be found at the main login screen also. It is located at the bottom left corner of the login window. If you are logged into CAREWare from the main menu go to Administrative Options and then System Information. This will provide with the business and client tier version numbers as well as the Microsoft SQL Server Desktop Engine version number.

Return to Top

How do I install the International version of CAREWare?

Download the full installer for the international version of CAREWare from the jProg website. Run the installer and select where you would like the installer to create the installation folder. By default, the installation folder is placed in C:\CW_Setup. Here is a look at the installer.

When the extraction is complete, the installer will ask you if you wish to run RWCAREWareInstaller.exe. Click ‘Yes,’ and you will be presented with the option to choose either ‘Domestic’ or ‘International’. Choose ‘International’ and click ‘Continue’. Here is link to view the installation type. Now you will be prompted to either run an Express or Custom Install. Select the Express Install if you have never installed CAREWare before. Select the Custom Install if you need to install a specific tier such as the client tier. Here is a look at the install selection screen.

With Express Install selected, click ‘Next’ and you will see the installation menu. The three tiers of CAREWare are labeled clearly, as is the data conversion application. Here is what the menu looks like. The first installation is for the business tier. Click ‘Install,’ and a new window will appear asking where to install the tier and if the program is to be used by ‘Just me’ or ‘Everyone’ on this computer. Click next until you reach the EULA. The End User License Agreement (EULA) provides the necessary information concerning the use of CAREWare. If you agree with the EULA, select ‘I accept’ and click ‘Next.’ The installer will now install the business tier. You will be prompted if you wish to start the business tier service. Select ‘Yes,’ and then the installer will finish, bringing you back to the Installation Menu.

The next tier to be installed is the data tier. Select ‘Install’ from the Installation Menu and in the new window you will be prompted to select to use either an old database instance or to create a new one. Here you can see the data tier setup. Select the appropriate choice for your installation and click ‘Next.’ If you selected to create a new instance then provide a SA password and instance name for the new instance. The installer will then create the new database and start the service. Once the service is started, you will see a new window that reads ‘The data tier has been successfully installed.’ The radio button for creating a BusinessTierSettings.xml file will be checked. IMPORTANT: For the international version, the check box labeled ‘International Version’ must also be checked before selecting ‘Finish.’ Here you will see where the radio button is located.

Next, select ‘Install’ for the client tier from the Installation Menu. Select the same fields as you had for the business tier installation and allow the installation to complete. The final application to be installed is the data conversion utility. If you do not have any data from CAREWare 3.6 to convert then you do not need to install this application and can Exit Setup now.

When installation of all tiers is complete, CAREWare will be ready to be run. Go to the Start menu and select ‘RW CAREWare 4.0 Client’ from the menu and then select ‘Run CAREWare 4.0.’ You will be able to login to CAREWare using the default user name and password: “cwtemp” and “TEMPCW100” (without the quotation marks).

Once you have installed the international version of CAREWare, you should have a look at the CAREWare documentation. The CAREWare User Manual is a good place to start, even though it refers to the U.S. version, because the International and U.S. versions are very similar. The International Setup Document addresses international issues not addressed by the User Manual. Network administrators with technical questions about the software should refer to the Administrator’s Guide.

Return to Top

How do I turn channel encryption off?

Open the CAREWare Administrators utility (CW Admin.exe) which is located in C:/Program Files/CAREWare/RW CAREWare Business Tier. Look in localNumberStorage for "doNotEncryptChannel". If you do not see this tag, you can add it. Setting this value to 0 will turn encryption on and setting it to 1 will turn encryption off. After changing the value on the business tier, you must also set the value on the client tier. This is done by opening the ClientTierSettings file which is C:/Program Files/CAREWare/RW CAREWare Client Tier. Find “doNotEncryptChannel” in localNumberStorage and set the value accordingly.

Return to Top

How do I setup the HIVQUAL module?

Please refer the manual How to use the HIVQUAL module in CAREWare and Calculated Fields for Custom Reports . This manual will provide detailed instructions for setting up HIVQUAL.

Return to Top

Receiving error: Login failed for user 'cwbt'

To resolve this error go to the business tier directory and open the CW Admin utility. Go to the Database Info tab and provide the SA password. Click “Resolve” and this will resolve the error. If you are using an older build of CAREWare you will need to have Enterprise Manager or Craig's SQL Manager. Run the following query on the table cw_client.

Exec sp_changedbowner 'cwbt'

This will set the database owner to user 'cwbt'. This is necessary for the business tier to communicate with the database.

Return to Top

Can I install the business tier twice on the same computer to separate providers?

No, you cannot install the business tier twice on the same computer. CAREWare allows providers to share as little or as much client information as the provider would like. The user permissions can also restrict users to individual providers or their access to client data.

Return to Top

What is Store & Forward and how do I use it?

Store & Forward (S&F) allows a provider to export some or all of their CAREWare database to a central domain on a regular basis. The S&F provider will not have access to other provider's data on the central domain database. This feature allows the grantee level server to contain all client level data from all providers whether or not the provider is connected to the network in real time. S&F allows multiple providers to import data to a central domain. If the imported data contains the same client from different providers, then S&F will check if any data is missing or different. If the client data is different from provider A and provider B, then the last imported client value will be used. The central administrator can chose to bypass the last value and keep the non-missing values found in provider A. For detailed instructions on how to setup S&F, please refer to our Store & Forward Instructions document. This document outlines the basic procedure for creating the S&F adaptors, exporting, and importing the data.

Return to Top

Where are the new medications located?

New medications are added to the medications list frequently within CAREWare. If you do not have the current build installed then you will not see the new medications. The easiest way to add these medications is too upgrade to the latest build.

Once you have upgraded to the latest build login to the provider domain. Go to Administrative Options>Clinical Encounter Setup>Medications Setup. Look for any medication you need in this list. If the medication is not on the active medication list then click “Advanced Options”.

The Medication Import Setup lists all available medications in CAREWare. Begin typing the name of the medication you are looking for into the search box. The list will automatically find the medications that match your search values. Once you have located the medication highlight it and click “Add”. This will add the medication to the Current List of Medications where you will be able to select it from a client's medication tab.

Return to Top

How do I change the maximum days to keep the same password?

The maximum number of days to keep the same password is set in CW Admin. This utility can be found in the business tier directory (Default location: C:\Program Files\CAREWare\RW CAREWare Business Tier). Open the utility and press “Stop Server”. Change the table name to LocalNumberStorage. Highlight “MaximumDaysToKeepSamePassword” and select “Edit”. This will allow you to edit this field in the settings box. Change the number of days to keep the same password to your liking.

Important:Remember this is a security feature. Passwords should be renewed on a regular basis.

Return to Top

How do I change where backups are stored?

To change the location of the backup directory do the following:

Open CW Admin in the RW CAREWare Business Tier (Default location: C:\Program Files\CAREWare\Rw CAREWare Business Tier).
Press "Stop Server" and locate the SQLServerBackupDirectory tag.
Highlight the tab and press "Edit". Edit the Setting path to the new location.
Press "Save" and then press "Start Server".

You can also edit the SQLServerRestoreFromDirectory to reflect the change in the backup directory path. If you do not change the restore from path then CAREWare will only try to restore the backups located in the default path.

Return to Top

How can I perform maintenance on my CAREWare database?

The SQL Server database occasionally needs maintenance particularly if you have a large amount of data. In a future build, we will have some maintenance features built into CAREWare, but for now here is a way to manually do this maintenance.

NOTE: As always, before beginning you should make a backup of the database. Never do any significant operations without first making a good backup.

NOTE - This may take a long time (like hours) and you will not be able to use the database during that time!

1) Stop the CAREWare business tier, to ensure that no one will try to access the database during this time.
2)Open Enterprise Manager or Craig's SQL Manager paste this into a query window:

USE cw_data
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE'
OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN DBCC DBREINDEX(@TableName,'',90) FETCH NEXT FROM TableCursor INTO @TableName END
CLOSE TableCursor DEALLOCATE TableCursor

3) Run this query and it will rebuild all the indexes for the tables in the database.
Once this is done, you should see a dramatic speed increase, particularly in reports that compile large amounts of data (ie. running the CADR).

Return to Top

Receiving error “The application failed to initialize properly (0xc0000135)” when attempting to install RW CAREWare.

This error is caused by not meeting the necessary requirements for the installation of RW CAREWare. You need to install .NET 1.1 before attempting to install RW CAREWare. .NET 1.1 can downloaded from the Microsoft website as well as Service Pack 1.

Return to Top

Where can I download the Form Designer manual?

You can download the Form Designer manual from the following link:
How to use the CAREWare Form Designer
Right click and select "Save target as" then select a place to save the document and press "Save" The Form Designer manual provides all the necessary information for activating, creating, and using the Form Designer in CAREWare.

Return to Top

Is CAREWare compatible with Windows Vista?

Yes, CAREWare is compatible with Windows Vista and SQL Server 2005. SQL Server 2000 is not supported by Vista. You can access a SQL Server 2000 database installed on another system from a Vista system.

There are several known issues with SQL Server 2005 and Windows Vista. These issues include problems installing .NET 1.1 and slowness when running CAREWare using SQL Server 2005. The .NET 1.1 installation issues with Vista have been mostly resolved by Microsoft with the official release of Vista. To review more details concerning the slowness issues with SQL Server 2005 please check out the FAQ question "Why is SQL Server 2005 slow?"

You will be able to upgrade from SQL Server 2000 to SQL Server 2005 using the Microsoft provided upgrade advisor. For a more information concerning how to upgrade to SQL Server 2005 please review the following white paper: Upgrading MSDE 2000 to SQL Server 2005 Express.

Click here to find out how to turn off the User Account Control (UAC) in Windows Vista in order to install CAREWare.

Return to Top

How do I change the database instance where CAREWare is located?

The swapping of databases should only be done by those familiar with SQL commands and aware of all possible issues which may occur. You will need a SQL manager such as Enterprise Manager or Craig’s SQL Manager.

Go to the CW_Setup directory located at C:\CW_Setup.
Run RWCAREWareInstaller.exe.
Select “Custom Install” and press “Next”.
Select the second check box and press “Next”.
Provide a SA password and instance name for the new instance (CAREWare2).
The installer will then create the new database and start the service. Once the service is started, you will see a new window that reads ‘The data tier has been successfully installed.’
The radio button for creating a BusinessTierSettings.xml file will be checked; UNCHECK this button and press "Finish".
Go to the business tier directory located at C:\Program Files\CAREWare\RW CAREWare Business Tier and open the CW Admin.exe.
Click "Stop Server".
Go to the "Services" tab and stop both SQL Server services by highlighting each and pressing "Stop Service".
Go to the old database instance directory (default location: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE\Data).
Highlight CW_Data.MDF and CW_Data_log.LDF and then press control (CTRL) + C. This will copy both files.
Go to the new database instance directory located at C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE2\Data.
Press Control (CTRL) + P. This will paste both files in to this directory. If prompted to overwrite files, click "Yes".
Go back to the CW Admin.exe and start MSSQL$CAREWare2 on the "Services" tab.
Go to the "Server Settings" tab and highlight the tag DatabaseConnectionString and press "Edit".
Change CAREWare2 to CAREWare3 and then press "Save".
Press "Start Server".
Open Craig's SQL Manager and register the new database (Right click on SQL Server Instances and select "Register new instance". Then click "Find BusinessTierSettings.XML" button and browse to the RW CAREWare Business Tier directory where the XML File is located. Select the file and press "Open". Once the path to the business tier is provided click "Connect".)
Expand CAREWare2, then expand CW_Data, then expand Tables.
Select the table CW_Client and right click on it. Then select "Run a query".
Delete any text which may appear in the new query window.
Paste this query into the query box: exec sp_changedbowner 'cwbt'
Click "Run Query".
Go back to the CW Admin.exe and click "Stop Server".
Once the service is stopped click "Start Server".
Open CAREWare and attempt to login.

Return to Top

Why is SQL Server 2005 slow when used with CAREWare?

SQL Server 2005 slow response time when accessed by CAREWare can be attributed to

SQL Server 2005's long compilation waiting times,

the Microsoft Full-Text Engine for SQL Server (MSFTESQL) service running a query to retrieve data from an indexed view, or

two or more indexes are used for a query plan.

The causes listed above are only a sampling of the issue slow response time issues encountered with SQL Server 2005. This slow response time can be rectified according to Microsoft by upgrading to the latest service pack for SQL Server 2005, Service Pack 2. However, the experience by users after upgrading to Service Pack 2 for SQL Server 2005 is the same slow responsiveness as before.
The help desk suggests that all users who are currently using SQL Server 2000 or a MSDE version of SQL Server 2000 continue doing so. Those who have upgraded to SQL Server 2005 should download and install the above service pack if they have not already done so.

Return to Top

How do I archive my change logs?

You will need a SQL Manager such as Enterprise Manager or Craig's SQL Manager to complete the following process. The change logs contain all changes made to the CAREWare database by users within the Client Tier. These logs are used as part of the audit feature of CAREWare. It is important to keep these logs, but if they are taking up to much space on the hard drive then you can detach and archive the oldest logs.
NOTE: We recommend that you do not remove or detach the highest numbered change log attached to the database instance.

To detach a change log using Enterprise Manager:

Open Enterprise Manager and expand the "Microsoft SQL Servers" list
Choose the CAREWare database instance and expand it
Expand 'Databases' under your CAREWare database instance
Right click on the first CW_Change_Log_00XX you want to remove
Select "All Tasks", then "Detach Database"
Click "OK"

This procedure will detach the database. You can then go to the Microsoft SQL Server directory and move the detached change log to your archival destination.

To detach a change log using Craig's SQL Manager:

Open Craig's SQL Manager and register your database instance for CAREWare
Expand the database instance by clicking on the + sign
Right click on the CW_Change_Log_000X, where X is the last digit, and select "Detach Database"
Click "Yes" when prompted to detach the database.

This procedure will detach the database. You can then go to the Microsoft SQL Server directory and move the detached change log to your archival destination.

If you encounter the error "Cannot detach database "cw_change_log_000X because it is currently in use", then run the following query:

USE master;
ALTER DATABASE cw_change_log_000X
SET SINGLE_USER;

Then run the following query in order to detach the database: sp_detach_db 'cw_change_log_000X'

Return to Top

How to upgrade to SQL Server 2005

To upgrade from MSDE to SQL Server 2005 Express where you cannot or do not want to perform an in-place upgrade

Log on to the MSDE system as an administrator and verify that the instance of MSDE that you wish to upgrade is running.
Check for a green arrow on the SQL Server icon in the System tray.
Open a command prompt and use osql to connect to the instance you wish to upgrade. To connect to the local, default instance of MSDE using Windows Authentication, use the following command:

To connect to a named instance, use the -S switch and specify the instance name as shown below to connect to the desired named instance.

osql -E -S servername\instancename
List all of the databases on the MSDE instance by using the following commands at the osql prompt:

1> SELECT name FROM master.dbo.sysdatabases WHERE DBID > 4

2> GO

This lists all of the user databases on the MSDE instance.
Detach each of the user databases on the MSDE instance by entering the following command at the osql command prompt:

1> EXEC sp_detach_db 'database_name'

2> GO

This takes each of the user databases offline. Replace the value of database_name with the name of the databases that you want to move from MSDE to SQL Server 2005 Express. The databases will later be attached to the new SQL Server 2005 Express instance.
Exit the osql utility by entering the following command at the osql command prompt:

1> exit
Shut down MSDE by opening SQL Server Service Manager on the System Tray. In the Services drop-down list, select the SQL Server service, click Stop, and then click Yes.

Note: You can also use the Services application or the NET STOP command to stop the MSDE instance.
Repeat for the Distributed Transaction Coordinator and the SQL Server Agent services (if they are running).
Remove MSDE by opening Add/Remove Programs from the system's Control Panel, selecting the entry named Microsoft SQL Server Desktop Engine and clicking Remove.

Note: If MSDE was installed as a part of another application, it will not appear in the Add/Remove programs list. In this case, remove MSDE by using that application's installation program.

Note: This step can be skipped until a later time if you are installing SQL Server 2005 Express to a different instance name than the instance of MSDE that is being upgraded.
Download and install Windows Installer 3.1.
Windows Installer 3.1 is required by SQL Server 2005 Express. You can download Windows Installer 3.1 from the Microsoft Download Center. After you have downloaded Windows Installer 3.1, install it by running the WindowsInstaller-KB893803-v2-x86.exe program (if Windows Installer 3.1 is already present, the install detects this and aborts). This install requires a system reboot.
Download and install the .NET Framework 2.0.
The .NET Framework 2.0 is a prerequisite to SQL Server 2005 Express and it can be downloaded from the Microsoft Download Center. After downloading the .NET Framework 2.0, install it by running the dotnetfx.exe program.
Install SQL Server 2005 Express by running the SQLEXPR.EXE or install SQL Server 2005 Express Edition with Advanced Services by running SQLEXPR_ADV.EXE.
Select the appropriate installation options for the new instance you are installing, including the instance name if you wish to specify a name other than SQLEXPRESS.
After SQL Server 2005 Express is installed, start sqlcmd by opening a command prompt and typing the following command and then pressing ENTER:

sqlcmd -E

This connects you to the local, default instance of SQL Server 2005 Express using Windows Authentication. If you wish to connect to a named instance, use the -S switch and specify the instance name as shown in the following.

sqlcmd -E -S servername\instancename
Attach each of the user databases that were detached from the MSDE instance by entering the following command at the sqlcmd command prompt:

1> EXEC sp_attach_db 'database' , 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\database_data_filename.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\database_log_filename.LDF'

2> go

Replace the values of database_data_filename and database_log_filename with the names of the database files from the user database that was detached from your previous MSDE installation. This example shows the default installation path that is used by MSDE. If your installation used a custom path, then you can substitute the correct path value. Repeat for each detached user database.
Exit the sqlcmd utility by typing exit and pressing ENTER.
Enable any needed protocols as described in the Configuration Changes section.

Return to Top

Quality Check: Failed to load MSXml2.dll

This is a Microsoft bug. There is a fix available at Microsoft Support .

Return to Top

How do I convert v3.6 data to v4.1 data?

You will need to install build 2.46 to convert v3.6 data to v4.1 data. You can download the complete installation package from the HRSA website.

You will have to install build 2.46 completely before attempting to convert your data. Before running the conversion you need to know the following:

The location of your existing CAREWare v3.6 data files.
The 'System.mdw' location.
The location of your v4.1 data file.
A CAREWare v3.6 user account with full Admin rights.
A CAREWare v4.1 user account with Add and Edit permissions.

The CAREWare User Manual provides detailed instructions and illustrations for the setup of the conversion wizard. Refer to pages 29 to 34 of the User Manual for more information.

Return to Top

What does "The remote name could not be resolved" mean?

The error message "The remote name could not be resolved" means that your network connection has failed. In order to resolve this error, click on "Retry" in order to log back into CAREWare. This may take several tries over a period of time if your network connection has failed for some series reason.

Return to Top

How do I resolve the error 'Missing ChangeLog database -0000'?

From the main menu go to Administrative Options>Change Log Operations

Click the "Rebuild Change Logs" button

Click "Rebuild Change Log"

Click "OK" when the rebuilding has completed

Return to Top

How do I move my CAREWare instance to a new hard drive/PC/Server?

To move the databases using a recent backup:

Login to the Central Administration domain (You will need an administrative account)
Go to Administrative Options>Backup>View Data Backup Options
Click on "Create Backup Now" then "OK" after reviewing where the backup will be created
Go back to the main menu of CAREWare and click on "Refresh Messages"
A new Administrative Alarm will appear, click on the link and verify that the backup was completed successfully
Browse to the location of the backup (Default location: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE\Data) and copy the cw_bu_X_XX_XX.cwb, where X is the Month/Date/Year of the backup, to the new hard drive/PC/Server.
Install the new CAREWare database instance and if necessary the business and client tiers on the new hard drive/PC/Server.
Go to the business tier directory (Default location: C:\Program Files\CAREWare\RW CAREWare Business Tier) and open the CW Admin.exe
Press "Stop Server"
Highlight the DatabaseConnectionString and press "Edit"
In the Setting field above, enter the new database instance name where "Data Source='hostname'\'instance name';" or "Server='hostname'\'instance name';"
Click "Save"
Highlight the SQLServerRestoreFromDirectory and click "Edit".
Provide the path of the backup that moved to the new server.
Click "Save" and then click "Start Server".
Login to the Central Administration domain using the new database instance
Go to Administrative Options>Backup>View Data Restore Options
Provide the correct SA password
Using the pull down menu, select the most recent backup. This should be the backup you just created. Backups are listed by date
Click "Restore Database"
Click "Yes"
Click "Restore No Backup" if this is a new database instance with no data residing in the database
If CAREWare detected multiple backups on the specified day, then chose the backup with the latest time stamp
Click "Restore"
Once the restore has completed click "Ok"
Log in to CAREWare and chose your provider domain
Check that restore occurred properly by verifying the client data

Return to Top

How do I install Service Pack 4 for SQL Server 2000?

Choose and download the SQL Server 2000 Service Pack 4 from the Microsoft website.

Double click on the downloaded EXE file. You should be prompted to browse to the location of the database instance (Default location: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE). Once you have chosen the location the installer should automatically upgrade the service pack for SQL Server 2000.

If the installer does not automatically upgrade the service pack or generates an error during the installation process, then you will need to do the following in order to complete the upgrade.

Go to Start>Run and type "CMD" (No quotes). Click "OK".
Change to the location of the SQL Server 2000 Service Pack directory (Default location: C:\SQL2KSP4) by typing the following: cd C:\sql2ksp4. Then press "Enter".
Run the following command in the Service Pack 4 directory:
setup /upgradesp sqlrun INSTANCENAME=CAREWare SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=SAPWD DISABLENETWORKPROTOCOLS=0
Press "Enter".
Once the installation is complete type "Exit" (No quotations) and press "Enter". You may be prompted to restart your system after the upgrade.

You will need to provide the correct database instance name for INSTANCENAME. You will also need to provide the sa password for UPGRADEPWD.

Return to Top

What is the difference between "Internal Outgoing Referrals" & "External Referrals?"

Internal referrals are made between providers who are connected to the same central database. External referrals are made between providers who are not part of a real-time network or managed by a grantee. External referrals are the only referrals available for standalone users of CAREWare.

Return to Top

How do I add active external providers?

The following will need to be done on the Central Administration domain before you will be able to activate external providers from the provider domain.

Login to the Central Administration domain
Go to Administrative Options>Provider/User Manager
Expand "Real-Time Providers", then expand your provider's name
Expand *Provider's* Permissions, then expand "Data Entry"
Expand "Referral"
Right click on "Activate External Provider" and select "Grant"
Expand "Users" under your provider name
Expand the account name you want to grant the permission to
Expand "Data Entry", then "Referral"
Right click on "Activate External Provider" and select "Grant"
Click "Save" and then "Close"
Log off the Central Administration domain

Find the client who you want to add an external referral for

Change to the "Referrals" tab, then change to the "External Referrals" tab

Click "New Referral"

Click "Add" next to "Refer-To-Provider"

Click "Add New Provider" and provide the new provider's name, then click "Save this Provider"

Check the box in the "Active" column for the newly added provider

Add any additional providers you need to, then click "Save Current List and Exit"

Choose the "Refer-to-Provider" from the pull down list then select the "Referral Status" and "Referral Date"

If you do not have a "Referral Class", then click on the ellipsis box next to it.

Click "Add", then provide the referral class name

Click "Save" and continue adding the necessary classes for your provider

When finished adding the referral classes, click "Save Current List and Exit"

Choose the "Referral Class" from the pull down menu

Select the appropriate Service Category, add any necessary comments, and then click "Save" if the referral is not yet completed.

Return to Top

Does CAREWare import data from the major lab companies (LabCorp, Quest Diagnostics, etc.)?

CAREWare currently offers an automated import of results from LabCorp. Clinics interested in using this feature should contact their LabCorp representatives; once a clinic is approved, jProg guides its users through a testing/training phase that usually lasts about two weeks before "live" results are sent.

Imports from other lab companies, like Quest Diagnostics, could be developed in the near future. If you are interested in such an import, it never hurts to let your lab representative know!

Return to Top

How do I decrypt the cw_client table?

To show the client fields within the cw_client table you will need to have access to the Central Administration domain.

Login to the Central Administration domain
Go to "Administrative Options"
Go to "Advanced Encryption Options"
Go to "Show/Hide Encrypted Fields in cw_client"
Check the button next to "Show Personal Identifying Information in cw_client table"
Click "Save Changes"
Click "Ok"

Return to Top

How do I resolve the error 'The specified service already exists' during an installation?

You are receiving this error when you are attempting to install the newest build of CAREWare on top of the previous build. You should first attempt to remove the previous business tier build using the Add/Remove Programs located in the Control Panel. You can learn more about how to uninstall CAREWare using that feature at the 'How do I upgrade the business tier?' FAQ link.

If the above uninstallation was unsuccesful in removing the current business tier build, then you will need to complete the following:

Go to Start>Run
Type "CMD" (No quotes) and click 'OK'
On the command line type the following:
"SC Delete RWCAREWareBusinessTier" (No quotes)
then press 'Enter'
After receiving notice that the service has been successfully deleted, reboot the PC.
Attempt to re-install the latest build using the business tier setup file.

If you are still unable to install the new build after completing the above, then you will need to edit your registry.

Warning Editing the registry can adversly affect your system. Make sure to have a recent registry backup before attempting the procedure below.

Go to Start>Run
Type "Regedit" (No quotes) and click 'Ok'
Go to Hkey_Local_Macine>System>CurrentControlSet>Service>RwCAREWareBusinessTier
Right click on the RWCAREWareBusinessTier folder and select 'Delete'
Click 'Yes'
Once the registry as been successfully deleted you can attempt to re-install the business tier build.

Return to Top

How do I install CAREWare on the WIndows Vista OS?

How do I install CAREWare on a Windows Vista PC? You can attempt to install CAREWare as you would normally on a Windows XP machine. Simply download the latest version and build from the HRSA Website. Then run the installer as normal. If you encounter any issues with the installation then complete the one of the following.

Install CAREWare as an administrator

Download the setup file above
Right click on the setup and select "Run as Administrator"
Click "Continue" if prompted to do so

This should allow the necessary permissions to be granted to the setup file and allow a successful install of CAREWare.

How to turn off UAC

Using the Control Panel

Open Control Panel.
Under User Account and Family settings click on the "Add or remove user account".
Click on one of the user accounts, for example you can use the Guest account.
Under the user account click on the "Go to the main User Account page" link.
Under "Make changes to your user account" click on the "Change security settings" link.
In the "Turn on User Account Control (UAC) to make your computer more secure" click to unselect the "Use User Account Control (UAC) to help protect your computer". Click on the Ok button.
You will be prompted to reboot your computer. Do so when ready.

NOTE In order to re-enable UAC just select the above checkbox and reboot.

OR

Using MSConfig

Launch MSCONFIG by from the Run menu.
Click on the Tools tab. Scroll down till you find "Disable UAP" (this should probably change to UAC in next Vista beta builds and in the RTM version). Click on that line.
Press the Launch button.
A CMD window will open. When the command is done, you can close the window.
Close MSCONFIG. You need to reboot the computer for changes to apply.

Note You can re-enable UAC by selecting the "Enable UAP" line and then clicking on the Launch button.

Now you will be able to install CAREWare as normal.

Return to Top

Is there a data dictionary available for CAREWare?

Yes, there is a data dictionary available for CAREWare. You can download it from here .

Can I open the CAREWare 4.0 database in MS Access?

Yes, you can open the database using MS Access, but it must be done by creating an ODBC Connection. It is very important that you do not change any records in the CW_Data file through MS Access. Any changes to the data should be done either through the CAREWare client, or by using the business tier programming interface.

If you are not familiar with creating ODBC connections, follow the instructions listed below:

Start MS Access and click File>Open
Change the file type drop down box to “ODBC connections”. This should bring up a new window.
Click the “Machine Data Source” tab and then click “New”.
Click the “System Data Source” button and click “Next”.
Scroll down to “SQL Server” and click “Next”.
Click the “Finish” button. Now you will see the “SQL Server Data Source Connection” wizard.
Type in a name and description for this connection, and then choose the server from the list.
Use “Windows Authentication” (which uses your Windows ID and Password to Login). If this doesn’t work, you may need to try “SQL Authentication”.
Change the default database to CW_Data.
Click “Finish”. Now when you open MS Access and change the type to ODBC you will see the connection you just created.

Return to Top

How do I reset/unlock a user?

To unlock a user account using the Provider/User Manager:

Log in to the Central Administration Domain.
Go to Administrative Options>Provider/User Manager.
Expend Central Administration’s Users and Permission.
Expend Users and right click on the user account that is locked.
Select Undo User Lockout.

To unlock a user account using the BusinessTierSettingsEditor.exe or CW Admin.exe

Go to the business tier directory. (C:\Program Files\CAREWare\RW CAREWare Business Tier This is the default location.)
Double click on BusinessTierSettingsEditor.exe or CW Admin.exe (This depends on what build you are currently using.)
Stop the server.
Highlight ResetLockoutAndPasswordForUser then click Edit.
In the Setting field enter the user account you want to unlock and click Save.
Start the server and close the BusinessTierSettingsEditor.exe.
Log in to CAREWare using the locked account.
You will be prompted to provide a new password. Passwords must be 8 characters long and contain 2 alpha numeric characters.
You will be prompted again to log in to CAREWare. The account is now unlocked.

Return to Top

Where are the CAREWare backups stored?

The location of the backup file can be found in the CW Admin utility listed under the “SQLServerBackupDirectory” tag. The default location of this directory will be the SQL Server data folder, which is C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE\Data.
Return to Top

What does "The business tier is in the process of initializing" mean?

The message "the business tier is currently in the process of initializing. You will not be able to login until the initialization is complete" is not an error message. It is simply telling the user that CAREWare is completing the necessary steps needed be before opening such as Data or Client tier updates. Please allow it a few moments before clicking on "Try Again". This will occur every time the business tier service has been restarted."

Return to Top

How do I set the timeout limit?

To turn the inactivity timeout to a longer session you must set the timer in the CW Admin utility. You can find either utility in the RW CAREWare business tier directory (Default location: C:\Program Files\CAREWare\RW CAREWare Business Tier).

Open the utility and press “Stop Server”. Select “LocalNumberStorage” from the table name combo box in the upper right corner. Select the tag “UserTimeout” and click “Edit”. The Settings field will become enabled on the top box. Change the number from 15 (default) to whatever you would like. Click “Save”, and then click “Start Server”.

This is all that needs to be done to change the timeout setting. There is no way of disabling the timeout setting. If you set the number to 0 in the settings field CAREWare will not open.
Important: Remember this is a security feature, so be careful how long you set the inactivity period to.

Return to Top

What are the new service categories in CAREWare and how can I use them?

The newly added Ryan White HIV/AIDS Program service categories added to CAREWare include Medical and Non-Medical Case Management services as well as Linguistics Services and others. These new services have been added to CAREWare well in advance of the reporting period. We recommend that you reclassify your services to reflect the coming changes in the Program Data Report (PDR).

At this time the CADR has not been completely updated into the PDR. We know many of our providers run the CADR on a monthly basis in order to get up to date information on existing clients. If you have reclassified your services using the new services, then these services will not appear on the CADR.

If it is critical for you and your provider to run the CADR over the next few months to return up to date client data, then we suggest that you hold off on re-categorizing the services until the PDR is incorporated completely into CAREWare.

Return to Top

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com. Copyright (c) 1998-2006 Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.