Problem connecting to app server

Emmanuel Lamy

unread,

Jul 11, 2008, 12:34:08 PM7/11/08

to

Hi guys,

I am working my first multi-tier project. A simple server app with 1
ADOTable, connected with a back-end MS SQL database, and 1 DatasetProvider
within a TRemoteDataModule. I want to connect to the server through a
TWebConnection. I installed the web extension "httpsrvr.dll" and set the URL
property of my WebConnection component to the virtual directory wher I put a
copy of the web extension file. I set the permissions on both the virtual
directory and the underlying physical folder where the file is located to
give "Everyone" Read and Execute access. The client app can "view" the
Remote Data Module of the server through the web connection, but when I try
to set the Connected property of the WebConnection to true, I get an "Access
Denied" exception. Any suggestions? TIA.

Emmanuel

Ricardo Carmo

unread,

Jul 11, 2008, 3:52:26 PM7/11/08

to

What is your Web Server? Apache, IIS?
IS it running?

"Emmanuel Lamy" <La...@bellsouth.net> escreveu na mensagem
news:4877...@newsgroups.borland.com...

Emmanuel Lamy

unread,

Jul 12, 2008, 8:02:40 AM7/12/08

to

I am sorry. I haven't specified the technical details:
Web Server IIS 6; running on W2K3; DB: MSSQL 2005; Development tool: Delphi
2007.
I am tempted to believe that this has something to do with W2K3 access
control configuration, because when I change server connection component to
DCOM on the same machine, I can successfully connect with the
RemoteDataModule. But if I run the same client on a different machine, I
receive the same "Access denied" error. And I get the same error, on both
machines, I use a TWebConnection, or a TSocketConnection. Any idea, how I
can get around this? Thanks.

Emmanuel

"Ricardo Carmo" <nwl...@yahoo.com.br> wrote in message
news:4877...@newsgroups.borland.com...

Emmanuel Lamy

unread,

Jul 12, 2008, 8:52:58 AM7/12/08

to

Rectification: After I reboot the server, I could connect with the
RemoteDataModule with a TSocketConnection client running from a remote
machine. But the same "access is denied" keeps coming up when I use DCOM or
a web connection.

Emmanuel

"Emmanuel Lamy" <La...@bellsouth.net> wrote in message
news:48789d70$1...@newsgroups.borland.com...

Ricardo Carmo

unread,

Jul 14, 2008, 8:54:36 AM7/14/08

to

Hi Emmanuel,

I'm afraid that I couldn't help you, but let me say something about your
post:

> >>> TWebConnection. I installed the web extension "httpsrvr.dll" and set
the
> >> URL property of my WebConnection component to the virtual directory
wher I

> >>> put copy of the web extension file. I set the permissions on both the

-I'm using Apache 2 server and Delphi7;
-On Apache, the httpsrvr.dll is in cgi-bin directory, not in htdocs; in
other words,
it's not in a virtual directory, but in "applications" directory.
-The url on the app client is set to cgi-bin directory.
-So, the httpsrvr.dll is in only one directory. No copies is necessary.

I hope that helps you and sorry for my bad english.

Ricardo.

"Emmanuel Lamy" <La...@bellsouth.net> escreveu na mensagem

news:4878a930$1...@newsgroups.borland.com...

Emmanuel Lamy

unread,

Jul 15, 2008, 4:24:46 PM7/15/08

to

Hi Ricardo,

Thank you, Ricardo. Your English is fine to me.

Emmanuel

"Ricardo Carmo" <nwl...@yahoo.com.br> wrote in message

news:487b4d63$1...@newsgroups.borland.com...