ADOVBS.inc

[damann]

I've never had to use this file ever before, and today I run into someone using it. They said if they don't they'll get an error stating missing ADOVBS.inc or something of that nature? Why is it that I don't this error at all? Is this file even necessary? I'm thinking no since I've never had to use it... What do you'll think?


Damann

 

[yimitz]

Depends, you can dim and set variables to their proper types if you like or just include this file.

I use it when I deal with databases and command procedures. Saves on typing quite a bit and setting ADO variables to the wrong type. If you don't deal with ADO much then no you probably don't need it. I'd say you are missing out on a great deal of functionality if you don't use ASP and databases together.

 

[damann]

I do use ASP and databses together. I've used most of the stuff in that ADOVBS.inc file, like AddNew without ever havinging to include this file. How is that?

 

[GabeC]

ADOVBS.inc doesn't give you the funtionality of ADO, it allows you to use ADO constants without having to declare them yourself. If you look in this file all it does is declare constants. This file is included into your own asp page when the asp page is requested by a user.

A far better solution than using this include file is to use the COM component. You can place this in your global.asa file and then you would not need to include it in all your pages otherwise place this at the top of the pages you need it. Note, you may need to change the path. Ask your system administrator where this dll is located if you do not have access to the server.

<!-METADATA TYPE=&quot;typlib&quot; FILE=&quot;C:\Program Files\Common Files\system\ado\msado15.dll&quot; -->

Don't worry about the name of the dll. 15 is not the version.

One other note. Consider changing the extension of your include files to .asp instead of .inc. Your web server will not show the contents of a .asp file but it will for a .inc file. If a user types in the URL of your .inc file they can see the contents of it. You can setup IIS not to show the contents of a .inc file but it is much easier to just use .asp as the extension.

Hope this helps,

Gabe