Motive Power® FAQ
Run Time Errors

I changed the machine name on my computer and Motive Power no longer works properly. What do I do to correct this problem?

My workstations can see my server but they can't see the SQL engine running on the server. The session seems to freeze with no error messages. What should I do?

I get the message "Active x component can't create object" or "Unable to log in, MSDE not installed" from my Manager start up. What is wrong?

I get the message "RunTimeError dbnetlib connection open" or "SQL server does not exist" from my Tech startup. What is wrong?

The MPReports or MPReportsLearn login isn't letting me read my Motive Power tables from Word, Excel, or another program. What can I do?

It seems that some of my stations fail randomly, especially the ones that don't get used as often. It looks like Motive Power is up and running but nothing happens. What should I do?

When I use the Save as HTML feature from the invoice preview screen the screen freezes sometimes. What should I do?

Event viewer is showing a error code 1355 and an event id of 19011 when I start Motive Power. What should I do?

Motive Power stopped working properly. Now I am getting this message: Automation error. The object invoked has disconnected from its clients. What should I do?

I'm getting an error when I try to connect to Motive Power as user MPReports using Word, Excel or other SQL capable tool. What should I do?

I'm getting an error 76 when I try to go into Motive Power. The next time I try to get in, the program tells me that I am already logged in. I run Log Out All Users which works. What is wrong?

I changed the machine name on my computer that hosts SQL Server and Motive Power no longer works properly. What do I do to correct this problem?

You need to change the computer name back to what it was when you installed Motive Power. Microsoft SQL installs to a machine name and an instance. The machine name is picked up automatically by the SQL install program. We control the instance name; it is CAI2, taken from our company initials. If you really need to have the machine name different do this:

1. Change the machine name back.
2. Make a short term backup.
3. Make a long term backup with your choice of backup software and media.
4. Un-install SQL Server and Motive Power.
5. Change the machine name to the new name.
6. Re-install Motive Power.
7. Restore the long term backup with the correct backup software.
8. Run the program group menu item to restore the short term backup.

You will have to follow this same procedure for any applications on your computer that use the Microsoft SQL Server data engine.

My workstations can see my server but they can't see the SQL engine running on the server. The session seems to freeze with no error messages. What should I do?

If you are running a third party firewall or other security product you may have to modify settings to allow port 1433 traffic for internal IP addresses and/or workgroups. If you are running Norton Firewall you have to disable some of the firewall capabilities on the server. You need to allow traffic for the local workgroup with IPs in the 192.168.x.x range. If you are not running a third party firewall, follow the Help system instructions under Preparing for Additional Computers.

I get the message "Active x component can't create object" or "Unable to attach the database, SQL Server 2005 not installed" from when Motive Power tries to start up. What is wrong?

If you are on the server, then Motive Power was not installed via the Server Only choice and so no SQL server exists. If you are not on the server, you chose the Workstation install in order to make use of an existing SQL server installation but you did not make the required CAI2 instance before running the installation.

I get the message "RunTimeError dbnetlib connection open" or "SQL server does not exist" from my Motive Power startup. What is wrong?

Either the Motive Power folder on the server was not shared or not shared with full permissions, or you chose the wrong place when asked to select the location of the data files and the SQL engine. The data files will be in the share that you created for the Motive Power folder. If you created the default share then it will show as machine\MotivePower2 where machine is the name of the machine where you installed Motive Power. The SQL server location will be that same machine.

Go into Motive Power, press the big Reports button, then press Custom. This should recreate those logins.

Windows has a timeout setting. If a particular station does not access the server for a period longer than the timeout setting, that station gets disconnected from the server. The default setting is usually long enough that you will not have a problem. Installation of an Internet communications program like RAS or VPN can alter this setting. For example, if your new VPN installation has a disconnect time of 15 minutes, your stations will lose contact with the server any time they are not used for 15 minutes.

To increase the timeout to 99 minutes click on the Start button, then Run and enter:
 net config server /autodisconnect:99

To increase the timeout to 24 hours click on the Start button, then Run and enter:
 net config server /autodisconnect:1440

You can effectively disable the timeout function by entering:
 net config server /autodisconnect:-1

For more details see http://support.microsoft.com/kb/138365/en-us

If there are any graphic images on the invoice, the screen will freeze if you change the default shown to the right of Images directory/mask. Leave this setting alone. Any images will be stored in a folder called Images that will be created below the folder you chose on the initial Save As window.

That depends on your network connection. You may get this error whenever SQL Server is loaded. The most common reason to get this error message is that you have a network connection, usually via DSL, but you have no dedicated server in house. You do not have a problem. This is a known SQL Server 2000.
If you are using a Windows server and getting this message, your permissions or network settings are preventing SQL from registering itself in the Active Directory when you start it up.
For more details go here.

First try powering down the computer and then powering up again. If the error recurs there should be more details after this message that may not show up until after you respond to this message. If a system has been running properly and then gets this kind of error there is usually some problem with the registry or disk drive. You should run a thorough scandisk.
 
In Windows XP/Vista/7 you do this by going to My Computer and right clicking the hard drive, usually C: and picking Properties. Next pick Tools and then Error Checking. Check both options to fix file system errors and bad disk sectors. When you okay it you will be asked if you want to run the scan on the next restart. Say yes, close all open applications and restart the computer.

If you are sure the user name is MPReports and the password is MotivePower!, run Motive Power. Go to the Reports button and then click the Custom button. This will re-establish the user and permissions that allow read-only access to Motive Power data. You can use this procedure with Motive Power Learn as well.

The folder name and/or location and/or sharing status of the folder has been changed. Your registry entries for Motive Power 3 no longer match the current name and location of these files. Go the Program Files | MotivePower2 and run MPHelper3.exe and set the registry entries to match the current location and/or sharename.
There are two items to set the location of the Motive Power BackThisUp folder and the SQL Server.
The Motive Power BackThisUp entry should be C:\Program Files\MotivePower2 on a stand alone computer running Motive Power 3. If you have more than one station with Motive Power 3 the entry will show as the name of the computer where the files are stored followed by the sharename for those files. For example a default installation with a default sharename on a computer named SHOP will show \\SHOP\MotivePower2.
The SQLServer entry shows the location of the SQL data engine by machinename\instance. For Motive Power the instance name always starts with CAI2, an abbreviation for Computer Assistance Inc.