Microsoft Dynamics RMS (Archived)

database connection lost, application will be closed error #-2147467259

(0) Share

Report

Posted on by Community Member Microsoft Employee

database connection lost, application will be closed

error #-2147467259

[DBNETLIB][ConnetionRead(recv()).]General network error. Check your network documentation.

(Source:Microsoft OLE DB Providerfor SQL server)
(SQL State : 08s01)

(NativeError :11)

No help file available

SET NOCOUNT ON

SELECT TransactionHold.ID,

TransactionHold. TransactionTime As Date,

ISNULL(Customer.LastName,") As CustomerName,

TransactionHold.HoldComment

FROM TransactionHold

LEFT OUTER JOIN Customer ON Customer.ID = TransactionHold.Customer ID

WHERE(TransactionHold.CustomerID=?) OR(? = 0) ORDER BY TransactionHOLD.Id

I am getting above error every 3~4 hours.

even I am not using.

what is wrong??

RMS 2.0, SQL server 2008 r2, 2 workstations.

*This post is locked for comments

All responses (12)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

support.microsoft.com/.../en-us
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

Hello,

I think you may want to look into this KB article:

"support.microsoft.com/.../en-us"

This is a good source of information if have, in general, connection problems. I am having the same issue lately and I am in the process of using this suggestions. Also, look into other similar post in this forum.

Thanks,

pappu
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

Try this on the RMS POS PC:

Start SQL Administrator

File

Connect

Enter Password

File

Configuration

Connection Timeout: Check your number. If it's too high, reduce. If too low, increase. Test Database Connection. You may have to play with the numbers (if the problem re-occurs) on the day the error happens again.

Note that you can also use the same procedure for playing with the timeout number under 'SQL Administrator' if installed on the RMS POS PC.

I would start by making both timeouts the same number on the server & POS.
Gerald Rothaus 2,930 on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

Check the network card in the server. Make sure you have a good switch too. Suffer do those who use crummy equipment.
Suggested answer

eliud mugo 1,440 on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

Try checking whether you have power cables near your LAN cables.If okay you might i recommend you to upgrade to the latest RMS
Suggested answer

archelle16 1,735 on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

its obviously loosing your connection to the server. I guess you are trying to connect to your server in network. Verify your connection settings.
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

even i change my LAN card but still the problem is same as above user.
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

Make sure you make that change on all your computers. You may want to then start looking at your network hardware.
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

I already unchecked the Allow the computer to turn off this device to save power.

But still same issue

any other idea??
Community Member Microsoft Employee on at

Like (0)

Report

RE: database connection lost, application will be closed error #-2147467259

You can use Device Manager to change the power management settings for a network adapter. To disable this setting in Device Manager, expand Network Adapters, right-click the adapter, click Properties, click the Power Management tab, and then clear the Allow the computer to turn off this device to save power check box.