<div>
<a href="http://www.codeproject.com/netcf/PocketPCwithSQLCE.asp" rel="ugc">http://www.codeproject.com/netcf/PocketPCwithSQLCE.asp</a>
</div>


http://www.codeproject.com/netcf/PocketPCwithSQLCE.asp [http://www.codeproject.com/netcf/PocketPCwithSQLCE.asp]

<div>
I use something like this<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strProgramPath = &quot;\Storage Card\kbb&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strLocalDatabaseFile = strProgramPath &amp;&nbsp;&quot;\KBBdb.sdf&quot;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strLocalConnString = &quot;Data Source=&quot; &amp;&nbsp;strLocalDatabaseFile<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' Create SQL Server CE connection object.<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cn = New SqlCeConnection(strLocalCo<wbr />nnString)
</div>


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)

<div>
Try removing provider option
</div>


<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
<br />
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<br />
<br />
Unknown connection option in connection string provider<br />
<br />
THis is the code<br />
<br />
Dim LocalConnection As String = &quot;Provider=Microsoft.SQLSER<wbr />VER.OLEDB.<wbr />CE.2.0;Dat<wbr />a Source=\My Documents\invDB.sdf&quot;<br />
&nbsp;Dim dbConn As New SqlCeConnection(LocalConne<wbr />ction)<br />
<br />
<br />
I have sql server developer editoin installed as well as SQL server CE 2.0<br />
<br />
<br />
<br />

</div>
</div>



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





SQL CE in VB.Net Error!

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.