help with 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 SQL Server CE encountered problems in creating the SQL Server CE database [,,,Connection String,,]