I am trying to connect to a database on a remote server using visual basic 6.0. I am using rdoenvironments(0) to get the handle to the environment which I am using to get a connection to the database. This code is working on my PC. However, it doesn't work on the user's PC and gives an error
'ActiveX component can't create object'.
Can someone help me to solve this problem?

thanks,
hema