Is it possible to use an ODC file to access data in an SDF file?

Discussion in 'microsoft.public.sqlserver.ce' started by Anthony Wieser, Oct 27, 2009.

  1. The data connection wizard in Office 2007 lists a Microsoft OLEDB provider
    for SQL Server 3.5, but unfortunately, even if you manage to save the ODC
    file, it doesn't actually allow you to fetch any data.

    Maybe its wishful thinking, but is there any way to edit the ODC file, and
    get it to work; I'd like to believe its just the wizard that generated
    something wrong.
    Anthony Wieser, Oct 27, 2009
    1. Advertisements

  2. Anthony Wieser

    ErikEJ Guest

    ErikEJ, Oct 28, 2009
    1. Advertisements

  3. Thanks for your suggestion. I've seen that code and it might be able to
    help a little.

    I was hoping to have something more permanent so that I could easily do a
    mail merge into word, just by attaching a mail merge query to a particular
    sdf or ODC file.
    It seems there really isn't any way at all to support that.

    Is there any reason it couldn't be supported? Could we write our own OLEDB
    provider that actually did work?

    Anthony Wieser

    Anthony Wieser, Oct 28, 2009
  4. Anthony Wieser

    ErikEJ Guest

    If you were very clever and had masses of time, you might be able to write
    your own OLDB provider. But it would probably be cheaper to write a generic
    Office add-in to do the work.

    Erik Ejlskov Jensen, Mobile App Dev MCTS
    Check out my SQL Compact blog at

    ErikEJ, Oct 28, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.