CEDB from ADOCE - what's needed?

From: Aaron Lawrence (aaronlNO_at_SPAMintegration.co.nz)
Date: 06/28/04


Date: Mon, 28 Jun 2004 15:08:32 +1200

Hi all,

I'm trying to make an ASP page use ADOCE to connect to a CDB database.

Using eVC I made a small program to create a test .cdb file. That seems
to work. I have my testdb.cdb file.

However when I try to access from ASP, I get an error:

"Error: The operating system on your device does not support all
features. All features are supported in Windows CE for the Handheld PC
version 3.0 or greater.\n"

This is a CEPC built using Platform Builder 4.2, evaluation.

Relevant part of the ASP page:

<%
        Dim oConn

        On Error Resume Next

        Set oConn = CreateObject("ADOCE.Connection.3.1")

        oConn.ConnectionString = "data source = '\hard disk\testdb.cdb'"
        oConn.Open
        If Err.number <> 0 then
                Response.Write "Error: " & Err.description
        End If

I have copied ADO onto the device and registered the DLLs:
regsvrce adoce31.dll
regsvrce adoxce31.dll
regsvrce msdadc.dll
regsvrce msdaer.dll
regsvrce msdaosp.dll

and indeed the CreateObject is now working.

I can't see anything else needed...

Thanks

Aaron