
Error #-2146824582 ADO could not find the specified provider Using SQL SERVER CE
I get this error message when i run the following code
Dim cn As ADOCE.Connection
Dim rs As ADOCE.Recordset
Set cn = CreateObject("ADOCE.Connection.3.1")
Set rs = CreateObject("ADOCE.Recordset.3.1")
cn.Open "provider=Microsoft.SQLSERVER.OLEDB.CE.1.0;data
source=\ATACard\yasir.sdf;"
rs.Open "SELECT * FROM mycust", cn, adOpenDynamic, adLockOptimistic
Application is eVB, WINCE3.0 x86 PDA
any ideas?