I've upgraded to the 3.1 and the more I read the more confused I become.

I've got three current versions of SQL Server CE installed.

I want to use the latest greatest but can't really decide where I should
reference it from.

I've got 4 SQL Server directories:
   Microsoft SQL Server
   Microsoft SQL Server 2005 Mobile Edition
   Microsoft SQL Server CE 2.0
   Microsoft SQL Server Compact Edition

Within the the Microsoft SQL Server Compact Edition directory:
   Microsoft SQL Server Compact Edition
       V3.1
           SDK
               bin
                   Client
                       v2.0
                           wce400
                               armv4
                           wce500
                    Desktop
                    wce400
                    wce500
               Docs
               Includes
               Samples
           sync

There are various System.Data.SqlServerCe.dll s in the above directories -
I'm assuming I'm intereseted in referencing the 3.0.5300.0 (Though it's a
little misleading since it's in the v3.1 directory)

Or so I reference the System.Data.SqlServerCe.dll  under the Visual Studio 8
directory tree:

Visual Studio 8
   Smart Devices
          SDK
               SQL Server
                   Client
                   Mobile
                       v2.0
                       v3.0

Confusion here as to the nomenclature "Mobile" where the old version brfore
Compact Edition was called Sql Server Mobile.

My app works fine using the 3.0.5300.0 version when run in debug.  I am
running the sqlce30.ppc.wce4.armv4.CAB on the device but the app keeps
butping at first RDA pull with a "Unspecified error [sqlceca30.dll]"  and
then 2 more error boxes "ErrorCode 80040E37 [Devices] SQL Server CF ADO.NET
Data Provider"

I don't think the client side of SQL Server Compact Edition is getting
installed correctly.

Does your directory structure look similar to the above or is mine screwed?

TIA
Harry