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



LVL 9
JonMnyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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.
0
 
ramesh12Commented:
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)
0
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.

 
ramesh12Commented:
Try removing provider option
0
 
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.
0
 
JonMnyAuthor Commented:
please give me a refund
0
All Courses

From novice to tech pro — start learning today.