Devart Forums

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.

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

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. 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.

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

Thanks for the feedback.