ado typelibrary in global.asa not recognized

[charlotte49er]

I have an application in IIS called "flood_warn." In that directory I have a global.asa file with two includes:

<!--
  METADATA TYPE=&quot;typelib&quot; 
	FILE=&quot;C:\Program Files\Common Files\System\ADO\msado20.tlb&quot; 
-->
<!--
  #include file=&quot;asp_scripts\ErrorHandler.asp&quot;
-->

However, when I try to open a recordset within an asp page I receive the error message "Variable is undefined: 'adOpenStatic'."

Here is the line of code in the asp page:

theRS.open sqlStatement, oConn, adOpenStatic, adCmdTable

I have tried modifying 'adOpenStatic' to 'ADODB.adOpenStatic' with no luck. The code in the asp page itself is sound because if I move the includes into the page everything works as intended. Could anyone please provide some suggestions? Thanks.

 

[baddos]

<!--
METADATA TYPE=&quot;typelib&quot;
FILE=&quot;C:\Program Files\Common Files\System\ADO\msado20.tlb&quot;
-->

This needs to be before the <script> tags.

 

[charlotte49er]

The includes shown in the previous post are before any script tags. Any other ideas?

 

[baddos]

Well... I don't think you can do SSI includes in your global.asa. Remember that the global.asa file isn't an .asp page or shtml page. The global.asa is a special script that doesn't use IIS (which processes the SSI includes).

 

[Questionaire]

Dear
use the 'adodb.inc' include file to include in your page to get the constant value from this file for 'adopenstatic' variable.