Devart Forums

pavelpd

Hi,
Thanks for your request!

Please be informed, that the authentication methods (ADPassword, ADIntegrated, ADInteractive, ActiveDirectoryMSI, SqlPassword) will be added in the next version of the SDAC for the prMSOLEDB provider.

Regarding the Active Directory authentication method - Universal with MFA in SDAC is not supported yet.

pavelpd

Hi,
We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly IBDAC build including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html

pavelpd

Hi Jank,
Thanks for contacting us!

We're glad to see that you've found the cause of the error you mentioned.

Please feel free to contact us if you have any further questions about our products.

pavelpd

Hi!
Thanks for contacting Devart!

Kindly note, that we were unable to reproduce the issue you mentioned based on the data you provided.

Could you please compose a script for creating a stored procedure?
Also, please compose and send us an sample application reproducing the issue you have specified with all necessary DDL and DML scripts to create and populate database objects.

You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

pavelpd

Hi,

Thanks for the info provided!

Please be informed, that we have received your sample and started its investigation.

Once we have an update we will inform you with the results shortly.

Also kindly send us a screenshot of the error you described.

Feel free to reply if you have any questions or need additional information.

pavelpd

Hi Pavel,
Thanks for your request.

TVitrualDataSet component is not designed to copy data. It doesn’t store data in memory.
Its task is to interact with data through event handlers.
It can be used to represent of arbitrary data (arrays, lists etc.) in tabular form.
You can find a more detailed description of the TVitrualDataSet component in our online documentation:
https://docs.devart.com/virtualdac/deva ... ataset.htm

To copy data, use the TVirtualTable component instead of the TVitrualDataSet component.
The TVirtualTable component represents an in-memory data storage that does not have linked data files.
TVirtualTable allows to load data from a XML file, or from an existing dataset, and then process the data in the usual way, as in any TDataSet descendant.
An example of using TCRBatchMove to copy data from TUniQuery to TVirtualTable:

Code: Select all

uses
  ... , CRBatchMove;

  ...
var
  CRBatchMove: TCRBatchMove;
  UniQuery: TUniQuery;
  VirtualTable: TVirtualTable;
  ...
begin
  ...
  CRBatchMove := TCRBatchMove.Create(nil);
  try
    CRBatchMove.Source := UniQuery;
    CRBatchMove.Destination := VirtualTable;
    CRBatchMove.Execute;
  finally
    CRBatchMove.Free;
  end;
  ...
end;

pavelpd

Hi,

Thanks for your request!

In the example you provided, there are no errors regarding the update of the second record since the data is updated according to the specified SQL query "UPDATE" and its "WHERE" statement.

There is no functionality in UniDAC that notifies about the lack of data to update during batch operations.

Feel free to reply if you have any questions or need additional information.

pavelpd

Hi Pavel,
Thanks for contacting us!

To copy data you can use the TCRBatchMove component that comes with our components.
More information you can find using the provided link:
https://www.devart.com/unidac/docs/deva ... chmove.htm

An example of using TCRBatchMove to copy data from TUniQuery to TVirtualTable:

Code: Select all

uses
  ... , CRBatchMove;
 
  ...
var
  CRBatchMove: TCRBatchMove;
  UniQuery: TUniQuery;
  VirtualTable: TVirtualTable;
  ...
begin
  ...
  CRBatchMove := TCRBatchMove.Create(nil);
  try
    CRBatchMove.Source := UniQuery;
    CRBatchMove.Destination := VirtualTable;
    CRBatchMove.Execute;
  finally
    CRBatchMove.Free;
  end;
  ...
end;

pavelpd

Hi Lucas,
Thanks for your request!

Kindly note, that we were unable to reproduce the issue you mentioned in our environment.

We have compiled a sample application based on the data you provided.
https://download.devart.com/sample/f_57335_sample.zip

Please test this application on your side and let us know about the results.

pavelpd

Hi!
Thanks for contacting Devart!

Kindly note, that we were unable to reproduce the issue you mentioned based on the data you provided.

Could you please compose a script for creating a stored procedure?
Also, please compose and send us an sample application reproducing the issue you have specified with all necessary DDL and DML scripts to create and populate database objects.

You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

pavelpd

Hi!
Thanks for your request.

Kindly note, that ApplicationIntent has been added to the latest version of our 9.1.1 driver:

Always On availability groups for the Native Client and MSOLEDBSQL provider is supported

Also, for the DevartSQLServerDirect driver, it will be added in the next version of our driver.

To work with AlwaysOn Availability Groups and to set the workload to read only, you need to apply the "MultiSubnetFailover=True" and "ApplicationIntent=aiReadOnly" options.

Example of the use:

Code: Select all

...
SQLConnection.Params.Values['MultiSubnetFailover'] := 'True';
SQLConnection.Params.Values['ApplicationIntent'] := 'aiReadOnly';
...

Please let us know if there are any questions!

pavelpd

Hi Ron,
Thanks for your request!

Please note, that the AfterConnect occasion is generated by the TSQLConnection component, not by our driver.
We cannot affect the TSQLConnection component.

Also, could you please describe in more details how you restore the connection?

Feel free to ask if you have any questions!

pavelpd

Hey,
Thanks for your request.

The above code example demonstrates the recovery of a lost connection with an attempt to perform the last failed operation, and should not give a connection loss error message.
You can check this behavior in the Demo project supplied with MyDAC.
The project is on the path: "%DemoDir%\MyDAC for RAD Studio 11\Demos\Miscellaneous\FailOver\", where %DemoDir% - is the path to the demo project folder that was defined when you installed MyDAC.
Please describe the exact steps of your actions leading to the error you have specified.
Do you apply additional options other than those described in the example above?

Also please compose and send us an sample application demonstrating the specified behavior.
You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

Please, let us know if you have any questions.

pavelpd

We are glad to see the problem resolved.
Please feel free to contact us if you have any further questions regarding our products.

pavelpd

Hey Lucas,
Thanks for contacting Devart!

We were unable to reproduce the BCD input issue you mentioned. Please provide us with the screenshots of "correct" and "incorrect" data.
If the "EnableBCD" option is active, then the NUMERIC(5) type maps to the TBCDField type in Delphi, and when the "EnableBCD" option is not active, then the NUMERIC(5) type maps to the TFloatField type in Delphi.

Devart Forums

Search found 109 matches

Re: Azure connect with AAD not work

Re: TIBCQuery Error "unable to allocate memory from operating system"

Re: IBDAC 8.1.1 + TIBCAlerter = Error reading data from the connection

Re: Slow data fetch from MSSQL via SP

Re: "Accessor is invalid" when executing stored procedure

Re: ADOQuery.Clone,How to realize

Re: UniDAC and Batch Options - when SQL UPDATE fails to UPDATE

Re: Make copy of DataSet

Re: Driver problem with BCD type

Re: "Accessor is invalid" when executing stored procedure

Re: ApplicationIntent

Re: SPId of Current Connection

Re: Lost connection to MySQL (over internet)

Re: UNIDAC 8.4.3 / delphi 10.4 / firebird 2.5 (UNICODE_FSS)

Re: Driver problem with BCD type