Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
handarohit
Starting Member
14 Posts |
 Posted - 2004-05-26 : 02:38:52
|
| On using the sp_oamethod I get the follwoing errorerr number : -2146827859err source : my DLL nameerr desc : ActiveX component can't create objectcan neone suggest as to what can be the probable reason for this |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-26 : 02:47:55
|
| Do you definitely have the dll installed on the server properly ?Damian |
 |
|
|
handarohit
Starting Member
14 Posts |
Posted - 2004-05-26 : 02:53:27
|
| yeah the DLL is properly installed on my server--rohit |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-26 : 02:57:26
|
| Does the database account have System Adminsitrator permissions ? SP_OACreate won't work without them.Damian |
|
|
|
handarohit
Starting Member
14 Posts |
Posted - 2004-05-26 : 02:58:14
|
| my SP_OAcreate is working just fine, yes the account is having SYS admin permissions |
|
|
|
handarohit
Starting Member
14 Posts |
Posted - 2004-05-26 : 03:03:03
|
| exec @hr = sp_OAMethod @ialert, 'SendExpiryOfMMBTermAlert("rsinmailfront.india.rsystems.com")',nullthe above mentioned is the command I am usingI am able to create objects if I use the same DLL, class and methods in a VB application |
|
|
|
|
|
|
error in sp_oamethod execution