Stack Overflow
Stack Overflow

Questions tagged [datasnap]

DataSnap is a Delphi technology that allows the development of multi-tier applications

DataSnap is a Delphi technology that allows the development of multi-tier applications, most notably multi-tier database applications.

DataSnap offers the possibility to create Client-Server applications that communicate through the Internet, the local network, or the local host.

The main feature of DataSnap is the ability of the Client application to invoke methods that are implemented on a Server. DataSnap automatically generates the necessary interface for the Client to communicate with the Server, containing the prototypes of the Server methods.

http://docwiki.embarcadero.com/RADStudio/en/DataSnap_Overview_and_Architecture

501 questions
5
votes
1 answer

DataSnap server - share DB connection or new connection per client request?

I have a Delphi XE2 DataSnap server (Windows service) connected to a backend MS SQL Server 2008 (same server box) serving REST client requests. Everything has been working great for some time until recently, I had an issue where for some reason the…
Jonathan Wareham
  • 3,357
  • 7
  • 46
  • 82
5
votes
0 answers

How to dynamic load server methods for HTTP datasnap server?

I am using Delphi XE2 DataSnap library. My datasnap server is HTTP based (TIdHTTPWebBrokerBridge or ISAPI). When first access the DataSnap service, the TDSServer instance will register all available server methods via TDSServerMethodProvider.Open…
Chau Chee Yang
  • 18,422
  • 16
  • 68
  • 132
5
votes
1 answer

TCP/IP connectivity via DataSnap

I wrote a multi-tier application suite in Delphi XE, using DataSnap (VCL application). This will be used internally, in my company, mostly to replace the outdated fax communication. Everything works fine, but I came across an unpleasant situation:…
cipnec
  • 147
  • 1
  • 10
5
votes
2 answers

Most efficient way to pass SQL Login credentials to Delphi Datasnap servers?

Using Delphi XE to build a relatively straightforward database app using Datasnap. Since some security in my application is handled at the database level, I need to pass a user's SQL credentials from my client app to my Datasnap server. (I'm trying…
RichardS
  • 536
  • 2
  • 8
4
votes
4 answers

Updating client UI while waiting for DataSnap

I created a MDI Delphi app in Delphi XE2 that connects to a DataSnap server via a TSQLConnection component (driver = datasnap). A right-click on the TSQLConnection at design-time lets me generate the DataSnap client classes (ProxyMethods). My goal…
James L.
  • 9,384
  • 5
  • 38
  • 77
4
votes
2 answers

How do I get a stack trace from a handled/caught exception and dump it to a trace log

We've created a Datasnap service (with Delphi XE), using Bob Swart's white paper as a guide. It works fine, and we've deployed it to our test server. Now a problem occurs, when we have executed a large number of requests (through JMeter), some sort…
Geerten
  • 1,027
  • 1
  • 9
  • 22
4
votes
2 answers

Building a REAL database application using Datasnap

I have built an extensive 2-tier application in D2010, using ADO and devexpress. I want to upgrade this to using Datasnap mainly to provide HTTPS communication instead of just TCP/IP to the vulnerable SQL server. I have followed all the Datasnap…
Freddie Bell
  • 345
  • 3
  • 6
4
votes
2 answers

DELPHI: Multithreaded client/server datasnap error

This is my first post here - so be gentle :-) I want to build a client/server application that uses datasnap for data transport. This is a fairly simple task - and there are lots of examples to learn from. BUT - Having a Datasnap server (build from…
Bimmer_R
  • 588
  • 9
  • 18
4
votes
1 answer

Is there a limit for TClientDataSet filter, or is it a bug?

I'm using a TClientDataSet as an in-memory table and must apply a filter with a lot of conditions. For example, with 400 OR conditions, I get an access violation when I try to enable the filter. Access violation at address 4DAEDC76 in module…
Rodrigo Farias Rezino
  • 2,687
  • 3
  • 33
  • 60
4
votes
2 answers

How to get the client IP in DataSnap 2010

Someone can tell me how to get the client ip of a connected session from the server side?. Thanks
Francis Lee
  • 975
  • 8
  • 23
4
votes
1 answer

big streams with DataSnap

I'm trying to transfer some big streams (~1Mb) between DataSnap server/client but to no avail. I'm trying to understand the code of Jim Tierney (http://blogs.embarcadero.com/jimtierney/2009/04/06/31461) with no luck and i can't even compile the code…
Alin Sfetcu
  • 542
  • 6
  • 16
4
votes
1 answer

Can we use TDSProviderConnection to replace TLocalConnection for in-process DataSnap application?

I able to access server method by in-process DataSnap application. Click here for details. However, there is another aspect of in-process datasnap application. It is the IAppServer or TDataSetProvider. Prior to Delphi 2009, I use TConnectionBroker…
Chau Chee Yang
  • 18,422
  • 16
  • 68
  • 132
4
votes
2 answers

How to consume in process server method with DataSnap 2010

I define a server method: TServerMethod = class(TPersistent) public function EchoString(Value: string): string; end; The method EchoString return an equivalent Value string. I then use TDSTCPServerTransport with TDSServer and TDSServerClass to…
Chau Chee Yang
  • 18,422
  • 16
  • 68
  • 132
4
votes
1 answer

Multiple Connections for a single user

I am trying to figure the best / "correct" place to put the following logic in my Delphi datasnap server. A user connects to the server, and using the credentials provided I validate them using a centralized AuthorizationDatabase (Oracle database). …
Jim Eckels
  • 179
  • 1
  • 8
4
votes
2 answers

DataSnap and Database Connection / Login

I am trying to work out the "right" way to establish a connection to my database from the server of my DataSnap application. Each (most) of my tables in the database have fields (whose values are set via a trigger on insert and update) called…
Jason
  • 2,572
  • 3
  • 34
  • 41
1 2 3
…
33 34