i am using sql server ce 3.5  my oledb provider is Microsoft.SQLSERVER.CE.OLEDB.3.5.  how do i modify appmain.vb to use this?  i don't think the connection wizard handles this but i could be wrong.  can someone step this beginner through whats necessary to hook my app up to the compact edition? 

Thanks in advance!

Mike

Oh my. That worked on my work PC, I was trying this stuff at home last night, apparently there is a problem with my install on that box that was the cause of my issues, better late than never.

Thank you for posting this. On a PC that has a good install ( ) I got OLEDB working.

1) Created OLEDBSOURCE class

2) use #1 in appmain:

MicroFour.StrataFrame.Data.DataBasics.DataSources.Add(New OLEDBSOURCE("", "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\ioivb.sdf"))

3) Change my fills to use OLEDBCommand instead of SqlCommand

 

 

Keith Chisarik