I'm trying to determine the best way to update a SQL2000 table over the Internet from an ActiveX control sitting on a clients computer. Clearly I need to avoid establishing a DSN on the clients machine, and am also trying to avoid getting into some type of RDS solution.

I was told that an XML updategram would work well, but I'm not sure this can be accomplished from an ActiveX control. Does anyone have any experience in this area to guide me in the right direction?

Thanks in advance.