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.
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. -- ____________________________________ 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) ----------------------------------------------------------------------------------------------------------------------- "Rohit" wrote in message news:E8E804C8-2653-4473-9205-20862A9E7A4D@microsoft.com... > 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. >
