Re: CEDB from ADOCE - what's needed?

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

Date: Mon, 28 Jun 2004 15:48:50 +1200

I also tried using the ADOCE create database

        Set rs = CreateObject("ADOCE.Recordset.3.1")
        rs.Open "CREATE DATABASE 'myDatabase.cdb'"
        If Err.number <> 0 then
                Response.Write "Create database Error: " & Err.description
        End If

as documented, and I get the same error.

Aaron Lawrence wrote:

> 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

Relevant Pages

  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Datasets - Best approach to use?
    ... William (Bill) Vaughn ... then you got the wrong books. ... Using ASP (or ... It accesses data in an SQL Server database. ...
    (microsoft.public.vb.database)
  • Re: Database and asp question
    ... You and others can have access to a database hosted on the Web from any ... Then "dynamic" Web pages (actually ASP pages which include VBScript, ... Dynamic Web pages are similar in many ways to regular HTML pages. ... there is an autonumber field in each table (and you'll probably also ...
    (microsoft.public.inetserver.asp.db)
  • Re: newbie question on asp
    ... I am new to asp, and want to put a simple database on the web so the ... You and others can have access to a database hosted on the Web from any ... Dynamic Web pages are similar in many ways to regular HTML pages. ... Here are a few good ASP sites: ...
    (microsoft.public.inetserver.asp.db)