I'm trying to connect with ADOCE 3.1 to a sdf file (SQLCE v 3.5).
I'm not able to open the connection because I think that sqlceoledb is non registered correctily or at all.
I read some post saying that it should be registered via regsvrce (for CE 5.0 in my case).
This tool is avilable in evC 4.0..I found, but I don't have it.
Is there any other way to achieve this or a place where to find the correct regsvrce(I found prevoius versions that don't work).
Where are informations stored in the registry (I mean which keys)
Below the code I use:
Dim cn as Object
Dim rs as Object
Set cn = CreateObject("ADOCE.Connection.3.1")
cn.Open "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=\Flashdisk\test\test.sdf"
Set rs = CreateObject("ADOCE.Recordset.3.1")
rs.Open "SELECT * FROM TestTable",cn,3,3
Thank you ErikEJ for your quick reply.
I tryed to install the cab suggested, now the scenario is changed. The connection is succesful but the recordset is empty.
I'm afraid the problem is now connected to the database format (3.5). I'll do some other investigations and then post further replais.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?