[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • Last Modified:

Linked Server to Compact Edition possible in 2005 Express?

Hello

I am running SQL Server 2005 Express.  There is a third party app on the system that uses Microsoft SQL Server Compact Edition (using a file with an .SDF extension)

Is it possible for me to point to this as a linked server within SQL Server Management Studio? If so, how? I see no "Compact Edition" in the list of datasource types when trying to setup the linked server.

Additionally, if not, is it possible to set it up as an ODBC source?

Thanks
0
PMH4514
Asked:
PMH4514
  • 2
1 Solution
 
Mark WillsTopic AdvisorCommented:
Nope, not a linked server, but you can "connect" to it by simply bringing up the connection manager and browse for that SDF file.  Compact is not a server based solution, so is handled a bit differently...

What you have to do is write a bit of code and link to it that way...

What exactly are you trying to do ?
0
 
PMH4514Author Commented:
I am trying to insert into it from within a SQL Server stored procedure. The vendor of this third party component that plays a role in my system previously used an MS Access database, and my stored procedures insert directly into it as a linked server. Now they have changed and I guess I have to as well. It all needs to be programmatic, during runtime, can't be opening dialogs and manually browsing for anything. I don't see an ODBC driver for it either so I can't even write a C++  module to do it programmaticly it seems.
0
 
Mark WillsTopic AdvisorCommented:
ADO.net using the SQLCE components. You will need to add the SQLCE OLEDB stuff to your project...

You can also use entity framework : http://technet.microsoft.com/en-us/library/cc835494.aspx

There is a nice little project with source code converting / migrating data from SQL Server to Compact - it has all the connections and code samples... http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx   (points to the same johnnycantcode link in the other thread below)

You can also explore SQLCE_OLEDB : http://msdn.microsoft.com/en-us/library/ms171763.aspx

And here is a previous / related posting : http://www.experts-exchange.com/Programming/Editors_IDEs/.NET/Q_24214228.html
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now