“System.FormatException：输入字符串的格式不正确”通过 IIS 7 填充数据集时抛出错误，但 Cassini 中没有错误？

发布于 2024-11-28 05:08:10 字数 800 浏览 1 评论 0原文

Visual Studio 2010 Express、ASP.NET MVC3、C#，在 Windows Server 2008 R2 上具有 ODBC 数据连接。

当使用 Visual Studio 的内置 Web 服务器时，此代码按预期运行，但在通过 IIS7 运行时失败，并出现“System.FormatException”。

OdbcConnection conn = new OdbcConnection("Dsn=MyDSN");
OdbcDataReader reader = null;
string result = "";
try
{
    conn.Open();
    OdbcCommand cmd = new OdbcCommand("select * from my_table limit 3 offset 10", conn);
    cmd.CommandType = CommandType.Text;

    DataSet ds = new DataSet();
    OdbcDataAdapter da = new OdbcDataAdapter(cmd);
    da.Fill(ds); // Fails right here when viewed through IIS7 with a FormatException
    .
    .
    .

……我完全不知所措。我可以接受返回数据中存在导致此异常的可能性，但我希望它也能在卡西尼号中体现出来！

有谁对如何解决此问题有任何建议，或者为什么 IIS7 和 Visual Studio 的内置 Web 服务器之间存在如此大的行为差异？

谢谢！

原文

Visual Studio 2010 Express, ASP.NET MVC3, C# with an ODBC data connection on Windows Server 2008 R2.

This code runs as expected when using Visual Studio's built-in web server, but fails with a "System.FormatException" when run through IIS7.

OdbcConnection conn = new OdbcConnection("Dsn=MyDSN");
OdbcDataReader reader = null;
string result = "";
try
{
    conn.Open();
    OdbcCommand cmd = new OdbcCommand("select * from my_table limit 3 offset 10", conn);
    cmd.CommandType = CommandType.Text;

    DataSet ds = new DataSet();
    OdbcDataAdapter da = new OdbcDataAdapter(cmd);
    da.Fill(ds); // Fails right here when viewed through IIS7 with a FormatException
    .
    .
    .

... I'm at a total loss. I can accept the possibility of there being something in the returned data that causes this exception, but I'd hope it'd manifest itself in Cassini as well!

Does anyone have any suggestions in how to fix this problem or why there's such a difference of behavior between IIS7 and Visual Studio's built-in webserver?

Thanks!

分享到QQ

分享到微博