Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Can Adobe LiveCycle Connect to SQL CE?

Avatar

Level 2

Hi All,

I have an application which stores its data in a SQL CE database (*.sdf). I'm just wondering if it is possible to create a database connection from Adobe LiveCycle Designer ES2 to this .sdf file. I've tried this connection string "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\MyData\MyData.sdf" but it's not working, error prompted "Could not connect to the database". The same connection string works perfectly in VBA. Does that means SQL CE is not a supported database for LiveCycle?

Regards,

Steven

0 Replies