I tried creating a really basic ActiveX component for distribution on a corporate LAN:
Place an ADO Data Control and a text box on the form. Tie the text box to the data control. Configure the ADO control point to a SQL Server database, using a stored procedure to return a recordset.
When I preview in VB, it comes up fine. I can navigate through the database fine.
So I compile it to an OCX, create an Internet package for it (using all the defaults), use frontpage 2000 to add the .CAB and .HTM files to a web site.
When I access the .HTM from my machine it comes up fine. When I log onto a machine without VB installed, the page comes up fine, the .OCX is downloaded fine, but the data control appears grayed and I can't do anything with it.
This is my first web project & I don't understand what I'm doing wrong.