UniLoader problem "Unclosed quotation mark after the character string"

[ertank]

Hi,

Using Delphi 10.1, UniDAC 6.3.13.

I am trying to load from an SQLite3 database into MSSQL-2014 table. SQLite connection is "Direct", and MSSQL Provider is "prDirect". There are some UserDefined data types in MSSQL database. As far as I can see, Loader.Columns() field datatypes are OK.

When I call LoadFromDataSet() function I get an error saying "Unclosed quotation mark after the character string '[1NUMBER_SAYIMDETAY_TEMP]'."

That is my target MSSQL table name displayed above. I selected it by using combo box in the object browser. So, no typing errors there.

It is kind of a long code to prepare source query. I uploaded a sample application including sample MSSQL database backup and SQLite source database.
http://s000.tinyupload.com/index.php?fi ... 2790290828

I appreciate any help.

Regards.

[azyk]

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

[ertank]

Dear azyk,

Thank you for the feedback.

I would like to also add that there is a memory leak when I get this error. If you simply add below line in project somewhere, you'll be able to see that.

Code: Select all

ReportMemoryLeaksOnShutdown := True;

Lastly, I wonder if a patch will be included in next UniDAC release. I know it is very close to release date, just need to know.

Thanks.

[azyk]

We have fixed the bug. The new UniDAC build including the bug fix will be released by the end of the week.

[ertank]

Thanks for the feedback.