Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 664
  • Last Modified:

ASP on WinCE5 IIS - connect to SQL Compact v3.5

We have some ASP code running on a WinCE 5 device with IIS. The ASP-app is connecting to a SQL Compact database (.sdf). The code is as follows:
 
Set cn = CreateObject("ADOCE.Connection.3.1")
 Set rs = CreateObject("ADOCE.Recordset.3.1")
 cn.Open "Provider=Microsoft.SqlServer.Mobile.OleDb.3.0; Data Source=\Flash Storage\database.sdf; SSCE:Database Password='12345'"
 rs.Open "SELECT * from table", cn
 

After we upgraded the SQL Compact file to v3.5 we are not able to connect anymore. We tried changing the provider to Microsoft.SqlServer.Mobile.OleDb.3.5 and also Microsoft.SqlServerCe.Client.3.5 , but we get the error
 
 
 
 Parse error in script
ASP scripting compilation error: '800a0e7a'
Description: ADO could not find the specified provider.
 
We tried installing the following files:
 
NETCFv35.wce.armv4.cab
 sql.dev.ENU.wce5.armv4i.CAB
 sql.wce5.armv4i.CAB
 sqlce.dev.ENU.wce5.armv4i.CAB
 sqlce.wce5.armv4i.CAB
 
but still same error. Are we installing the correct files? and is the connection string correct?
 

Thanks...
0
kbjornst
Asked:
kbjornst
1 Solution
 
kbjornstAuthor Commented:
Solved it! Used provider Microsoft.SQLSERVER.CE.OLEDB.3.5 and installed

sqlce.wce5.armv4i.cab
sqlce.repl.wce5.armv4i.CAB
sqlce.wce5.armv4i.CAB

worked great!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now