ADO常量

你有两个选择：


a）使用UUID，这意味着你需要知道机器上安装的MDAC版本（你需要在注册表中查看）


b）使用类型库的路径：

<！ - METADATA TYPE =" TypeLib" FILE =" C：\Program Files \ Common

Files \ system \\\\\\\\\\\\\\\\\\\ - >

但是，您需要知道启动分区

的驱动器号（例如c :)。你可以试验（因为只有24个可能的字母，直到你获得正确的字母）


干杯

Ken

" CJM" &LT; CJ ***** @ yahoo.co.uk&GT;在留言中写道

新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ...

：我我试图将内部网应用从一台服务器转移到另一台服务器。我是

：目标服务器上的ADO常量有问题。

：

：我们的Intranet站点在服务器上运行。

：

：在虚拟目录中，我有一个可以访问的独立应用程序

：来自内部网。

：

：我在虚拟目录中的global.asa中有以下内容：

：

：&lt ;! - METADATA TYPE =" typelib"

：NAME =" Microsoft ActiveX Data Objects 2.8 Library" - >

：

：这通常允许我引用ADO常量，例如

：

：设置rsLoc = oConn.Execute（sSQL，iAffected，adCmdText）

：

：但是，在这种情况下，IIS抱怨...变量未定义：

：''adCmdText''

：

：这是一个新的（干净的）服务器，所以我想知道是否有s ome有点

：确认问题......

：

：有什么想法吗？

：

：Chris

：

：PS。我最初列出了2.6 typlib，它也没用。

：

：

You have two options:

a) use the UUID, which means you need to know the MDAC version installed on
the machine (you need to look in the registry to be sure)

b) use the path to the typelib:
<!-- METADATA TYPE="TypeLib" FILE="C:\Program Files\Common
Files\system\ado\msado15.dll" -->
however, you need to know the drive letter (eg c:) that the boot partition
is. You can experiment (since there are only 24 possible letters until you
get the right one)

Cheers
Ken
"CJM" <cj*****@yahoo.co.uk> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
: I''m trying to transfer an intranet app from one server to another. I''m
: having a problem with the ADO constants on the destination server.
:
: Our intranet site runs on the server.
:
: In a virtual directory, I have a seperate application that is accessible
: from the intranet.
:
: I have the following in the global.asa in the virtual directory:
:
: <!--METADATA TYPE="typelib"
: UUID="2A75196C-D9EB-4129-B803-931327F72D5C"
: NAME="Microsoft ActiveX Data Objects 2.8 Library"-->
:
: This usually allows me to refer to the ADO constants, e.g.
:
: Set rsLoc = oConn.Execute (sSQL, iAffected, adCmdText)
:
: However, in this case, IIS is complaining... Variable is undefined:
: ''adCmdText''
:
: This is a new (clean) server, so I''m wondering if there is some kind of
: confirguration issue...
:
: Any ideas?
:
: Chris
:
: PS. I originally had the 2.6 typlib listed, which didnt work either.
:
:

你确定ADO 2.8安装？


可能要检查。


-

Aaron Bertrand

SQL Server MVP
http://www.aspfaq.com/


" CJM" &LT; CJ ***** @ yahoo.co.uk&GT;在消息中写道

新闻：#o ************** @ TK2MSFTNGP09.phx.gbl ...

Are you sure ADO 2.8 is installed?

Might want to check.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"CJM" <cj*****@yahoo.co.uk> wrote in message
news:#o**************@TK2MSFTNGP09.phx.gbl...

我是尝试将Intranet应用程序从一台服务器转移到另一台服务器。我在目标服务器上遇到ADO常量问题。

我们的Intranet站点在服务器上运行。

在虚拟目录中，我有一个可从内联网访问的单独应用程序。

我在虚拟目录中的global.asa中有以下内容：

<！ - METADATA TYPE =" typelib"
UUID =" 2A75196C-D9EB-4129-B803-931327F72D5C"
NAME =" Microsoft ActiveX Data Objects 2.8 Library">


设置rsLoc = oConn.Execute（sSQL，iAffected，adCmdText）

然而，在这种情况下，IIS抱怨...变量未定义：
''adCmdText''

这是一个新的（干净的）服务器，所以我想知道是否有某种
确认问题......

任何想法？

克里斯

PS。我最初列出了2.6 typlib，它也没有用。

I''m trying to transfer an intranet app from one server to another. I''m
having a problem with the ADO constants on the destination server.

Our intranet site runs on the server.

In a virtual directory, I have a seperate application that is accessible
from the intranet.

I have the following in the global.asa in the virtual directory:

<!--METADATA TYPE="typelib"
UUID="2A75196C-D9EB-4129-B803-931327F72D5C"
NAME="Microsoft ActiveX Data Objects 2.8 Library"-->

This usually allows me to refer to the ADO constants, e.g.

Set rsLoc = oConn.Execute (sSQL, iAffected, adCmdText)

However, in this case, IIS is complaining... Variable is undefined:
''adCmdText''

This is a new (clean) server, so I''m wondering if there is some kind of
confirguration issue...

Any ideas?

Chris

PS. I originally had the 2.6 typlib listed, which didnt work either.

" Ken Schaefer" &LT;柯******* @ THISadOpenStatic.com&GT;在消息中写道

news：uH ************** @ tk2msftngp13.phx.gbl ...

"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:uH**************@tk2msftngp13.phx.gbl...

您有两种选择：

的MDAC版本（您需要在注册表中查看以确定）

> b）使用类型库的路径：
<！ - METADATA TYPE =" TypeLib" FILE =" C：\Program Files \ Common
Files \ system \\\\\\\\\\\\\\\\\\\\\\\\\ - >
但是，你需要知道启动分区
的驱动器号（例如c :)。你可以试验（因为只有24个可能的字母，直到你得到正确的一个）

欢呼
肯

You have two options:

a) use the UUID, which means you need to know the MDAC version installed on the machine (you need to look in the registry to be sure)

b) use the path to the typelib:
<!-- METADATA TYPE="TypeLib" FILE="C:\Program Files\Common
Files\system\ado\msado15.dll" -->
however, you need to know the drive letter (eg c:) that the boot partition
is. You can experiment (since there are only 24 possible letters until you
get the right one)

Cheers
Ken

Ken，


注册表中列出的ProgID更新了UUID。它没有用。


那么我尝试了''file =''路线，但也没有运气......


但是，我刚刚意识到一些重要的事情：主要的内部网菜单

是数据库驱动的 - 它使用的是主global.asa

文件中指定的类型库，以及它的工作正常....那么为什么虚拟

目录中的应用程序不会这样做呢？


干杯


Chris

Ken,

I checked in the registry and updated the UUID with the ProgID listed in the
registry. it didnt work.

So then I tried the ''file='' route, but had no luck with that either...

However, I have just realised something significant: The main intranet menu
is DB-driven - it is using the typelib specified in the main global.asa
file, and it works fine.... So why doesnt the application in the virtual
directory do the same?

Cheers

Chris