.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Unspecified error (MS Visual Database Tools) in SSMSEE

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 
I get an unspecified error message when I try to manage tables in a SQL Server 2008 express edition using SSMSEE 2005.  I am connected to a 2008 instance.  I found a post in this forum with exactly the same Title, but it does not solve my problem. 
Rob Evans


View Complete Post


More Related Resource Links

Unspecified error (MS Visual Database Tools)

  

Hi all.

 

I am receiving this message.

Anyone can explain me what is going on, please?

 

Unspecified error
 (MS Visual Database Tools)

------------------------------
Program Location:

   at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.NewTable(Object dsRef, Object pServiceProvider)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TableDesignerNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorTy

Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs

  

This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009


ERROR: Cannot show Visual Studio 2008 Tools for Applications editor - SP1 IS applied

  
Using BI Studio, attempting to put a small VB script in a Script Task, hitting the Edit Script gives:   Cannot show Visual Studio 2008 Tools for Applications editor   ADDITIONAL INFORMATION: Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.VSTAScriptingLib)   NEED A FIX, PLEASE, AS I'VE ALREADY LOADED VS2008 SP1...!   I have now also uninstalled VS2008 entirely, along with .NET 3.5 SP1 rebooted several times, reinstalled from the January Team System Database Edition, applied VS2008 SP1 and .Net 3.5 SP1 from Microsoft Downloads with the usual reboots to make sure, and I'm still hosed...   Microsoft Visual Studio 2008Version 9.0.30729.1 SPMicrosoft .NET FrameworkVersion 3.5 SP1 Installed Edition: Enterprise Microsoft Visual Basic 2008   91901-270-1018792-60217Microsoft Visual Basic 2008 Microsoft Visual C# 2008   91901-270-1018792-60217Microsoft Visual C# 2008 Microsoft Visual C++ 2008   91901-270-1018792-60217Microsoft Visual C++ 2008 Microsoft Visual Studio 2008 Tools for Office   91901-270-1018792-60217Microsoft Visual Studio 2008 Tools for Office Microsoft Visual Studio Team System 2008 Database Edition   91901-270-1018792-60217Microsoft Visual Studio Team System 2008 Database Edition Microsoft Visual Web

Error to Add a Database to a Visual Studio 2010 Project via the App_Data Folder

  

I am trying to add a new database via the App_Data Folder and I receive an error described below.

When I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly.  Please verify the installation of the component or download from the URl."

I can create a db via SQL Server Mgmt Studio, it connects fine, and I can see tables.

Visual Studio- Server Explorer connects fine to the Database, I can see the tables.

Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer.  I had previously removed SQL Server Express.

Why cant I access the database within my project, when Im able to connect to this fine within Visual Studio Server Explorer?


Error to Add a Database to a Visual Studio 2010 Project via the App_Data Folder

  

I am trying to add a new database via the App_Data Folder and I receive an error described below.

When I attempt to add ANY TYPE OF SQL SERVER DATABASE through the App_Data folder I receive this error "Connections to SQL Server Files (*.mdf) require SQL Server Express 2008 to function properly.  Please verify the installation of the component or download from the URl."

I can create a db via SQL Server Mgmt Studio, it connects fine, and I can see tables.

Visual Studio- Server Explorer connects fine to the Database, I can see the tables.

Im running XP SP3 w/ Visual Studio 2010 and SQL Server 2008 R2 Developer.  I had previously removed SQL Server Express.

Why cant I access the database within my project, when Im able to connect to this fine within Visual Studio Server Explorer?


VisuaL Studio Tools for Application / InfoPath error

  
I'm getting an "configuration system failed to initialize" error when trying to apply an event  to a control (any control) on infopath form. I tried to re-install infopath, reinstall FrameWork 3.5.1, nothing helps. Does anyone know where to find info?

Error Accessing Oracle Database in a visual web part.

  

Hello All,

  I'm new to SharePoint development.  I’ve the development box set up with Windows 7 64 bit, share point development environment installed (SharePoint Foundation) with all the hot fixes and I’m able to create and publish a visual webpart and access it. I’ve also installed the 32-bit ODAC (ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual Studio) and I see the Oracle.DataAccess file in the GAC installed. Here are the results from GAC

C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC>gacutil /l Oracle.DataAccess

Error while setting up application on Win7 using Visual Studio.NET 2003

  

Hi All,

Getting the below error while setting up application on Win 7 using visual studio.NET 2003.

Error:

cannot find the components for communiacting with the front page server extensions...

 

I understand by the error, i need to install Front page server extension, but not able to figure how to install using IIS 7.5.

I had XP machine with IIS 5.1, able to find the option.

 

Need your help in resolving this.

 

Thanks

Abdul 


ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch

  

Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50


The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

Activation error occured while trying to get instance of type Database, key "DBName"

  

Im using Enterprise library 5.0
I have a scenario, where I have to access two different databases in my application.

Basically this application is a webservice,delployed on my local for testing purpose.
I'm trying to access this web method from diffent windows application, default connection works fine but the other database throw's exception.

Problem is only my defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with "MYCON2" it works fine, if I try to access the other database which is not default, throws exception.

<dataConfiguration defaultDatabase="MYCON1" />
<connectionStrings>
<add name="MYCON1" connectionString="Data Source=server1;Initial Catalog=dbName1;User Id=Username1;Password=password1;"
providerName="System.Data.SqlClient

" />
<add name="MYCON2" connectionString="Data Source=Server2;Initial Catalog=dbName2;User Id=Username2;Password=password2;"
providerName="System.Data.SqlClient" />
</connectionStrings>


Database myDB=EnterpriseLibraryContainer.Current.GetInstance<Database>(); --> works fine for the default database (MYCON1)


Database myDB=EnterpriseLibraryCo

Tools for memory error check in VS2005

  

Dear all,

I am going to write vs2005 program with ASP.NET and C++.

As you know that C++ will involve a lot of memory error handling.

Do you know is there any tools for checking memory error in Code Behind C++??


First Look: Visual Studio 2010 Tools for SharePoint Development

  

This article provides a first look at tools in Visual Studio 2010 designed to support development and deployment of SharePoint 2010 solutions. The article provides an example of designing and deploying a visual Web part.

Steve Fox

MSDN Magazine October 2009


Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More

  

If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009


VSTS 2010: Agile Planning Tools In Visual Studio Team System 2010

  

Visual Studio Team System (VSTS) 2010 introduces product backlog and iteration backlog workbooks and reports that will help agile teams plan and manage releases and iterations.

Ajoy Krishnamoorthy

MSDN Magazine January 2009


Visual Studio OBA Tools: Simplify OBA Development With Interop API Extensions

  

To introduce you to VSTO Power Tools Office interop API extensions, we'll walk through the development of an application that automates Outlook, Excel, and Word.

Andrew Whitechapel, Phillip Hoff, and Vladimir Morozov

MSDN Magazine December 2008


Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio

  

We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008


Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals

  

Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

Brian A. Randell

MSDN Magazine February 2007


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend