469,327 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

ADO Constants

CJM
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.
Jul 19 '05 #1
11 4767
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.
:
:
Jul 19 '05 #2
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...
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.

Jul 19 '05 #3
CJM

"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:uH**************@tk2msftngp13.phx.gbl...
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,

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
Jul 19 '05 #4
CJM
Aaron,

Yes I've checked.

Apart from the fact that the main intranet pages work, I've also run the
component checker. MDAC 2.8 RTM is installed.

Any other ideas?

This is running on Windows Server 2003 - previously I've worked with
IIS5/5.1.... I wonder if IIS6 makes a difference...

Chris

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:uc**************@TK2MSFTNGP10.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...
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.


Jul 19 '05 #5
Make sure you have a global.asa file in each ASP application or subweb root.

--
Cheers!

Ryan N.
---------------------------------
Funny...this worked yesterday....
"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.

Jul 19 '05 #6
CJM
As per usual, the problem existed between chair and keyboard..!

My application is actually in a subdir of the intranet content area. This in
itself was a virtual directory.
However, my application directory was NOT a virtual directory, therefore the
global.asa would surely be ignored.

The app directory is now a pukka virtual directory! The application works...

The only think puzzling me now is how/why the app was able to pick up the
connection string which was defined in an application variable in the same
Global.asa??

Chris
Jul 19 '05 #7
Maybe the connection string is also defined in the ROOT's global.asa file.

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


"CJM" <cj*****@yahoo.co.uk> wrote in message
news:O7**************@TK2MSFTNGP10.phx.gbl...
As per usual, the problem existed between chair and keyboard..!

My application is actually in a subdir of the intranet content area. This in itself was a virtual directory.
However, my application directory was NOT a virtual directory, therefore the global.asa would surely be ignored.

The app directory is now a pukka virtual directory! The application works...
The only think puzzling me now is how/why the app was able to pick up the
connection string which was defined in an application variable in the same
Global.asa??

Chris

Jul 19 '05 #8
CJM
It's not in the site root global.asa, and the parent virtual dir doesnt have
one...

Curious...
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:OC**************@TK2MSFTNGP12.phx.gbl...
Maybe the connection string is also defined in the ROOT's global.asa file.

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

Jul 19 '05 #9
> It's not in the site root global.asa, and the parent virtual dir doesnt
have
one...

Curious...


Sorry, without being able to reproduce, I guess you've discovered one of the
world's greatest mysteries.

<shrug>
Jul 19 '05 #10
CJM
"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message news:O%

Sorry, without being able to reproduce, I guess you've discovered one of the world's greatest mysteries.

Luckily, I dont think it is of global significance.
<shrug>


Indeed.
Jul 19 '05 #11
The virtual directory is probably configured as an "Application Root", in
which case you need to put your own global.asa file in the application root
as well. Each Application Root maintains it's own Application/Session state

Cheers
Ken

"CJM" <cj*****@yahoo.co.uk> wrote in message
news:eb**************@TK2MSFTNGP12.phx.gbl...
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: news:uH**************@tk2msftngp13.phx.gbl...
: > 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,
:
: 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
:
:
Jul 19 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Amadelle | last post: by
8 posts views Thread by Marty | last post: by
34 posts views Thread by newsposter0123 | last post: by
17 posts views Thread by Neil Cerutti | last post: by
2 posts views Thread by Leslie Sanford | last post: by
54 posts views Thread by shuisheng | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by listenups61195 | last post: by
reply views Thread by Purva khokhar | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.