Search The ForumSearch   RegisterRegister  LoginLogin

MailBee S/MIME
 AfterLogic Forum : MailBee S/MIME
Subject Topic: SSL Member not found Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
platformexperts
Newbie
Newbie


Joined: 05 December 2008
Online Status: Offline
Posts: 4
Posted: 05 December 2008 at 12:27pm | IP Logged Quote platformexperts
I am using a trial version for MailBee Objects (I just downloaded the latest dll, its 618,496 bytes). When I try to set the POP3.SSL to the SSL object that I created, I get an error that the SSL member is not found. Why is the SSL Member not found?



Back to Top View platformexperts's Profile Search for other posts by platformexperts
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 06 December 2008 at 6:13am | IP Logged Quote Andrew
Please provide us with a part of your source code where you create POP3 and SSL objects and initialize POP3.SSL property. If you have license key specified in the source code, please replace them with something like "my license key".

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
platformexperts
Newbie
Newbie


Joined: 05 December 2008
Online Status: Offline
Posts: 4
Posted: 08 December 2008 at 7:15am | IP Logged Quote platformexperts
This is written in SQL Server using SP_OACREATE. It works properly without using the SSL object (to other mail servers). If you need a full test proc, I can create one for you. When this runs , I get the following output:
--
1
Source: ODSOLE Extended Procedure
Description: Member not found.
error in setting SSL

-- HERES THE CODE SNIPPET

EXEC @Return = sp_oacreate 'MailBee.IMAP4', @Object OUTPUT    

IF @Return = 0    
BEGIN
     EXEC @Return = sp_oacreate 'MailBee.SSL', @sslObj OUTPUT    
     if @return <> 0    
           Begin    
           Print 'error in CREATING SSL'    
           EXEC sp_oadestroy @sslObj    
           EXEC sp_oadestroy @object
           return    
     End
END

if @return <> 0    
Begin    
     Print 'error in create MAILBee object'    
     PRINT 'OLE Automation Error Information'
     EXEC @hr = sp_OAGetErrorInfo @object, @source OUT, @description OUT
     IF @hr = 0
     BEGIN
         SELECT @output = ' Source: ' + @source
         PRINT @output
         SELECT @output = ' Description: ' + @description
         PRINT @output
     END
     

     EXEC sp_oadestroy @Object    
     return    
End      


IF @Return = 0    
BEGIN    

     EXEC @Return = sp_oasetProperty @Object, 'Licensekey',<MY LICENSE KEY>--TRIAL 12/5/08
     if @return <> 0    
     Begin    
           Print 'error in setting Licensekey'    
           EXEC sp_oadestroy @Object    
           return    
     End

     EXEC @Return = sp_oasetProperty @SSLObj, 'Licensekey',<LICENSE KEY>
     if @return <> 0    
     Begin    
           Print 'error in setting Licensekey'    
           EXEC sp_oadestroy @Object    
           return    
     End

EXEC @Return = sp_oaGetProperty @SSLObj, 'Licensed', @ok OUT
print @ok

          
EXEC @Return = sp_oasetProperty @Object, 'SSL', @sslObj
     if @return <> 0    
     Begin    
           EXEC @hr = sp_OAGetErrorInfo @object, @source OUT, @description OUT
           IF @hr = 0
           BEGIN
               SELECT @output = ' Source: ' + @source
               PRINT @output
               SELECT @output = ' Description: ' + @description
               PRINT @output
           END
           Print 'error in setting SSL'    
           EXEC sp_oadestroy @sslObj    
           EXEC sp_oadestroy @object
           return    
     End
Back to Top View platformexperts's Profile Search for other posts by platformexperts
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 08 December 2008 at 8:18am | IP Logged Quote Andrew
Yes, please provide us with full procedure text and exact version of MS SQL Server you use.

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
platformexperts
Newbie
Newbie


Joined: 05 December 2008
Online Status: Offline
Posts: 4
Posted: 08 December 2008 at 9:19am | IP Logged Quote platformexperts
You can Create this on SQL Server 2000. When I run it with my License Keys I get Licensed=1.
--------
CREATE Proc getemails_TEST
as
DECLARE @Object INT    
DECLARE @Return INT    
declare @mailobject int
declare @attachobject int
DECLARE @HR INT   
declare @source varchar(1000)
declare @description varchar(1000)
declare @OUTPUT VARCHAR(1000)   
declare @ok int
declare @errCode int
declare @fromemail varchar(100)
DECLARE @rc bigint
DECLARE @maxSize int
DECLARE @sslObj int

SET @maxSize = 3000000 --in bytes
SET @ErrCode = 0

SET NOCOUNT ON

--create the sPOP object    
--EXEC @Return = sp_oacreate 'MailBee.POP3', @Object OUTPUT    
EXEC @Return = sp_oacreate 'MailBee.IMAP4', @Object OUTPUT    
if @return <> 0    
Begin    
     Print 'error in create MAILBee object'    
     PRINT 'OLE Automation Error Information'
     EXEC @hr = sp_OAGetErrorInfo @object, @source OUT, @description OUT
     IF @hr = 0
     BEGIN
         SELECT @output = ' Source: ' + @source
         PRINT @output
         SELECT @output = ' Description: ' + @description
         PRINT @output
     END
     
     EXEC sp_oadestroy @Object    
     return    
End      

EXEC @Return = sp_oacreate 'MailBee.SSL', @sslObj OUTPUT    
if @return <> 0    
Begin    
     Print 'error in CREATING SSL'    
     EXEC sp_oadestroy @sslObj    
     EXEC sp_oadestroy @object
     return    
End      

      --set the Host   
     EXEC @Return = sp_oasetProperty @Object, 'Licensekey', '<LICENSE KEY>'
     if @return <> 0    
     Begin    
           Print 'error in setting Licensekey'    
           EXEC sp_oadestroy @Object    
           return    
     End

     EXEC @Return = sp_oasetProperty @SSLObj, 'Licensekey','<LICENSE KEY>'
     if @return <> 0    
     Begin    
           Print 'error in setting Licensekey'    
           EXEC sp_oadestroy @Object    
           return    
     End

EXEC @Return = sp_oaGetProperty @SSLObj, 'Licensed', @ok   OUT
print 'Licensed=' + ltrim(str(@ok))

          
EXEC @Return = sp_oasetProperty @Object, 'SSL', @sslObj
     if @return <> 0    
     Begin    
           EXEC @hr = sp_OAGetErrorInfo @object, @source OUT, @description OUT
           IF @hr = 0
           BEGIN
               SELECT @output = ' Source: ' + @source
               PRINT @output
               SELECT @output = ' Description: ' + @description
               PRINT @output
           END
           Print 'error in setting SSL'    
           EXEC sp_oadestroy @sslObj    
           EXEC sp_oadestroy @object
           return    
     End

EXEC sp_oadestroy @Object    
EXEC sp_oadestroy @MailObject    
EXEC sp_oadestroy @AttachObject
GO
Back to Top View platformexperts's Profile Search for other posts by platformexperts
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 09 December 2008 at 6:13am | IP Logged Quote Andrew
Thank you. We've reproduced the issue. It seems SQL Server applies some limitations on passing objects through properties. If you're interested in customized version of MailBee Objects (would have SSL enabled out-of-box, to avoid assigning in SQL Server), please contact us through Request Support form.

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
platformexperts
Newbie
Newbie


Joined: 05 December 2008
Online Status: Offline
Posts: 4
Posted: 09 December 2008 at 6:59am | IP Logged Quote platformexperts
Is that same limitation on SQL 2005?

Back to Top View platformexperts's Profile Search for other posts by platformexperts
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 09 December 2008 at 7:03am | IP Logged Quote Andrew
We've tested it with SQL Server 2000 only.

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide