help connecting to sql server ce using vb.net

[gundamhamtaro]

Hi all, i'm trying to create a new database in CE but it doesnt seem to work for some reason........can someone help? thanks!! Imports System.Data.SqlServerCe Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'create DB Dim engine As New SqlServerCe.SqlCeEngine("Data Source = \My Documents\test.sdf") engine.CreateDatabase() 'error here 'connect to DB Dim ssceconn As New SqlServerCe.SqlCeConnection("Data Source = \My Documents\test.sdf") ssceconn.Open() 'ceate table Dim sqlCreateTable As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlCreateTable.CommandText = _ "CREATE TABLE People(people_id int IDENTITY(0,1) PRIMARY KEY, f_name ntext, l_name ntext)" sqlCreateTable.ExecuteNonQuery() 'inserting rows Dim sqlInsertRow As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlInsertRow.CommandText = "INSERT INTO People(f_name, l_name) VALUES('John', 'Doe')" sqlInsertRow.ExecuteNonQuery() 'close connection ssceconn.Close() End Sub An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll Additional information: SqlCeException

[Dave Kreskowiak]

It would appear that your connection string isn't valid. Specifically, my first suspect would be the path you provided for Data Source. But, your question really belongs in the Embedded/Mobile forum. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[gundamhamtaro]

hmm ok. i'll try my luck in the Mobile forum. thanks for the reply anyway.