Odbc Driver For Sql Server Compact

Connection strings for SQL Server 2000. Connect using SqlConnection, SQLNCLI10 OLEDB, SQLNCLI OLEDB, sqloledb, SQLXMLOLEDB.3.0, OleDbConnection.

Microsoft SQL Server Compact SQL CE is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

odbc driver for sql server compact

Altova User Forum

In computing, Open Database Connectivity ODBC is a standard programming language middleware application programming interface API for accessing database.

  • I have a problem creating an ODBC data source connection for SQL-Server on Windows 7. Problem summary: ODBC datasource connection can be created for the master.
  • SQL Maestro Group vendors powerful database administration, development and management tools for MySQL, Oracle, SQL Server, DB2, SQL Anywhere.
  • Text DSNs One generic DSN type you might want to explore is the Microsoft Text ODBC driver. With this driver, you can set up an ODBC connection to one or more text.
  • Download the February 2007 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005.

Important: this is not a Support Forum. Experienced users might answer from time to time questions posted here.

If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Rank: Member

Joined: 7/18/2012

Posts: 14

If I try to connect with vbscript like:Quote:Set rs CreateObject ADODB.Recordset

Connect PROVIDER Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source C: temp my_database.sdf

Source SELECT FROM MyTable

rs.Open Source, Connect, adOpenForwardOnly

connection is made successfully.

But when I try the same in DatabaseSpy, by selecting Add a data source then clicking on ADO Connection tab and manually entering:Quote:

PROVIDER Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source C: temp my_database.sdf

in text box, then click Connect button, I get:Quote:

Currently support to connect to the database you have selected is not provided with ADO.

Please try to connect using ODBC where it should be supported.

There is not ODBC driver available for MS SQL Server CE.

BTW, Visual Studio makes the connection on the fly if I open C: temp my_database.sdf. It reports that provider is . NET Framework Data Provider for Microsoft SQL Server Compact 3.5

Any ideas why we can t open this database in DatabaseSpy.

guest

Use of the Altova User Forum s is governed by the Altova User Forums Terms of Service.

Email this topic

Watch this topic

Please note that the Altova User Forum was launched so that our users have the possibility to interact and exchange their experiences regarding Altova s product line with one another. It must be pointed out that our support engineers and software engineers regularly post answers to questions in the user forum as an extra service, however this is not a replacement for the regular support mechanism and we cannot in anyway guarantee that a question will be answered or give a specific timeframe for an answer.The user forum was not intended to replace the online support form, but was implemented as an additional source of information after repeated requests for a user based forum in which users can help one another.

NEW COMPONENTS TO THE MICROSOFT SQL SERVER 2012 SP1 FEATURE PACK. Microsoft Attunity Oracle CDC Designer and Microsoft Attunity Oracle CDC.

Connection strings for SQL Server 2008. Connect using SqlConnection, SQLNCLI10 OLEDB, SQLXMLOLEDB.4.0, OleDbConnection, SQL Server Native Client 10.0 ODBC.