在IIS7/Classic ASP中缺失值

I have a development server and a live server. Both are Windows Server 2008 running IIS7 and SQL Server. I have identical databases on both which I'm accessing using Classic ASP.

我有一个开发服务器和一个活动服务器。它们都是运行IIS7和SQL Server的Windows Server 2008。我使用Classic ASP访问了两个相同的数据库。

On my development server, everything works fine and I can create a recordset with all of the data as expected. On my live server exactly the same is true, except that in the recordset being returned, one of the field values (i.e. one of the columns) is empty. I've run a query on the server in SQL Server and the data is definitely there, but the ASP page is not fetching it.

在我的开发服务器上，一切都运行良好，我可以创建一个记录集，其中包含预期的所有数据。在我的live服务器上完全相同，除了在返回的记录集中，字段值之一(即列之一)是空的。我在SQL服务器上运行了一个查询，数据肯定在那里，但是ASP页面并没有取回它。

Given that everything is pretty much identical on the two servers and one works and one doesn't, it looks like it might be the way Classic ASP is set up on IIS7. The field value that's not being returned is a varchar(MAX) with maybe 100 characters. Is there anything in Classic ASP on IIS7 that could prevent this data from being returned to the ASP page?

考虑到这两个服务器上的所有东西几乎都是相同的，一个工作，另一个不工作，看起来这可能就是在IIS7上建立经典ASP的方式。没有返回的字段值是一个varchar(MAX)，可能有100个字符。在IIS7上的经典ASP中有什么东西可以阻止这些数据返回到ASP页面吗?

Thanks

谢谢

2 个解决方案

#1

What is your connection string?

您的连接字符串是什么?

From this link, it looks like certain older providers, like SQLNCLI, have issues. Try SQLOLEDB or SQLNCLI10.

从这个链接可以看出，某些较老的提供者(如SQLNCLI)有问题。尝试SQLOLEDB或SQLNCLI10。

More info from MSDN.

更多的信息从MSDN。

#2

Is the result coming from a string concatenation ?

结果来自字符串连接吗?

Perhaps the development server has CONCAT_NULL_YIELDS_NULL set to OFF and the live to ON.

也许开发服务器的CONCAT_NULL_YIELDS_NULL设置为OFF, live to设置为ON。

(this is a SQL Server setting and not an IIS one..)

(这是一个SQL服务器设置，而不是IIS设置。)

#1