I do a lot of Web development and one of the problems I find is that the constants (adCmdStoredProcedure) used to indicate command types are rarely defined outside of an MS app. For example, I use DreamWeaver quite a bit.

I have the ADO2.6 command reference book, and yes, in appendix B it has the definitions of these constants, but wouldn't it be great if someone wrote a book that listed the constants and their values before the example code?

Incidentally, I have a problem where I am trying to access two separate databases within a Site Server implementation.

If I have a page that accesses my user database using my connection string then everything works OK. Ditto the Site Server functionality.

If I try and use both together on the same page everything goes beserk!

I have tried defining two separate connections but I keep getting Accessed Denied error messages.

Both SiteServer and my user databases are using Windows Integrated security. Both have the required user set up and yet I still get Access Denied!

If I use SA then I am allowed in but there is no way I want to release a piece of code that uses the SA login and password!

Has anyone had anything similar?