none
registration of sqlceoledb

    Question

  • Hi all.

    I'm trying to connect with ADOCE 3.1 to a sdf file (SQLCE v 3.5).

    I'm not able to open the connection because I think that sqlceoledb is non registered correctily or at all.

    I read some post saying that it should be registered via regsvrce (for CE 5.0 in my case).

    This tool is avilable in evC 4.0..I found, but I don't have it.

    Is there any other way to achieve this or a place where to find the  correct regsvrce(I found prevoius versions that don't work).

    Where are informations stored in the registry (I mean which keys)

     

    Below the code I use:

     

    Dim cn as Object

    Dim rs as Object

     

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

    cn.Open "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=\Flashdisk\test\test.sdf"

     

    Set rs = CreateObject("ADOCE.Recordset.3.1")

    rs.Open "SELECT * FROM TestTable",cn,3,3

    ...... 

    Thanks for any help
    Monday, April 14, 2008 8:32 AM

Answers

All replies

  • Have you tried installing sqlce30.dev.ENU.wce5.<Processor>.CAB ?

     

    Monday, April 14, 2008 2:32 PM
    Moderator
  • Thank you ErikEJ for your quick reply.

    I tryed to install the cab suggested, now the scenario is changed. The connection is succesful but the recordset is empty.

    I'm afraid the problem is now connected to the database format (3.5). I'll do some other investigations and then post further replais.

     

    Thursday, April 17, 2008 8:45 AM