0

Closed

Oledb_largeUDT: The setup.sql is executed with error "Type 'LargeStringUDT' in assembly 'LargeStringUDT' is not public".

description

Environment:

  1. Win2k3 x86 ENT ENU SP2.
  2. VS2005
  3. Katmai Samples 090228
     

Steps:

1.       Open  and build the solution “..\Engine\Data Access\oledb\Oledb_largeUDT\cpp\Oledb_largeUDT.sln" via vs2005.
2.       Enable the CLR of Katmai.
3.       Double click to setup.sql from “..\Samples\Engine\Data Access\Oledb\Oledb_largeUDT\scripts”.
4.       Click Connect button to connect server.
5.       Execute the setup.sql script.
 

Expectation:

The script should be execute successfully without error.
 

Actual Results:

The script is executed failed with error:
Msg 6576, Level 16, State 3, Line 2
Type 'LargeStringUDT' in assembly 'LargeStringUDT' is not public.
Msg 6597, Level 16, State 1, Line 2
CREATE TYPE failed.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #2: Cannot find data type LargeStringUDT.
Msg 243, Level 16, State 1, Line 2
Type LargeStringUDT is not a defined system type.
Msg 208, Level 16, State 1, Line 2
            Invalid object name 'dbo.LargeStringUDTs'.
 
 

Comments:

If define the class LargeStringUDT of LargeStringUDT project as a public class, the sample can work well.
Closed Mar 9, 2009 at 7:51 AM by libinzhao

comments

wrote Mar 6, 2009 at 1:16 AM

oledb\Oledb_largeUDT\cpp\LargeStringUDT\LargeStringUDT.csModify Line==>32class LargeStringUDT : INullable, IBinarySerialize {public class LargeStringUDT : INullable, IBinarySerialize {

wrote Mar 9, 2009 at 7:51 AM

Verified on Sample build 90306.