Connecting to Compact database using OLE

• John Malvey

  Valued Member

  Points: 54

  More actions

  June 25, 2008 at 10:14 am

  #187506

  Hi.

  I'm trying to connect to an SSCE database using OLE through PowerBuilder. Would anyone know the correct parameters to set? I'm able to successfully connect to an Express database through OLE setting the Data Source as the server and specifying the database name in the extended properites setting. But since there's no server for Compact databases I'm stuck as to how to specify the Data Source and Database name.

  Any suggestions would be greatly appreciated.

  Thanks,

  John

• Ron Hagan

  SSC Veteran

  Points: 261

  More actions

  August 19, 2008 at 10:53 am

  #860154

  John,

  Not sure if this will help, but I connect to SSCE in a C# application by using this connection string:

  "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5; Data Source=xxx.sdf"

  Hope this helps.

  Ron