Connecting to Sql Server CE via ODBC Connection

I have an app tha开发者_如何转开发t uses the OdbcConnection classes to connect to Oracle and Sql Server. Works great. But I'm writng some tests and want to connect to Sql Serve CE, which is built into VS2010. What is the connection string to use? This fails:

Data Source=Testing.sdf

There is no ODBC provider for SQL CE so no kind of connection string will work for you. To connect to SQL CE you'll need to use either OLE DB or the managed interface.

--EDIT--

Archived URLs:

• OLEDB
• Managed Interface