Failed to apply updates to NTEXT fields
Posted: Wed 08 Apr 2009 16:49
Hi,
Moving from older C++ Builder 6 to newest RAD 2009 C++ Builder to make Unicode support enabled for our clients.
SDAC components are on RDM in our DataSnap apps server,
to which we connect from client side by using:
TDataSource->TClientDataSet->...DataSnap connectivity...->RDM->TDataSetProvider->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB.
Found, that everything working well, except we cannot update NTEXT fields with Unicode string in SQL Server DB, only AnsiString compliant...
However, when shorted up the chain of components, to eliminate TDataSetProvider:
TDataSource->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB
- it works well.
Full chain works well with standard CodeGear dbExpress components
istead of TMSQuery and TMSConnection
However, we do like to move away from SDAC ...
Created and send to your support email address test project, which demonstrates this problem even in single application.
Please investigate the problem and let us know, it is a full conversion stopper for us.
Moving from older C++ Builder 6 to newest RAD 2009 C++ Builder to make Unicode support enabled for our clients.
SDAC components are on RDM in our DataSnap apps server,
to which we connect from client side by using:
TDataSource->TClientDataSet->...DataSnap connectivity...->RDM->TDataSetProvider->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB.
Found, that everything working well, except we cannot update NTEXT fields with Unicode string in SQL Server DB, only AnsiString compliant...
However, when shorted up the chain of components, to eliminate TDataSetProvider:
TDataSource->TMSQuery->TMSUpdateSQL->TMSConnection->SQL Server DB
- it works well.
Full chain works well with standard CodeGear dbExpress components
istead of TMSQuery and TMSConnection
However, we do like to move away from SDAC ...
Created and send to your support email address test project, which demonstrates this problem even in single application.
Please investigate the problem and let us know, it is a full conversion stopper for us.