Re: Integration with Visual Studio 2005 Tools for Office

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx>
Date: Mon, 21 Jan 2008 08:07:23 -0500

Clint,

As far as I know you need VS 2005 Standard or above or VS 2008 Professional or above in order to get the SQL Compact data tools. You can also use SQL Express 2005 sp2 Management Studio if you only want the database design and query tools and don't care about the code generation tools.

--
Ginny Caughey
Device Application Development MVP
www.wasteworks.com
Software for Solid Waste Management

"Clint" <clintonsarek@xxxxxxxxxxxxxxxxxx> wrote in message news:901A6AAE-DBBA-4FDF-8777-BE892D7D7B96@xxxxxxxxxxxxxxxx

I have installed VSTO 2005 and have discovered that the designer tools for
SQL Compact Edition do not function. They appear to function fine in VS 2005
Professional but not in VSTO.

Does anyone know how to get the tools to work in VSTO or do I have to now
purchase VS Professional

I apologise if this is the wrong group for this post but I am running out of
solutions.

Follow-Ups:
- Re: Integration with Visual Studio 2005 Tools for Office
  - From: Clint

Prev by Date: Re: Help With MS SQL Error: The value's length for key 'data source' exceeds it's limit of '128'.
Next by Date: Re: Help With MS SQL Error: The value's length for key 'data source' exceeds it's limit of '128'.
Previous by thread: Help With MS SQL Error: The value's length for key 'data source' exceeds it's limit of '128'.
Next by thread: Re: Integration with Visual Studio 2005 Tools for Office
Index(es):
- Date
- Thread

Relevant Pages

Re: OLEDB Error
... It is possible to use a SQL Compact data source for a VSTO mail merge app in VS 2008 on my machine. ... If that also works on your machine but setting up mail merge with Word alone doesn't work, then I'd assume that some of the functionality that Word needs from OleDb providers simply isn't there for SQL Compact. ... unmanaged code because of the>127 char problem on the select statement, but it should work fine if you put you write a data access layer in managed code, expose it via COM, and then you can use the COM component from unmanaged code. ... I now just tell my customer nCharVar columns> 127 are not supported due to a bug in the OleDB provider. ...
(microsoft.public.sqlserver.ce)
Re: Integration with Visual Studio 2005 Tools for Office
... When I purchased VSTO and compared the tools I found ... As microsoft are pushing SQL Compact ... Express 2005 sp2 Management Studio if you only want the database design and ... Professional but not in VSTO. ...
(microsoft.public.sqlserver.ce)
Re: SQL Compact Edition and VSTO
... When I purchased VSTO and compared the tools I found ... As microsoft are pushing SQL Compact ... It would be nice if you could simply purchase an addin to ... developer office) but do need the office tools, ...
(microsoft.public.vsnet.vstools.office)