Phillip,
I'm pretty sure that SqlClient is available for CF 1 as well as CF 2, but
you might not choose to use it for a variety of reasons. Alternatives would
include using SqlCe on the device and transferring the data to the desktop
pehaps using a 3rd party product like those at
www.primeworks.pt. CF 1 also
supports consuming web services, although it doesn't provide all the
serialization support you get with CF 2 and you might want to write your own
custom serialization routines. If you have SQL Server 2000 or SQL Server
2005, you could use either RDA or merge replication with SqlCe on the
device, both of which are supported with CF 1.
But is there a particular reason you want to stay with VS 2003? VS 2005 is
MUCH better, especially with the data tools for working with SQL Mobile, so
I'd recommend upgrading to the latest and greatest rather than creating
unnecessary work for yourself. I don't think a mobile web app will give you
want you want in terms of usability.