Hi,

We wrote ASP pages for the web server in Windows CE using ADOCE to
access the database. We are now upgrading to Windows CE.NET 4.2 and I
need to access the SQL server CE database via the ASP pages (this is
an embedded application and the user uses the web pages to control the
unit via the database).

In the ASP pages I have tried the following:

1. Using activeXObject
<%
Dim CEDBConnection
set CEDBConnection = activeXObject
("System.Data.SqlServerCe.SqlCeConnection")
%>
That gave me an error 13 "type mismatch"

2. Using new as class
<%
Dim CEDBConnection
set CEDBConnection = new System.Data.SqlServerCe.SqlCeConnection
%>
That gave me an error 506 "class not defined"

3. Using CreatObject
<%
Dim CEDBConnection
set CEDBConnection = CreateObject
("System.Data.SqlServerCe.SqlCeConnection")
%>
That gave me an error 429 "ActiveX component can't create object"

I have searched everywhere but can't find a solution? The
System.Data.SqlServerCe.SqlCeConnection is a Visual Studio .NET Class.

Any help will be appreciated

Gerrit