I've used sql connector to create a connection to ms-sql and successfully created a dataset. I've created a form to manage that dataset which works great until I try to write a change back to the dataset.
The primary key to my table is defined in ms-sql as a uniqueidentifier. It seems to be represented in OI as:
{CCD65AAD-05ED-42BA-A1C4-04D540B77BFB}
The native representation in ms-sql leaves out the brackets but is otherwise identical. When I try saving the record in my OI form I get:
FS330: The Sql Server returned the following errors: Error Number: -2147352571 "Type mismatch." (Source: ) {SQL State: ) (NativeError: )
OpenInsight has defined the column datatype as VARBINARY(16).
I don't know where to begin to resolve this mismatch.
Any advice appreciated.
I use Coldfusion, Flex, and VB.Net against this table currently and they handle guids (uniqueidentifiers) with only a little bit of hastle. I need to be able to claim the same for OpenInsight.
We are doing a lot of work on the SQL connector to improve handling of datatypes, especially identity columns. I'll confirm that uniqueidentifier columns have been corrected.
- Bob