SQL CE in VB.Net Error!

I am trying to create an application for a Pocket pc using vb.net. When I deploy the application to the emulator I get the error

Unknown connection option in connection string provider

THis is the code

Dim LocalConnection As String = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\invDB.sdf"
 Dim dbConn As New SqlCeConnection(LocalConnection)

I have sql server developer editoin installed as well as SQL server CE 2.0

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Mikal613Connect With a Mentor Commented:
To resolve this problem, copy the files from the C:\Program Files\Microsoft SQL Server CE\Device\x86\I486 folder instead of the C:\Program Files\Microsoft SQL Server CE\Device\x86\Emulation folder.
I use something like this

            strProgramPath = "\Storage Card\kbb"
            strLocalDatabaseFile = strProgramPath & "\KBBdb.sdf"

            strLocalConnString = "Data Source=" & strLocalDatabaseFile
            ' Create SQL Server CE connection object.
            cn = New SqlCeConnection(strLocalConnString)
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Try removing provider option
JonMnyAuthor Commented:
none of these options work, I cannot leave out the provider it just gives me an error, the link used the exact same provider string that I did.
JonMnyAuthor Commented:
please give me a refund
All Courses

From novice to tech pro — start learning today.