Page 1 of 1
Cannot enter GUID via Data Window
Posted: Mon 30 May 2011 08:49
by extrakun
I am trying to enter a GUID into one of the membership provider tables. The tables are created the SQL script provided by dotConnect.
However, when I attempt to enter a GUID, such as "8F34D6F653FA864385091AD5BB5FD5FF", I get the error message :
Code: Select all
ORA-12899: value too large for column
"USER"."ASPNET_ROLES"."ROLEID" (actual : 17, maximum 16)
ORA-06512: at line 1
The definition for the ROLEID column is RAW(16)
Note: The GUID is valid and has only 16 characters
Re: Cannot enter GUID via Data Window
Posted: Wed 01 Jun 2011 11:25
by Shalex
extrakun wrote:Cannot enter GUID via Data Window
I have tried to insert your GUID ("8F34D6F653FA864385091AD5BB5FD5FF") into the RAW(16) column via OracleCommand using dotConnect for Oracle v 6.30.160. It works.
Please specify your current version (x.xx.xxx) of dotConnect for Oracle and the steps we should follow to invoke "Data Window". If you are using OraDeveloper Tools, specify its version as well and the version of your Visual Studio.
Re: Cannot enter GUID via Data Window
Posted: Tue 05 Jul 2011 04:39
by extrakun
Shalex wrote:extrakun wrote:Cannot enter GUID via Data Window
I have tried to insert your GUID ("8F34D6F653FA864385091AD5BB5FD5FF") into the RAW(16) column via OracleCommand using dotConnect for Oracle v 6.30.160. It works.
Please specify your current version (x.xx.xxx) of dotConnect for Oracle and the steps we should follow to invoke "Data Window". If you are using OraDeveloper Tools, specify its version as well and the version of your Visual Studio.
Hi sorry, I forgot to specify that this is using the OraDeveloper tool and the dotConnect data window.
Posted: Mon 11 Jul 2011 08:40
by .jp
Now we are working on the third version of OraDeveloper. And the product will be called dbForge Studio/Tools for Oracle. The problem you described is fixed there. Unfortunately, we cannot fix this problem in the current (2.xx) version. Please wait for the next version.
Posted: Thu 14 Jul 2011 07:09
by extrakun
.jp wrote:Now we are working on the third version of OraDeveloper. And the product will be called dbForge Studio/Tools for Oracle. The problem you described is fixed there. Unfortunately, we cannot fix this problem in the current (2.xx) version. Please wait for the next version.
Thank you. We just bought the licenses for dotConnect Pro recently; will there be a free upgrade?
Posted: Thu 14 Jul 2011 13:55
by Devart
yes, you will get a free upgrade.
We will send you a notification email on the new version release.
Regards,
Devart Support