SQLCE Problem on Create Table

[Enver A]

Hey ppl,
I am having trouble in building a smart device application. I cant create a
table on SQLCE server using this line. Anyone can tell me what the problem
is?
I am able to create another 3 Tables same way but this SQL line is always
gives me problems.
command4.Comman dText = "CREATE TABLE MUSTERI (INDEXMS nvarchar(5),MSA D
nvarchar(30),MS SOYAD nvarchar(30),MS SEMT nvarchar(30),MS SEMTRCH
nvarchar(30),MS TLF nvarchar(15),FI YAT nvarchar(3),IND EXBY
nvarchar(4),VHM ARKA nvarchar(30),VH MODEL nvarchar(50),VH LSEBAT
nvarchar(20),VH YIL nvarchar(4),LAS ONMRK nvarchar(20),LA SONDSN
nvarchar(30),LA SRKMRK nvarchar(20),LA SRKDSN nvarchar(30),VH DSSGON
nvarchar(10),VH DSSGRK nvarchar(10),VH DSSLON nvarchar(10),VH DISSLRK
nvarchar(10),VH PLAKA nvarchar(15),VH IDHVON nvarchar(3),VHI DHVRK
nvarchar(3),TAR IH nvarchar(10),US ER nvarchar(5))"

[Anand [MVP]]

What is the error?

Rgds,
Anand
VB.NET MVP
http://www.dotnetindia.com

"Enver A" wrote:

Hey ppl,
I am having trouble in building a smart device application. I cant create a
table on SQLCE server using this line. Anyone can tell me what the problem
is?
I am able to create another 3 Tables same way but this SQL line is always
gives me problems.
command4.Comman dText = "CREATE TABLE MUSTERI (INDEXMS nvarchar(5),MSA D
nvarchar(30),MS SOYAD nvarchar(30),MS SEMT nvarchar(30),MS SEMTRCH
nvarchar(30),MS TLF nvarchar(15),FI YAT nvarchar(3),IND EXBY
nvarchar(4),VHM ARKA nvarchar(30),VH MODEL nvarchar(50),VH LSEBAT
nvarchar(20),VH YIL nvarchar(4),LAS ONMRK nvarchar(20),LA SONDSN
nvarchar(30),LA SRKMRK nvarchar(20),LA SRKDSN nvarchar(30),VH DSSGON
nvarchar(10),VH DSSGRK nvarchar(10),VH DSSLON nvarchar(10),VH DISSLRK
nvarchar(10),VH PLAKA nvarchar(15),VH IDHVON nvarchar(3),VHI DHVRK
nvarchar(3),TAR IH nvarchar(10),US ER nvarchar(5))"

[William Ryan eMVP]

This line alone can't be giving you the trouble Syntactically I don't see
anything wrong off the top of my head, but it'd help if you posted the code
that's throwing the exception in particular.
--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"Enver A" <ea**@hotmail.c om> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hey ppl,
I am having trouble in building a smart device application. I cant create a table on SQLCE server using this line. Anyone can tell me what the problem
is?
I am able to create another 3 Tables same way but this SQL line is always
gives me problems.
command4.Comman dText = "CREATE TABLE MUSTERI (INDEXMS nvarchar(5),MSA D
nvarchar(30),MS SOYAD nvarchar(30),MS SEMT nvarchar(30),MS SEMTRCH
nvarchar(30),MS TLF nvarchar(15),FI YAT nvarchar(3),IND EXBY
nvarchar(4),VHM ARKA nvarchar(30),VH MODEL nvarchar(50),VH LSEBAT
nvarchar(20),VH YIL nvarchar(4),LAS ONMRK nvarchar(20),LA SONDSN
nvarchar(30),LA SRKMRK nvarchar(20),LA SRKDSN nvarchar(30),VH DSSGON
nvarchar(10),VH DSSGRK nvarchar(10),VH DSSLON nvarchar(10),VH DISSLRK
nvarchar(10),VH PLAKA nvarchar(15),VH IDHVON nvarchar(3),VHI DHVRK
nvarchar(3),TAR IH nvarchar(10),US ER nvarchar(5))"

[Enver A]

Under Public Class Form1 definition:

Private Const filename4 As String = "MUSTERI.SD F"

Private connstr4 As String = String.Format(" Datasource={0}; Password={1}",
filename4, "Admin")

Private connection4 As SqlCeConnection

Under Private sub CreateDB Click():

Dim engine4 As New SqlCeEngine(con nstr4)

If Not File.Exists(fil ename4) Then

engine4.CreateD atabase()

Else

MsgBox("FILE EXISTS")

End If

engine4.Dispose ()

connection4 = New SqlCeConnection (connstr4)

connection4.Ope n()

Dim command4 As SqlCeCommand = connection4.Cre ateCommand

command4.Comman dText = "CREATE TABLE MUSTERI (INDEXMS nvarchar(5),MSA D
nvarchar(30),MS SOYAD nvarchar(30),MS SEMT nvarchar(30),MS SEMTRCH
nvarchar(30),MS TLF nvarchar(15),FI YAT nvarchar(3),IND EXBY
nvarchar(4),VHM ARKA nvarchar(30),VH MODEL nvarchar(50),VH LSEBAT
nvarchar(20),VH YIL nvarchar(4),LAS ONMRK nvarchar(20),LA SONDSN
nvarchar(30),LA SRKMRK nvarchar(20),LA SRKDSN nvarchar(30),VH DSSGON
nvarchar(10),VH DSSGRK nvarchar(10),VH DSSLON nvarchar(10),VH DISSLRK
nvarchar(10),VH PLAKA nvarchar(15),VH IDHVON nvarchar(3),VHI DHVRK
nvarchar(3),TAR IH nvarchar(10),US ER nvarchar(5))"

command4.Execut eNonQuery()

command4.Dispos e()

MsgBox("MUSTERI .SDF TAMAM")

' 4TH Creation Complete

connection4.Clo se()
"William Ryan eMVP" <do********@com cast.nospam.net > wrote in message
news:eR******** *****@TK2MSFTNG P11.phx.gbl...

This line alone can't be giving you the trouble Syntactically I don't see anything wrong off the top of my head, but it'd help if you posted the code that's throwing the exception in particular.
--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
"Enver A" <ea**@hotmail.c om> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Hey ppl,
I am having trouble in building a smart device application. I cant create

a

table on SQLCE server using this line. Anyone can tell me what the

problem is?
I am able to create another 3 Tables same way but this SQL line is always gives me problems.
command4.Comman dText = "CREATE TABLE MUSTERI (INDEXMS nvarchar(5),MSA D
nvarchar(30),MS SOYAD nvarchar(30),MS SEMT nvarchar(30),MS SEMTRCH
nvarchar(30),MS TLF nvarchar(15),FI YAT nvarchar(3),IND EXBY
nvarchar(4),VHM ARKA nvarchar(30),VH MODEL nvarchar(50),VH LSEBAT
nvarchar(20),VH YIL nvarchar(4),LAS ONMRK nvarchar(20),LA SONDSN
nvarchar(30),LA SRKMRK nvarchar(20),LA SRKDSN nvarchar(30),VH DSSGON
nvarchar(10),VH DSSGRK nvarchar(10),VH DSSLON nvarchar(10),VH DISSLRK
nvarchar(10),VH PLAKA nvarchar(15),VH IDHVON nvarchar(3),VHI DHVRK
nvarchar(3),TAR IH nvarchar(10),US ER nvarchar(5))"