Page 1 of 1

UniLoader issue with UNIQUEIDENTIFIER column

Posted: Fri 15 Mar 2013 01:26
by yeohray
I have the following table definition:

CREATE TABLE unidactest (
[Identifier] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
[Vendor_Name] [varchar](500) NULL
)

I an using a TUniLoader to load values into the above table. On the OnPutData event, I run the following:

loaderMain.PutColumnData(1, 1, 'Vendor A');

The application will not upload the value, but instead raises the following EOLEDB error: Unspecified error.

If I change the definition of the Identifier column to

[Identifier] [uniqueidentifier] NULL DEFAULT NEWID()

or

[Identifier] [integer] NOT NULL DEFAULT 999

everything works. So it looks like a problem when the column does not accept null values and is a uniqueidentifier column.

Is there some setting I am missing?

Thanks in advance.

Re: UniLoader issue with UNIQUEIDENTIFIER column

Posted: Fri 15 Mar 2013 13:06
by AndreyZ
Thank you for the information. We have reproduced the problem and fixed it. This fix will be included in the next UniDAC version.

Re: UniLoader issue with UNIQUEIDENTIFIER column

Posted: Fri 15 Mar 2013 14:37
by yeohray
If I have a non-source license for Unidac, and a source license for SDAC, would I be able to make the fix myself, while waiting for the official release that includes the fix?

Re: UniLoader issue with UNIQUEIDENTIFIER column

Posted: Mon 18 Mar 2013 08:35
by AndreyZ
As you have only SDAC source code, you can make a fix only for SDAC. Please send your license number to andreyz*devart*com , and I will send you the fix.