On the client pc where you installed vb and the sp, you will find those in c:\windows\system32 directory. Copy all rich*.* files to the same directory on the server and...

Just install vb 6.0, then the service pack on the server, and then uninstall vb (if licencing is an issue or if you are not supposed to install developer tools...

oh, didn't realize that. VB and sp needs to be installed on the server, not the client, remember that the code executes on the server and only the result is...

try this sp:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9EF9BF70-DFE1-42A1-A4C8-39718C7E381D&displaylang=en

Also when I tried on my 2005 server, I first got the following error:

"Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to procedure 'sys.sp_OACreate' of...

You have mentioned that you installed VB 6.0, did you also install the latest service pack? my experience has been that it works only after installing the SP.

My trick has been to install and then uninstall VB 6.0 (with latest sp) and it works!