VFP6需要有关数据库错误的帮助 [英] VFP6 Need help on database errors

问题描述

大家好日子，



我需要帮助解决基于VFP6的公司工资单系统上的某些数据库问题。 



当前设置是我们有一个桌面（win10）作为"服务器"，VFP6和工资单应用程序与
整个工资单数据库一起安装在那里。然后将VFP6安装到客户端PC，并通过通向服务器的工资单应用程序快捷方式连接到服务器。工资单应用程序可通过服务器的网络驱动器直接访问，数据由多个
用户编码。



我的唯一问题是我们已经在这个win10桌面上达到了20个并发连接限制，而且我已经在使用Windows Server 2008或基于Linux的服务器设置
了一个真正的服务器（看起来在ubuntu服务器，centos或debian w / samba4）。将工资单系统转移到这个新服务器，最后设置一个域。



现在几个月系统工作正常，几个由于我们混合的网络环境以及我们老化的硬件产生的问题，这里和那里都会出现问题。但上周突然间工资单系统出现了疯狂，我发现数天内没有保存数天的编码数据。我的编码器可以在几周前看到编码数据，但是编制的数据和保存的
不会在数据库中注册。还有一些错误，例如"记录超出范围"。和数据库没有更新。说实话，我是VFP的新手，我真的不知道如何排除这些错误。所以，如果你们有任何
的提示，我会很乐意欣赏它。谢谢

Good day to you all,

I need help on troubleshooting some database problems on our company payroll system that is based on VFP6. 

Current setup is we have one desktop(win10) that serves as the "server", VFP6 and the payroll app is installed there along with the entire payroll database. VFP6 is then installed to the client pc and connects to the server via a payroll app shortcut leading to the server. The payroll app is directly accessed through the server's network drive and the data is being encoded to it by multiple users.

My only issue then is that we're already hitting the 20 concurrent connection limit on this win10 desktop, and I'm already in the process of setting up a real server with either a windows server 2008 or a linux based server(looking at ubuntu server, centos or debian w/samba4). Transfer the payroll system to this new server and finally setup a domain.

Now for a couple of months the system was working fine, a couple of hiccups here and there due to our mixed network environment and problems from our aging hardware. But all of sudden last week the payroll system went bonkers, I found out that a couple of days of encoded data was not saved in the database. My encoders could see the encoded data a couple of weeks back but any encoded data made and saved wont register in the database. There were also a couple of errors like "Record is out of range" and database not updated. Now to be honest I'm a completely new to VFP and I really don't know how to troubleshoot this errors. So if you guys have any tips on how to I would gladly appreciate it. Thanks

推荐答案

正如我在另一个论坛上所说，我要做的第一件事就是重新生成索引如果申请允许的话。

As I said on another forum, the first thing I'd do is regenerate indexes if the application allows it.

添马舰

这篇关于VFP6需要有关数据库错误的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！