Using The Extensibility Project Template To Write An Add-in For SSMS 2008 R2?
Jun 17, 2010
I am trying to write an add-in into the SSMS 2008 R2 IDE. I believe it is possible, though maybe not fully supported by Microsoft. I have created a new project in Visual Studio 2010 of type Extensibility - Visual Studio Add-in. This has created my project and all of the relevant code to get the add-in loaded onto the Tools menu. The only line of code I have added is in the OnConnection method to display a messagebox so I know it has at least loaded.
When I build this as is, it will load as an Add-in into VS 2010 onto the Tools menu - which is fine - at least part is working. But when I try to add this as an Add-in into SSMS 2008 it keeps giving me the error message:The Add-in 'DataFollower.Connect' failed to load or cause an exception. Would you like to remove this add-in? ... Error Message: No such interface supported.
Below is a top half of the code in question. This code was created directly from the VS Add-in template - nothing has been altered. The error occurs on the line:
_applicationObject = CType(application, DTE2)
This is running on a Windows 7 64bit machine, SQL 2008 R2 64bit and VS 2010.
Imports System
Imports Microsoft.VisualStudio.CommandBars
Imports Extensibility
Imports EnvDTE
[code]....
View 1 Replies
ADVERTISEMENT
Aug 4, 2010
I'm working on my first T4 code generation tool to add some Stored Procedure helper code to my project. I've created custom types (e.g. StoredProcedure and StoredProcedureParameter to help with my code generation and have included the assembly and namespace references in my code:
<#@ template debug="false" hostspecific="false" language="VB" #>
<#@ output extension=".generated.vb" #>
<#@ assembly name="$(TargetPath)" #>
<#@ import namespace="StoredProcCodeGenerator" #>
This allows me to use my custom types in my T4 template code. However, because my custom types exist in the same project as the T4 template code, I can't recompile my project once I run the template code without restarting Visual Studio. This isn't very much fun.
I read a great article that addresses this exact issue by using the T4 Toolbox, but it's not working. Either I'm implementing the VolatileAssembly directive wrong or the T4 toolbox simply didn't get installed. I'm not sure that the toolbox got installed correctly (I'm using VS 2010 on Win XP).
View 3 Replies
Aug 11, 2009
I'm developing the skill to create addin for SSMS and I've develop a sample addin for Microsoft SQL Server management studio express using a tutorial[URL]..I tried similar addin with all the needed references in project specified in tutorial code, its not showing anything in the Miscrosoft SQL server management studio.
I've SQL Server express 2005 and Microsoft SQL Server management studio express installed on my machine. and I've created the add in by using VS 2008. Please anybody let me know whether there is wrong in the development environment. I've created thread in this section as project is related to VS 2008,
View 1 Replies
Aug 20, 2011
In VB.NET,I want to create template at runtime and save it the template with name. for ex : Administrator design a page with 5 fields like using firstname, lastname, dob,nationality and job. He want to assign this page to the user with some restriction like user1 need to enter the all the fields and save it the forms as user1profile, but user2 need to enter only firstname and lastname and save it as user2profile.(in features, he can remove the fields from the form).
View 1 Replies
Nov 5, 2010
I am at a loss to figure out why this code results in 2 errors when I try to Parse it inthe SSMS.
@Collection varchar = Books,
@Title varchar = 0,
@Authors varchar = 0,
[Code].....
I think that I re wrote this query ten times todaday and continue to get errors and don't know what my problem is
There are underlines in red under the 0 in the BookLoanStatus and under all of the parameters in the SQL.
View 2 Replies
Nov 5, 2009
I want to change the defaults of setup project, (ex. installallusers to true, it comes with false). Any one know where is the setup project template, so I can change it
View 6 Replies
Apr 3, 2010
After installing Monobjc and playing around with the Monobjc Application Project under C# in MonoDevelop, I noticed that there is only an empty Monobjc project under the VB section.
Obviously this template adds all the correct references but doesn't add the basic files for the application to run. I've tried creating a class with:
Imports System
Imports Monobjc
Imports Monobjc.Cocoa
Class Application
[Code]...
Also if I add in a xib file from IB, how do I generate the designer code for the partial AppDelegate class?
View 1 Replies
Apr 27, 2009
I was at a class recently, and the instructor started a new Visual Studio 2008 project using a "COM project" template. Now that I'm back, I tried finding that template in my installation of VS2008 with no luck. Does anybody know where I can find that template, or failing that, what it might be doing to achieve its effect?
View 2 Replies
May 6, 2012
IDE :: Project Template Awareness for Auto-Generated CodeE
View 2 Replies
Aug 5, 2009
What are their differences? What can you do with one that you cannot with another?
View 1 Replies
Jul 8, 2010
I developed a project is vb.net express 2008. Published it and the whole clickonce didn't work. Now I have Visual Studio 2008. I opened my project and have been working on it for weeks now. when I build it today it said biuld successful but the new .exe file etc have not been written to my Release folder.
View 20 Replies
Nov 4, 2010
I'm new to SQL Server but have been using Access with Visual Basic for quite some time.I am moving an existing project from Access to SQL Server 2008 Express R2. Using the SSMS I redid a number of Queries and SSMS puts the queies in a folder entitled "Project" which is not pointed at any specific database on the server.When I try to call a query in Visual Basic I get the error "Could not find stored procedure...".
Obviously there is something that I am missing, but I don't know what. Can anyone tell me where I should have these queries filed in SSMS?
View 1 Replies
Jul 26, 2011
Let us start with...yes I am new to SQL and really only a lightweight programmer. So I am assuming that I am doing something horribly wrong. I have spent days on the MS forums looking for an answer to no avail. So I am going to give as much info as possible. Application language is VBExpress 2010 and using SQLExpress 2008. The Database contain basic tables, no stored procs, no views, no diagrams. The Application has configured diagrams where one of the tables has inner joins... Tables origninally built in SSMS, but have been altered in VBE.
[Code]...
View 1 Replies
Sep 30, 2011
how many of you out there in the VB.NET community have installed VS2010 SP1 and are experiencing this issue with the loss of intellisense in SQL Server 2008 R2?I'm holding off installing SP1 because I kind of like the intellisense thingy (though RedGate's SQLPrompt 5 is way better - have it at home).So is this pee-ing you off, have you explored workarounds, tries the hotfixes (that apparently don't work for many setups)?url...Please note that even though Cumulative Update 9 (CU9) was released the month there are still people it does not work for..including a coworker using a similar setup as mine (Win7 Pro, x32) This is a disaster and embarassment for MS IMO
View 2 Replies
May 5, 2010
For reasons that are beyond my control, I have three Projects. Projects A and B reference project C. Project A references project B so that it can open a large form in project B. I now need to open that large form from project C, but VB won't allow me to add a reference from C to B because that would create a circular dependency. I found a way around it, though. I created a Timer in A, and when I opened C from A, I passed in that timer. When the user performs a certain action, I enable the Timer from A, and this causes C to open B for me.
View 2 Replies
Nov 15, 2010
i was developing Voice Chat Application in visual Basic .NET 2008 i try a lot methods to make installer for it :
1- i add Project Setup Project for my Project for Visual Studio 2008 Deploy & setup Type Projects and make it with output option and detect dependices
2- i try make it with Setup Factory 8.2.1
3- i try with MSI Factory 2.0
4 i try with Setup Factory 6.0
and after making installer copying it to my test virtual Machine or my friend lap and install it i get this error when try to run my application :
[Code]...
View 3 Replies
May 3, 2009
create a Class Template for VB so that when I click Add -> Class, in the Add New Items window, that class will be displayed? And also the variables that are needed inside the class. I guess I need a tutorial.
View 3 Replies
Jul 21, 2009
I have VSTS 2008 SP1 with Extensions for SharePoint Svcs 1.3 running on Windows Server 2008. I VB Class Library project and I am trying to add a new CSS file to the project. My instructions were to use Add New Item and use the Stylesheet Template. But I do not see any such installed template under the categories.Where do I find this CSS Stylesheet template for VB porojects and install it in VSTS 2008 ?
VSTS 2008 installed products:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
[code]....
View 4 Replies
Oct 16, 2009
I'm trying to create a Windows Service. When I look up tutorials they all say to Choose File--New Project Windows Service Template.I don't have a Windows Service Template (see attached jpg).I looked at Microsoft's VS 2008 Comparion chart PDF document and it says that VS 2008 STD has this template.
View 2 Replies
May 15, 2009
I want to creat office addins with my VB 2008 express, but i can NOT find the template.
View 3 Replies
Aug 6, 2009
I have a custom dgv column and custom cell.I m trying to instance the column and pass it an instance of the cell as a template, but it's not working.my code needs a form with a button and dgv on it. When the button is click, the text in cell(0,0) should toggle from on to off. [code]
View 2 Replies
Mar 25, 2011
An in-line table valued function in SSMS takes about 6 seconds to return 11088 records. The same function in VB .Net 4.0 using TableAdapters.InputTableAdapter.GetData (Created with data set designer) takes about 15 minutes complete.Both are executed from the same workstation.Why does this discrepancy exist?
Workstation:
Windows XP SP3, 2GB
VS2010 Ultimate
.Net 4.0 Framework
Server:
SQL Server 2008
View 3 Replies
Feb 1, 2012
I am trying to convert a VB.NET project to C#. I am conveting all the forms and classes as required, but I don't know where I need to write the events from ApplicationEvents.vb (I believe its autoGenerated from Properties) Here is the code in my ApplicationEvent.vb file:
[Code]....
View 4 Replies
Apr 21, 2009
How to write Technical Documentation for a project flow
View 1 Replies
Dec 7, 2009
I want to create a Windows Service using VB.Net, but in VS2008 Standard, you don't seem to get the "Windows Service" template I've used before.
What's the best way of creating such a service, without resorting to using the C++ template?
View 2 Replies
Feb 22, 2012
Im using VB.NET 2010, and trying to write an Excel project. The code I'm writing exists on Sheet1 (main sheet with small GUI), and I'm trying to write some values to Sheet2.
View 1 Replies
Nov 28, 2011
How do i get multiple icons in a project for use with shortcuts OUTSIDE the project..
View 7 Replies
Jun 28, 2009
Is there a way that you can export a file from one project directly into another project?
For example, in one project i have a file called authInvalid.vb and i need to export it into another project?
View 4 Replies
Jun 16, 2009
Is there a tool to convert a VB.NET 2005 project to a C# 2008 project. I am trying to convert our project to VS 2008 and mostly port all the vb.NET code in some projects to C# 3.0/3.5.
View 6 Replies
Apr 26, 2009
i'm doing a program, and i'm working with a guy (he's kinda like a teacher) and he's teaching me tiered coding, UI, BLL and DAL.i've been taught to have the UI in one project, and the BLL in another, but they're in the same solution. pretty much i don't know how to declare things from the BLL project in the UI project.
View 1 Replies
