|
Posted by Ed Raney on October 1, 2007, 3:58 pm
Please log in for more thread options
Hi Glenn,
The error occurs on all items tried. The database check was performed with
no errors. The network settings were reviewed, the network protocols (Named
Pipes, TCP/IP) were disabled and then reenabled, both computers were
rebooted, the network connections were refreshed, the file printer and
sharing is checked on both computers, and the Windows firewall was turned off
on both computers. The client is now able to copy the same items tried
before.
Thank you for your assistance,
Ed
"Glenn Adams [MVP - Retail Mgmt]" wrote:A
> It sounds like there is bad data in the item they are trying to copy
> from. Do you get the same result when copying ANY Item, or is it
> limited to a specific set of items.
>
> I would suggest creating a Sample DB on that system and pointing SO
> Administrator to that new sample DB. Try copying one of the sample
> items and see if that works. If it does, something has gone bad in your
> live data. First thing to do would be to backup the DB then do check
> and reindex from SO Administrator. That may fix it.
>
> The next thing would be to compare the schema of the live database to
> the sample database; it is possible that a column size has been altered
> on the live DB and the copy process is failing because of that.
>
> Make sure that you don't have any other programs open that might LOCK
> the item table - an example would be MS Access or SQL Management Studio
> with the table open either to show results or in design view.
>
> Glenn Adams
> Tiber Creek Consulting
> http://www.tibercreek.com
> glenn@tibercreek.com
> ----------------------------------------------
> Please DO NOT respond to me directly but post all responses here in the
> newsgroup so that all can share the information.
>
>
> Ed Raney wrote:
> > One of our clients is receiving a Database connection lost Error -2147467259
> > message in Store Operations Manager when copying Items. They are able to
add
> > new items fine. The error occurs when she copies an item, makes changes,
and
> > then saves the item on the back office computer. The Item copy works fine
on
> > POS1. RMS V1.3 Refresh MSDE.
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap