Updating data back to datasnap server with FireDac TFDStoredProcedure
I am currently using Delphi XE5 and FireDac to try and create a test app for Datasnap client.
I use a standard TFDQuery on the server side to retrieve the data and send the dataset back to the client.
On the client side I connect to the datasnap server fine using a TFDStoredProcedure. This all works perfectly, but when I try and use ApplyUpdates to write the data back I get an exception and the client crashes.
The questions are:
1. can you use the ApplyUpdates method with FireDac and Datasnap?
2. If so what is the best way of getting the updates back to the datasnap server?
Than...Datasnap Rest client and no datasnap server
it's possible to use a delphi datasnap rest client to consume a rest web services written in other lenguages (like java or php) or i have to use an idhttp (or other) component?
Pasquale Di Giovanni wrote:
> it's possible to use a delphi datasnap rest client to consume a rest
> web services written in other lenguages (like java or php) or i have
> to use an idhttp (or other) component?
You could in theory, but it may be more trouble than its worth. You'd
probably have to have control of the REST server so you can implement
all the...Indy 10
This message is in MIME format. Since your mail reader does not
understand this format, some or all of this message may not be legible.
Content-Type: text/plain; charset="Utf-8"
The udp client component would be used in the datasnap server. The udp
server component would be used in the datasnap client.
UEs...DataSnap REST Server as ISAPI calling a COM Object/Server -> access denied
I have an DataSnap REST Server published on an IIS webserver as ISAPI. The
REST Server calls a COM Server.
If I create a normale VCL test client which calls the COM Server it will
work. If I call the COM Server from the ISAPI I get the error "access
I think it is not a problem of Delphi DataSnap. It should be a problem of
IIS user permissions. Did someone know how to setup IIS user permissions to
Note: If I add the AppPoolUser to the admin group it will work. But it is
not a good idea :-)
...XE Datasnap Client expection with a XE2 DataSnap Server.
I have developed a simple DataSnap Server on XE2 and the client that
connects to this server is under XE.
Everything works just fine except when freeing the ClientProxy Module on the
client side I get the following exception " TDXError with message Invalid
Ordinal 3." followed by a AV.
Any hints how to avoid this exception or the Server must be on XE also?
Thanks in Advance,
I have now the DataSanp Server on XE and the client no longer throws the
So the question now is, it is possible to use a XE DataSnap Client with a
XE2 DataSnap Se...Accessing the One sybase data server from the other data server.
I have a question in Sybase. I have two dataservers and want
to access tables from one data server from another
data server. The sybase version is 12.5
Is it possible to do so?.
On Thu, 28 Oct 2004 19:06:50 -0700, param wrote:
> I have a question in Sybase. I have two dataservers and want
> to access tables from one data server from another
> data server.
Look up proxy tables in the manuals (and the "create existing table ..."
Michael Peppler [TeamSybase] email@example.com - http://w...Connect Old Datasnap Clients with new datasnap Server ? [Edit]
Is it possible to connect a XE5 datasnap server with Borland C++ 6 Datasnap clients ?
I want to know this before starting ...
Edited by: Bart vd Voort vd Kleij on Jan 9, 2014 11:49 PM
Edited by: Bart vd Voort vd Kleij on Jan 9, 2014 11:51 PM
...DataSnap Server Access Violation [Edit]
We are using Delphi 2010 and we build DataSnap Application Servers with DBX components.
We use LifeCycle = Session for the TDSServerClass components.
Of course we’d like to have LifeCycle = Invocation but for Delphi 2010 you know there is a registered problem with the TClientDataSet functionality under “Invocation” mode.
Even with LifeCycle = Session we struggle to keep our logic to be a “stateless” one. Thus we close all connections to DataSnap server when we finish calling a remote method or having the needed data transported to the client.
So we suffer an undefined problem ex...Testing Data Access Components using NUnit and Enterprise Data Access Block
Hi,I have installed the WSF (Web Service Software Factory) and am using it for my development. I know want to test my business layer that calls to my data layer using NUnit. I have a problem though. When I run my project in development mode everything is fine - the database connection is picked up in from the web.config of my Host project. However when I try to run my test library (which is just a class library with the NUnit GUI setup to launch on starting up the class library), I have problem in that there is nowhere to define my database connection in a app.config or web.config file....Datasnap
Database: Firebird 1.5
Server: TADConnection -> TADQuery -> TDatasetProvider
Client: SQLConnection -> TDSProviderConnection -> TClientDataset
I get "Remote Error: Access violation" when executing ApplyUpdates(-1), but I don't get error on my development Notebook.
When I trace on server the error raise between BeforeApply and AfterApply.
Any suggestion welcome.
This information is not sufficient. Could you provide
the call stack of the place where exception is raised ?
With best regards,
Dmitry Arefiev ...FireDAC as DataSnap Server with Firebird Database XE5
I use Firebird Database with Firedac as Server for DataSnap and I don't see my alias on client side.
For example, a query like this don't provide me the TEST Field.
SELECT MU.*, MU.NAME!!' '!!MU.FIRSTNAME AS TEST FROM MYUSERS MU
With dbexpress, it works well.
Somebody notice this ?
> SELECT MU.*, MU.NAME!!' '!!MU.FIRSTNAME AS TEST FROM MYUSERS MU
1) What "!!" means there ?
2) Still if the SQL syntax is correct, then you should set ResourceOptions.MacroCreate and MacroExpand to False:
http://docwiki.embarcadero.com/R...Are DataSnap Servers Thread Safe with DB Components?
We are trying out and designing new DataSnap Server and Client applications.
We have coded our DataSnap server using the TUniQuery component for DB connectivity to a MySQL DB.
In our DataSnap server we have created a ServerMethods class that implements the common functions we will need to talk to the DB and return the data to the Client Apps.
We have been discussing this amongst ourselves, but would like to understand how this will really work...
Is the DataSnap server thread safe? For example we have one TUniQuery component on the ServerMethods class that is used to get the results a...DataSnap vs RemObjects Data Abstract + Relativity Server
Does anyone have any experiences or thoughts about RemObjects DA + Relatvity Server vs DataSnap?
Relativity Server looks like it makes things pretty easy. With DataSnap, creating TSQLQueries on the server, running the server, and adding TClientDataSets on the client is a bit of a pain.
Working is MS SQL Server IDENTITY columns in DataSnap is problematic. TADOQuery works with IDENTITY columns, but doesn't have the best performance. RemObjects claims that their tools provide good performance.
RemObjects has no support for SQL Server's geography datatype and has not p...Transferring data from one database to another both on same DataSnap Server
I have one DataSnap Server with two databases: InterBase and MSSQL; the core database is InterBase and every day I need to transfer the data from one table of MSSQL to the identical table on InterBase, because it is much more simple to manage many other functions of the application directly on the InterBase database. The problem is that I can´t access form Unit1 of DataSnap Server, where I want to make this data transfer using a piece of code, to ServerMethodsUnit1 where are the datasets of both databases
. When I try to access to the ServerMethodsUnit1 datasets I received a Li...