Database connection lost, application will be closed ERROR

[Robert]

While testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not take a
chance of this happening on production system

Robert

 

[Robert]

Sometimes i also get this message on top of the one i described before


"""""""""""""
Run-time error '-2147221504(80040000)
SQL Server does not exist or access denied
ConnectionOpen(connect())


"""""""""""""""""""""

 

[convoluted]

Robert - even though the server is "local", if there's an issue with the
network connection the application will close. Try to troubleshoot your
network connection (ie patch cable, NIC, port on switch, etc) - test it by
first disconnecting the network cable and then starting store ops manager -
since the local area connection status will be "disconnected" when you start
the application, and since that status will not change, the application
should not kick you out. Hope this helps....

 

[Jeff @ Check Point Software]

Robert,

When are you getting this error?

If at the end of a debit card sale, delete the HTML window in SO Admin | Configuration | Register | Status screen

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

While testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not take a
chance of this happening on production system

Robert

 

[Robert]

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few hours.

Robert

 

[LakeGator]

I have a single PC setup as well. A few weeks ago I attached the
system to a wireless router so I could use a laptop to do some data
access. The router seemed to do resets randomly on the LAN side, at
least. Every time the LAN link would drop the connection to the
database error would follow.

So, do you have a LAN connection that is, perhaps, dropping out from
time to time?

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few hours.

Robert

:

Robert,

When are you getting this error?

If at the end of a debit card sale, delete the HTML window in SO Admin | Configuration | Register | Status screen

Jeff
Check Point Software

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

While testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not take a
chance of this happening on production system

Robert- Hide quoted text -

- Show quoted text -

 

[John M.]

We have suddenly started having this problem - after years of running RMS.
I did add a wireless router to the setup, but the POS/DB server system is
not attached to the router. The other piece to the puzzle is this did not
happen until after I upgraded the database from MSDE to SQL Server 2005 as a
pre-req before going to RMS 2.0 (which I have not done yet). Don't know if
this real culprit?

--

John M.

I have a single PC setup as well. A few weeks ago I attached the
system to a wireless router so I could use a laptop to do some data
access. The router seemed to do resets randomly on the LAN side, at
least. Every time the LAN link would drop the connection to the
database error would follow.

So, do you have a LAN connection that is, perhaps, dropping out from
time to time?

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few
hours.

Robert

:

Robert,

When are you getting this error?

If at the end of a debit card sale, delete the HTML window in SO Admin
| Configuration | Register | Status screen

Jeff
Check Point Software

You must be using Outlook Express/Windows Mail or some other type of
newsgroup reader to
see and download the file attachment(s). If you are not using a
reader, follow
the link below to setup Outlook Express. Click on "Open with
newsreader"
under the MS Retail Management System on the right.

messageWhile testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech
your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS
is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not
take a
chance of this happening on production system

Robert- Hide quoted text -

- Show quoted text -

 

[Jeff @ Check Point Software]

Robert,

Look to see if you have a sleep function turned on for the NIC.

Control Panel | System | Hardware tab | Device Manager button | double on Network Adapters | double click on your adapter | Power Management tab | uncheck Allow the computer to turn off this device...

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few hours.

Robert

 

[Robert]

Well this might be the problem.

I was able to duplicate this error on my desktop /server computer.
When i unplug the cable or disable the adapter i get the error.
The interesting part is;

If i disable or unplug the network card/cable than start RMS software than
enable plug in the network cable, the error does not occur even if i disable
unplug the cable over and over.
The error only occurs if I run RMS software after you established the
network connection, as one normally would.

For now i know how to prevent it but its a bit troublesome solution.


Robert

Robert,

Look to see if you have a sleep function turned on for the NIC.

Control Panel | System | Hardware tab | Device Manager button | double on Network Adapters | double click on your adapter | Power Management tab | uncheck Allow the computer to turn off this device...

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few hours.

Robert

Robert,

When are you getting this error?

If at the end of a debit card sale, delete the HTML window in SO Admin | Configuration | Register | Status screen

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

While testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not take a
chance of this happening on production system

Robert

 

[Kat Straub]

Robert,

Any way you can give me more of an outline on what you did to fix this
problem? I am getting the same error message (I have two computers networked
together). I get the error message on both computers, but the host computer
(our POS) gave me that message about 20 times at least today. I tried
unplugging the network cable and replugging it back in and then opening up
and connecting RMS, but that did not work for me.

I am also getting a really odd blue screen on our back computer that says "A
problem has been detected and windows has been shut down to prevent damage to
your computer. If this is the first time you've seen this stop error screen,
restart your computer. If this screen appears again, follow these steps:
Disable or uninstall any anti-virus, disk defragmentation, or backup
utilities. . . ."

Any ideas what is going on here?

Thanks,
Kat

Well this might be the problem.

I was able to duplicate this error on my desktop /server computer.
When i unplug the cable or disable the adapter i get the error.
The interesting part is;

If i disable or unplug the network card/cable than start RMS software than
enable plug in the network cable, the error does not occur even if i disable
unplug the cable over and over.
The error only occurs if I run RMS software after you established the
network connection, as one normally would.

For now i know how to prevent it but its a bit troublesome solution.


Robert

Robert,

Look to see if you have a sleep function turned on for the NIC.

Control Panel | System | Hardware tab | Device Manager button | double on Network Adapters | double click on your adapter | Power Management tab | uncheck Allow the computer to turn off this device...

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

I get this at random, sometimes the system is idle and when i look at the
screen it shows up.
There doesn't seem to be any pattern,
Sometimes i will get the error after 30 minutes sometimes after few hours.

Robert

Robert,

When are you getting this error?

If at the end of a debit card sale, delete the HTML window in SO Admin | Configuration | Register | Status screen

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

While testing RMS 2.0 I'm getting this error

"""""""""""""""""""""""""""""""""""""""""""""""
Database connection lost, application will be closed
Error #-2147467259
[DBNETLIB][ConnectionWrite (send()).]General network error. Chech your
network documentation.
(Source:Microsoft OLE DB Provider for SQL Server
(SQL State: 08S01)
(NativeError: 11)
No Help file available

SELECT GETDATA() AS CurrentDateTime
"""""""""""""""""""""
the odd part is that i'm getting this error on a single PC setup(POS is the
database server) no network connections to server, database is local.
Anyone knows what might cause this and how to fix this ?
I'm not sure if i loose any data when this happens, but i can not take a
chance of this happening on production system

Robert