I am using commands such as
Set Connection = Server.CreateObject("ADODB.Connection") and similarly for the result set.
My problem may be more funadmental as I have just learned I need to install PWS or IIS for this to work. None of the material I read pointed this out explicitly.. Just listed code and said how to connect to data base. I may not be able to install such components due to security issues.
If this is the case.. I still need a way to access data base without a server side script that requires OS features that are not currently supported on my workstation.