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
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
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.
Check the network card in the server. Make sure you have a good switch too. Suffer do those who use crummy equipment.
Try checking whether you have power cables near your LAN cables.If okay you might i recommend you to upgrade to the latest RMS
its obviously loosing your connection to the server. I guess you are trying to connect to your server in network. Verify your connection settings.
even i change my LAN card but still the problem is same as above user.
Make sure you make that change on all your computers. You may want to then start looking at your network hardware.
I already unchecked the Allow the computer to turn off this device to save power.
But still same issue
any other idea??
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156