• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

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



0
JonMny
Asked:
JonMny
  • 2
  • 2
  • 2
1 Solution
 
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
 
ramesh12Commented:
Try removing provider option
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
Mikal613Commented:
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
 
JonMnyAuthor Commented:
please give me a refund
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now