You have to install the latest SQL2000 service pack on you client machine (SP3a at present)
I know this doesn't seem logical, especially since the same code works in VB6 without the latest SP, but I think it may have to do with the COM Interop libraries used and the .Net framework security model.
:cool: