Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Serious ploblems building 3-tier appl. using TWebConnection and IIS.

Status
Not open for further replies.

GeppoDarkson

Programmer
Oct 9, 2002
74
IT
Hi,
I've found several problems trying to build tree tier applications.

I'm using D7, Win2kSrv as Client and server (IIS)

Step by step I've done this:

[SERVER]
New Application, New RemoteDataModule.
I've put on the RemoteDataModule an AdoConnection (using Microsoft Jet 4.0 Ole DB provider and MsAccess as database),
tree AdoTable whith tree DataSetProvider.
The AdoConnection makes one Beep on AfterConnect and two Beeps on AfterDisconnect.

On IIS i've created a new Web, giving "Scripts and Executables" as Execute Permissions,
and i've put the httpsrv.dll on the site.
I've Register the server (C:\Mysrever\MyServer.exe /regserver)


[CLIENT]
a TWebConnection, a DataSource, a ClientDataSet and a DbGrid.



I've set the WebConnection1.url to my Website,
and i'm able to get the ServerName (and ServerGUID)

I'm connecting using Internet (not local Lan).

After many trying changing the TClassInstancing and TThreadingModel,
the best i've get is a systems that *!*sometimes*!* can support 3 clients that opens the same table,
using this settings:

*************
(...)
initialization
TComponentFactory.Create(ComServer, TATSoftDb4Web,
Class_ATSoftDb4Web, ciSingleInstance, tmFree);
*************

The client crashes with the Exception: Could not convert variant of type (Dispatch)
into Type (Integer).

The Client starts with TWebConnection connected, and the table starts Close (it could be opened with a button).
The error coms out when the program starts.
On the server I've heard one beep (AdoConnection.AfterConnect) and after 0.5 sec Two beeps (AdoConnection.AfterDisconnect)


I'm seriously worried, because I can't find useful documentation,
(except "Accademic" whitepapers), and I have to do a BIG project based
on this technology.

I hope it's realy works (in Delphi we trust).

Any suggestions would be appreciated.

Thank You,

Carlo.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top