Error #-2147467259

May 27, 2010 4 Replies

I have a customer running RMS v2 SP3 on a Win XP Pro SP3 system that just started getting this error. The system has the RMS database locally with a fixed IP. They get the error multiple times a day and the systems locks completely. Up until a week ago they had no problems.



Database connection lost, application will be closed. Error #-2147467259


We have:


  1. reinstalled both RMS v2 sp3 and SQL Express 2005
  2. In SQL Server 2005 Configuration Tools Client Protocols set Named Pipes as enabled and #1, set TCP/IP as enabled and #2
  3. SQL Server 2005 Configuration Tools Surface Area Configuration for Services and Connections selected Local & Remote connections using both TCP/IP and Named Pipes is selected
  4. Turn off Auto_Close for SQL 2005/2008 Express


Does anyone have any other suggestions?



What do you have assigned as the server in Store Ops Administrator - File - Configuration? - We typically use (local) -- with the parentheses -- when the db is local. I've also seen 127.0.0.1 or less often a period (.) which also means "local" in SQL (though not sure if an all versions of SQL). Setting (local) as the server is what we typically do - Check also event viewer and recent windows updates for what may have changed. - hope this helps.

"ck > I have a customer running RMS v2 SP3 on a Win XP Pro SP3 system that just

I have a customer running RMS v2 SP3 on a Win XP Pro SP3 system that just started getting this error. The system has the RMS database locally with a fixed IP. They get the error multiple times a day and the systems locks completely. Up until a week ago they had no problems.

Database connection lost, application will be closed. Error #-2147467259

We have:

  1. reinstalled both RMS v2 sp3 and SQL Express 2005 2. In SQL Server 2005 Configuration Tools Client Protocols set Named Pipes as enabled and #1, set TCP/IP as enabled and #2 3. SQL Server 2005 Configuration Tools Surface Area Configuration for Services and Connections selected Local & Remote connections using both TCP/IP and Named Pipes is selected 4. Turn off Auto_Close for SQL 2005/2008 Express

Does anyone have any other suggestions?

I found this fix at

formatting link
formatting link
Although the description sounds like a problem specific to Word, this note claims it is quite general.

Note This issue also occurs for a MAPI-based e-mail client other than Microsoft Outlook.

I applied the hot fix and now I can email from Simply Accounting Version 2007 Pro. I am using Windows Live Mail 2011 beta, I upgraded the email as I thought that was the problem.

Jim

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required