SqlConnection - PlatformNotSupportedException

Hi!

When I'd like to use SqlConnection.Open() in a Pocket PC 2002 application, I get an error message - PlatformNotSupportedException. I've tryed it on Windows CE Emulator and my PDA Device, but the result was the same.


There is my code snippet:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim cn As New System.Data.SqlClient.SqlConnection("User ID=sa;password=sa;database=Test;server=192.168.1.5")

cn.Open()

Catch exSQL As SqlException

            Dim errSQL As SqlError

            For Each errSQL In exSQL.Errors

                MessageBox.Show(errSQL.Message)

            Next

Catch ex1 As Exception

            MessageBox.Show(ex1.Message)

        Finally

            MessageBox.Show("test fail")
End Sub

When i try to build a windows application project with this code, it  works well, Can anybody give me a tip, how can i solve the problem
Thank's in advance. 
 

Operating system: Windows XP professional + sp2
Development Tool: Visual Studion 2003
Database: MSDE 2000 Release A
PDA device: iPaq H3870, Windows CE 4.1



Answer this question

SqlConnection - PlatformNotSupportedException

  • HGChrist

    I'm almost certain that you need at least Windows Mobile 2003 to use the .NET SQL client.

    -Ryan / Kardax

  • whyvenky

    for sqlce 3.0 it is not supported on PPC 2002.
    For SQL CE 2.0 it is supported on PPC 2002.
    you should check the version of SQLClient dll. It should be 2.0. If it is 2.0 send the name and version of cabs/dll you have installed on device.

    Prashant

  • SqlConnection - PlatformNotSupportedException