MSADO15.dll how to properly implement it on a web 1

[jazzz]

site being hosted at another location.

Hello, and thanks in advance. I currently use the adovbs.inc on my web site for pages that are used to call my recordsets. I read where it would be smarter to include the msado15.dll in my Global.asa file as a METADATA TYPE.

The example they use in the book is:
<!-- METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->

Since the file will be on my hosting server not my local machine I assume that path will not work? Currently I use the following on the top of my pages to utilize the ADO Constants:
<!--#include virtual="adovbs.inc" -->

I assume I would make my path similar in the above file but I keep getting an error message that the file cannot be loaded. I uploaded the file msado15.dll to my root directory of my site. Can someone explain how to properly implement the dll I want to do this correctly.

Thank You!

Life's a journey enjoy the ride...

jazzz

 

[Sheco]

Check out this page for a way to do it without the file path:

http://www.atgconsulting.com/adotypelibs.asp

Also, check out the bottom of this page for a trick for using Visual Interdev to to create the METADATA tag for any library (not just ADO.)

 

[DotNetGnat]

i guess you need to see something like this for Remote Data Services:

<!--METADATA TYPE="TypeLib" NAME="Microsoft Remote Data Services Server 2.5 Library" UUID="{9381D8F6-0288-11D0-9501-00AA00B911A5}" VERSION="1.5"-->

-DNG

 

[Sheco]

Also, if you dont have Visual Interdev, you can do that trick mentioned in that second link by searching your registry with regedit to get the UUID for any library.

 

[jazzz]

Sheco, If I read the article correctly I should use this line in my Global.asc file:
<!--METADATA TYPE="TypeLib" UUID="{00000300-0000-0010-8000-00AA006D2EA4}" -->

Next question is should I just continue to use my inc file and be damn with what I read? Or is it really giving my page a hit?

Life's a journey enjoy the ride...

jazzz

 

[jazzz]

Guys, this is how it worked for me anyway. In my Global.asa file I added the following line. I am on a Microsoft Server at my hosting service.

<!--METADATA NAME="Microsoft ActiveX Data Objects 2.5 Library" TYPE="TypeLib" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"-->

It works and my pages do load much faster that utilize ADO recordsets that I had used the include page on.

Thank you all for sending me in the right direction.


Life's a journey enjoy the ride...

jazzz

 

[DotNetGnat]

thanks for letting the solution...i was almost correct...

glad everything worked for you...

-DNG

 

[DotNetGnat]

i mean to say...

thanks for letting us know the solution...

-DNG

 

[jazzz]

No problem, thank you guys/gals! This in my opinion is the best place to find an answer or at least come very close. All help is truly appreciated.

Life's a journey enjoy the ride...

jazzz