Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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

by NetWallah (Canon)
on Sep 26, 2016 at 17:36 UTC ( [id://1172649]=note: print w/replies, xml ) Need Help??


in reply to 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';

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

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 +");

    Many many thanks for the reference

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1172649]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (5)
As of 2024-03-28 15:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found