which settings to use sqlCe in an MFC program

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ralf Pichocki (pisoftware.NOSPAM_at_gmx.de)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 12:16:27 +0100

Hi!

I just am working with the Northwind Sample and the "OLE DB and SQL Server
CE" help file.
So I created a brand new MFC application and wanted to port the code bit by
bit.

As the first action, I put the following last entry into my stdafx.h:
    #define OLEDBVER 0x210
    #define DBINITCONSTANTS
    #define INITGUID

    // OLEDB Files:
    #include <oledb.h>
    #include <oledberr.h>
    #include <coguid.h>

    // SSCE Files:
    #include <ssceoledb.h>

When I try to compile this, however, DBPROP is unknown, amonghst others. It
seems that not even oledb.h is properly included.
Do I have to define, undefeine or switch something somewhere? I suspect that
yes, but what?
I already deleted VC_EXTRALEAN (of which I don't know if it was necessary).

Thanks in advance and 

-- 
Regards, Pi (Ralf Pichocki).

Relevant Pages

  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: MS SQL Server 2000 feature or bug?
    ... According to SQL Server Help file: ... is based on the sysobjects and syscolumns system tables". ... seems to me this is a feature, ...
    (borland.public.delphi.database.ado)
  • Re: Function vs. Sub
    ... "Look it up in the help file" ... It's more in the SQL Server ... The bottom two give you different formats. ... You should look up Sub and Function in Access HELP system. ...
    (microsoft.public.access.formscoding)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: Upsize trouble
    ... Yes there certainly are 2 foreign keys. ... Is that a no-no in SQL server? ... >> brand display when entering products.Everything seems to work in the ... >> conflicted with COLUMN FOREIGN KEY constraint ...
    (microsoft.public.access.adp.sqlserver)