ODBC in SQL Server CE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rohit - 03 Dec 2007 19:25 GMT

Hi,

Does anyone know if and how I can access a SQL Server CE 3.0 database using
ODBC? (Is there an ODBC driver available for SQL Server CE?)

If not, what are the methods for accessing a SQL Server CE 3.0 database?

Thanks.

Reply to this Message

William Vaughn - 03 Dec 2007 20:23 GMT

There is no ODBC driver and none is anticipated at this point. Basically,
you have two choices: the (somewhat limited) OLE DB interface or the SqlCe
managed provider.

See my ebook "Hitchhiker's Guide to SQL Server 2005 Compact Edition" for
detailed information on the ways to connect to the SQLCe engine.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message