locked
Supported SQL Server Data Types? RRS feed

  • Question

  •  

    Hi!

     

    I keep banging up against this problem. The help topic related to the issue is:

     

    Which tables can be cached?

     

  • Do not have a primary key defined.

  • Have names longer than 118 characters.

  • Contain columns with data types that are not supported by SQL Server Compact 3.5.

     

    I have a primary key defined and no col names that long, so I do believe the issue is the data types. What data types are supported? I am running VS.2008 SP1 with SQL Server 2008 Developer Edition both 64x.

     

    Thanks!

    Michael

  • Moved by Max Wang_1983 Friday, April 22, 2011 5:59 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Tuesday, August 26, 2008 4:03 PM

All replies

  • I am sorry - what kind of data type do you have for tables doing sync?

     

    Thanks.

    Tuesday, August 26, 2008 7:36 PM
    Answerer
  • This doesn't work:

     

    CREATE TABLE [dbo].[Test](

    [TestID] [int] IDENTITY(1,1) NOT NULL,

    [Test] [nchar](100) NULL,

    CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED

    (

    [TestID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

     

    ...nor this one:

     

    CREATE TABLE [dbo].[Test2](

    [TestID] [int] IDENTITY(1,1) NOT NULL,

    [Test] [text] NOT NULL,

    CONSTRAINT [PK_Test2] PRIMARY KEY CLUSTERED

    (

    [TestID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

     

    Tuesday, August 26, 2008 7:39 PM
  • I think your machine OS is 64 bit OS right?  If so did you run your SQL CE in WOW (32 bit)?  I suppose that SQL CE is not supported in plain 64 bit OS but if you run it in WOW, then it should be fine.

    Also you have IDENTITY defined in the PK as well?  How many clients do you have?  If you have more than 1, then you should partition the IDENTITY range on the client database; otherwise you may see identity collision.

     

    Thanks.

    Tuesday, September 2, 2008 6:03 PM
    Answerer