I try to use sql dmo (sqldmo.dll) o

[balor]

I try to use sql dmo (sqldmo.dll) on a computer. It works fine when an administrator use my application but it does not work for any other user. First I got error number 70 when I tried to create an instance of sqldmo. When I changed the access rights for the file sqldmo.dll the errormessage changed to "Automation error -2147024770" but it still does'nt work.

Is there any other way to change the rights for using this component?

 

[dky1e]

Are you calling sqldmo methods from sql stored procedure or the client?

 

[balor]

I'm using it from the client (Visual Basic 6). The error occurs when I try to instanciate an object (New).

 

[SpiderBear6]

How are you instanitating it... ie what does the code look like?