LightSwitch v1 显示红色 X 并且无法加载数据 [英] LightSwitch v1 shows red X and unable to load data

问题描述

我使用在 Visual Studio 2010 Professional 上运行的 Visual Studio LightSwitch 2011 (v1) 制作了一个应用程序.它是一个桌面应用程序，我使用 SQL Server 身份验证连接到数据库.(所有客户端使用相同的用户名/密码).

该应用程序适用于大多数用户，但对于 4-5 个用户，它显示红色 X 并表示无法加载数据.这是有史以来最模糊的错误消息，我不知道是什么原因造成的.用户都可以从他们的 PC 访问我们的数据库，因为其他一些非灯光开关应用程序运行良好.这排除了任何网络/连接问题.

经过几天的搜索并试图弄清楚这一点，我还没有找到一种简单的方法来确定 red-X 错误的原因是什么.此外，用户位于不同的国家/地区，因此我无法物理访问他们的机器.我唯一需要做的就是这些用户都在运行 Windows 7(没有安装防火墙).其中一个人终于完成了 Windows 7 的全新安装，在安装应用程序时，他收到了 red-X(无法加载数据)错误.

有什么简单的方法可以找出为什么 lightswitch 无法从我们的数据库加载数据?(数据库 = SQL Server 2005)

感谢您的帮助.

解决方案

查看 .同一篇文章中也对此进行了解释.

I have made an application using Visual Studio LightSwitch 2011 (v1) running on Visual Studio 2010 Professional. It is a desktop application, and I use SQL Server Authentication to connect to the database. (Same username/password for all clients).

The application works perfectly for most users, but for 4-5 users, it is showing a red X and says that it is unable to load data. This is the most vague error message ever, and I have no idea what could cause it. The users are all able to access our database from their PCs because some other non-lightswitch applications are working fine. This rules out any network/connectivity issues.

After days of searching and trying to figure this out, I haven't found an easy way to determine what the cause of the red-X error is. Also, the users are located in a different country so I don't have physical access to their machines. The only thing I have to go on is that these users are all running Windows 7 (no firewalls installed). One of them finally did a clean-install of Windows 7, and on installing the application, he got the red-X (unable to load data) error.

Is there any easy way to figure out why lightswitch is unable to load data from our database? (Database = SQL Server 2005)

Thanks for the help.

解决方案

Check out Eric Erhardt's article. Here's a quote:

When your application fails to load data successfully, the screen will display a red X and the tool tip will say "Unable to load data. Please check your network connection and try loading again."

A little known secret about LightSwitch is that the server has a Diagnostics subsystem integrated with ASP.NET tracing. LightSwitch’s Diagnostics subsystem is a lot more powerful than just telling you what exception was thrown when issuing a query. You can use it to trace through the actions that were requested of the server, and what steps the server took in response to each action. So even if things seem to be working, you can get more information about what your application was actually doing.

So you can enable diagnostics then open the trace at: your-lightswitch-application-address/trace.axd. You can then check the error details (screenshot taken from the blog article):

Another alternative way is to use Fiddler. It is also explained in the same article.

这篇关于LightSwitch v1 显示红色 X 并且无法加载数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！