MissingMethodException

[Database Administrator]

I am getting the following error "MissingMethodException"
can't find Pinvoke dll "sqlceme30.dll"

On this line of code:

Public Function InitDatabase() As Boolean

Dim SQL As String

If GetSqlCeConnection() Then

SQL = "CREATE TABLE sAssets (asset_no integer Primary Key NOT NULL, descript
nvarchar(30))"

Dim cmd As New System.Data.SqlServerCe.SqlCeCommand(SQL, CN)

cmd.CommandType = Data.CommandType.Text

cmd.ExecuteNonQuery()

Disconnect()

End If

End Function



Public Function GetSqlCeConnection() As Boolean

Try

CN = New SqlCeConnection(strConn) <=====================ERROR ========

CN.Open()

GetSqlCeConnection = True

Catch err As SqlCeException

GetSqlCeConnection = False

DisplayErrors(err)

End Try

End Function

[mehdiraouf]

Hi,

I got similar problem. When I want to open a sqlceconnection it throws MissingMethodException. Did you fing anything to solve this?

Originally Posted by usenet

I am getting the following error "MissingMethodException"
can't find Pinvoke dll "sqlceme30.dll"

On this line of code:

Public Function InitDatabase() As Boolean

Dim SQL As String

If GetSqlCeConnection() Then

SQL = "CREATE TABLE sAssets (asset_no integer Primary Key NOT NULL, descript
nvarchar(30))"

Dim cmd As New System.Data.SqlServerCe.SqlCeCommand(SQL, CN)

cmd.CommandType = Data.CommandType.Text

cmd.ExecuteNonQuery()

Disconnect()

End If

End Function



Public Function GetSqlCeConnection() As Boolean

Try

CN = New SqlCeConnection(strConn) <=====================ERROR ========

CN.Open()

GetSqlCeConnection = True

Catch err As SqlCeException

GetSqlCeConnection = False

DisplayErrors(err)

End Try

End Function