Error executing request in visual studio

I created a databese, for example, an exploler / data connection / add connection server. Microsoft SQL Server Compact 3.5 (.NET Framework) uses the creation and creation of my own MyDatabes.sdf file.

Now on the exploler server, right click on my databese --- and click on a new request

.

Try running this:

Create table [student]
(
    [student_id] Bigint NOT NULL,
    [bornnumber] Varchar(10) NOT NULL,
    [branch] Integer NOT NULL,
    [specialization] Integer NOT NULL,
    [year] Smallint NULL,
    [studygroup] Varchar(5) NOT NULL,
    [started] Datetime NULL,
    [finished] Datetime NULL,
    [status] Char(1) NULL,
Primary Key ([student_id])
) 

click execute query:

  • shows the table Query Definitions. Difference is written

    "The SQL CREATE TABLE construct or statement is not supported."

    Click to connect

  • Shows SQL Executation ERROR

    "Error source: SQL Server Compact ADO.NET Data PRovider Error message: The specified data type is not valid. [Data type (if known) = Varchar]";

, ... , ADO, NET Varchar. , , ?

Visual Studio 2010 Ultimate.

+3
1

varchar(n) CE; unicode nvarchar(n), nchar(n) ntext. nvarchar(10), nvarchar(5) nchar(1) ..

; ( ..), , , , , .

+7

All Articles