ODBC support

Can CE be called from an app. that makes ODBC calls?

Thanks.

Ah, there is no ODBC driver for the SQLCe engine that I know of. It uses an OLE DB interface...

hth

|||Here is a code example under OLEDB

http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx|||Yes, but he was asking about ODBC access. No, I'm not sure why he needs to use ODBC...|||

I would guess that the reason he wanted an ODBC adapter was because he wanted the database to be accessible from some tool that supports ODBC, but not OLEDB.

I'm actually surprised that there isn't some sort of generic ODBC-from-OLEDB adapter, so that if you have a DataSource accessible via OLEDB, you can turn it into an ODBC DataSource.

|||IIRC there was a OLEDB to ODBC bridge at some point that worked with ADO classic... ?|||

Two:

1) The existing (calling) application uses ODBC calls;

2) ODBC is the only industry standard for database access. It is an indication of MS's market power that they can introduce a new database product and ignore it.

- A

|||

I you can remember the neame, that would be very helpful.

- A

|||Ah, be that as it may, OLE DB and the .NET Framework providers are also industry standards. Yes, ODBC is certainly the oldest, and least flexible but granted, it's still in wide use. ODBC is supported in both OLE DB data access interafaces and .NET providers. The tiny SQLCe database is small because its support is focused on current technology. If it was more flexible in its interfaces I expect it to be larger and less useful for its intended purpose.