Error #-2147467259

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?

Reply to
ck in KS
Loading thread data ...

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

Reply to
convoluted

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?

Reply to
cptsoft

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

Reply to
Jim

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.