Re: ActivePerl (x64) is not working with MS SQL Server CE Database

Not sure if this will help, but it is easy enough to try --
Connectionstrings.com and this MSDN forum seem to suggest putting the password into the connection string like this:

PROVIDER=Microsoft.SQLSERVER.CE.OLEDB.3.5;ssce:database password=test;
+Data 
Source=C:\temp\testcompact3.sdf 

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myDat
+a.sdf;
SSCE:Database Password='myPassword';
[download]

...it is unhealthy to remain near things that are in the process of blowing up. man page for WARP, by Larry Wall

Comment on Re: ActivePerl (x64) is not working with MS SQL Server CE Database Download Code

Replies are listed 'Best First'.
Re^2: ActivePerl (x64) is not working with MS SQL Server CE Database by talk2chakra (Initiate) on Sep 26, 2016 at 19:27 UTC
Success eventually came on applying following Connection String `my $dbh = DBI->connect("dbi:ADO:PROVIDER=Microsoft.SQLSERVER.CE.OLEDB. +3.5;ssce:database password=$pass;Data Source=E:\\PUCC\\DB\\D_stud.sdf +");` [download] Many many thanks for the reference	[reply] [d/l]