Beginner need help with SOAP Server and Clients SOAPConnection

Mark

2009-03-11 22:18:09 UTC

Post by Mark
I use the SOAP Server Application wizard to create
a CGI Standalone Executable
I add a SOAP Server Data Module
On the data module i add a ClientDataSet and connect it to the
biolife.xml file provided by borland
I then add a DataSetProvider and connect it to the ClientDataSet.
///
I have created on my local machine in IIS a web site that runs cgi
executables and have the default file set to the SOAP server
application name (eg. TestSOAPServer.exe)
When i browse to this web site in my local browser i see the expected
Service Info Page for the SOAP Server.
////
I then create a new VCL application in Delphi and add a Data Module to
the project
On the DataModule I add a SOAP Server Connection (TSoapConnection)- I
configure the URL property to the DM address of the SOAP Server
running on my local machine
(eg.http://localhost/TestSOAPServer.exe/soap/IDM)
I then add a ClientDataSet to the DataModule and set its Remote
Connection Property to the SOAP Server Connection and I can then
select from a drop down the ProviderName
After that i can activate the ClientDataSet add a DataSource component
and view all the data from the SOAP Server into via the usual
DataAccess Components.
Everything so far is fantastic....
So my problem which i desperately need help with...
I now put my TestSOAPServer.exe onto a remote server - not my local
machine!
I can still browse to the DataModule of the SOAP Server
(eg.http://www.someaddress.com/TestSOAPServer.exe/soap/IDM)
I can still add the address into my Client apps SOAP Server Connection
Component and it still connects
BUT
In the ClientDataSet - i no longer can connect to the ProviderName - -
I cant even see the providers in the drop down of the property
inspector.
Therefore no data...
I cant figure this one out and im going insane - i need help quick
please...
Thanks in advance
MArk

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

Hi to all who may be trying to help me here -

I have managed to get the above problem resolved - the issue seems to
around the fact that the ClientDataSet on the SOAP server was not
connecting to the data properly therefore im asuming this is the
reason why i could no longer see the provider name in the client app
at design time...

However this has lead me to a massive issue around data connectivity
to Microsoft SQL server.

Could anyone please show me how to connect to Microsoft SQL server
from a SOAP Data Module within a SOAP Server Application generated by
the wizard that comes with Delphi so that i can success connect to it
from my client VCL applications ClientDataset and SOAP Connection
components.

I can connect fine to a SQL server from a standalone win / VCL
application with no problem at all.

I have tried ADO and dbExpress - both connect through fine at design
time but when i compile and build the SOAP Server app and connect from
my clients SOAP Connection component - i loose the ability to see
provider name again

IF I disconect the ADO and or dbExpress components before compiling
and building the SOAP server app - i can see the providers.

This leads me to believe the problems are all to do with connectivity
from the the SOAP Server ap and the Microsoft SQL server in runtime or
something -

Please Please someone help me !!!

Thanks in advance

MArk