Connecting to Compact database using OLE

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply