none
Newbie to CE 3.5 evaluation question

    Question

  •  

    Hello - I'm a CE newbie evaluating 3.5 for use in a desktop app and have sifted thru the documentation, but still looking to find if this is possible:

     

    Insert into server2005_tbl select * from opendatasource (ce3.5 connection\db.sdf).ce35_tbl

     

    I've tried it with ce3.5 connection as:

     

    ('Provider=Microsoft.SQLSERVER.OLEDB.CE.3.5','data source = "C:\...\db.sdf"').ce35_tbl

     

    ...(and several permutations of strings I found via search) but get "invalid object name ce35_tbl".  Am I doing something wrong here or is this not supported?  Is there a way to accomplish this via t-sql on server2005?

     

    Regards,

    skitron

    Tuesday, October 23, 2007 8:56 PM

Answers

  • I think this is not possible:

    Code Block

    SELECT a.*

    FROM OPENROWSET('Microsoft.SQLSERVER.MOBILE.OLEDB.3.0', 'Data Source=C:\test.sdf;',

    'SELECT * FROM t_contact') AS a;

     

     

    returns this error:

    Msg 7373, Level 16, State 2, Line 1

    Cannot set the initialization properties for OLE DB provider "Microsoft.SQLSERVER.MOBILE.OLEDB.3.0" for linked server "(null)".

     

    As stated in other post in this forum, the OLEDB provider is not a full fledged as desired. It would be nice if this worked, though - Microsoft.

    Wednesday, October 24, 2007 9:12 AM
    Moderator

All replies

  • I think this is not possible:

    Code Block

    SELECT a.*

    FROM OPENROWSET('Microsoft.SQLSERVER.MOBILE.OLEDB.3.0', 'Data Source=C:\test.sdf;',

    'SELECT * FROM t_contact') AS a;

     

     

    returns this error:

    Msg 7373, Level 16, State 2, Line 1

    Cannot set the initialization properties for OLE DB provider "Microsoft.SQLSERVER.MOBILE.OLEDB.3.0" for linked server "(null)".

     

    As stated in other post in this forum, the OLEDB provider is not a full fledged as desired. It would be nice if this worked, though - Microsoft.

    Wednesday, October 24, 2007 9:12 AM
    Moderator
  • Thanks for the definative answer, I thought this may be the case.  My intent was to have a CE table serve as a clear delineator of where my app (and thus responsibility) ends and the customer's begins and provide a dirt easy way to interface their stuff to my stuff.  But no problem, I can simply load data directly into their table via odbc (or whatever) and be done with it.  It muddies the water somewhat concerning the business responsibility boundaries, but no biggie...
    Wednesday, October 24, 2007 2:26 PM
  • Thursday, October 23, 2008 7:45 AM
    Moderator