Connecting to Sql Server CE via ODBC Connection

Question

I have an app that 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

Answer 1

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