Skip to main content

Notifications

Microsoft Dynamics RMS forum

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

Posted on by 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: database connection lost, application will be closed error #-2147467259

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Gerald Rothaus 2,930 on at
    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 Profile Picture
    eliud mugo 1,440 on at
    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 Profile Picture
    archelle16 1,735 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans