Need help connecting to SQL Server CE from PB 11.5

[JohnT]

Hello all,
I would truly appreciate some assistance in trying to connect to a MS
SQL Server CE database from within the PB 11.5 development environment
as well as from within an application. Well, I suppose if I can solve
the first issue the second will also be solved.

I successfully created a new SQL Server CE database from within SQL
Management Studio (and then closed SQL Management Studio), and then I
went into the PB database profile window and created a new Microsoft
OLE DB profile. I selected 'Microsoft.Jet.OLEDB.4.0' as the provider,
but nothing showed up in the data source drop-down, so I entered the
path to the database file.

Here is what the profile looks like:

// Profile emr
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <********>
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='C:\EMR
\emr.sdf'"

But when I try to connect I always get the following error message:

SQLSTATE = 3028
Microsoft JET database Engine
Cannot start your application. The workgroup information file is
missing or opened exclusively by another user.

Again, any assistance would be mist appreciated! Thanks!

[JohnT]

Hello?

Has **anyone** ever successfully connected to SQL Server CE via
PowerBuilder????????????????????????

Please help!!! Thanks!