🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #23

SOAP with OpenSSL on IIS 5

#23
From: Sydney Delieu
Date: Fri, 12 Sep 2003 19:32
40 lines
2479 bytes
Hello,

I have a client application that connects to an MS-SQL Server database over
the Internet. 'Force Protocol Encryption' is ticked under the 'Server
Network Utility' for MS-SQL, and a self-generated OpenSSL certificate is
installed on the server. The client app uses a TADOConnection and numerous
TADOQueries.

I am now experimenting with converting this application to a 3-tier
architecture using SOAP. The client application now uses a TSoapConnection
with a number of TClientDatasets. All works well when TClientDataset->URL
uses HTTP. However, when I try to use HTTPS for the URL of the
TSoapConnection I get the following error:

---------------------------
Debugger Exception Notification
---------------------------
Project SoapClient.exe raised exception class Exception with message 'The
certificate authority is invalid or incorrect -
URL:https://123.123.123.123/cgi-bin/SoapServer42.exe/soap/ISoapDataMod42 -
SOAPAction:http://www.borland.com/namespaces/Types-IAppServerSOAP'. Process
stopped. Use Step or Run to continue.
---------------------------
OK   Help
---------------------------

I know that this is because the certificate is not trusted. Is there any way
around this? Can I ignore the fact that the certificate is not trusted and
use it anyway?

Many thanks in advance for any help.

Syd.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 01/09/2003
Technical Details
Message-ID: <3f621f69$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,18b629836ff6ed7b,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2003-09-12 12:39:56 PST
From: "Sydney Delieu" <sydbee@supanet.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: SOAP with OpenSSL on IIS 5
Date: Fri, 12 Sep 2003 20:32:52 +0100
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.105.221.20
Message-ID: <3f621f69$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1063395177 213.105.221.20 (12 Sep 2003 12:32:57 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail