locked
IVsDataConnectionDialog could not be initialized

    Question

  • Hi,

    i am getting this error message while trying to Connect to a Database from the Server Explorer:

    "Unable to add data connection.
      The IVsDataConnectionDialog could not be initialized"

    i am using VS2008 mainly and i have also a VS2005 instalation that works just fine.
    i have tried to uninstall/repair for 3 time now.

    any idea?

    thank you
    • Edited by Martin Xie - MSFT Monday, December 22, 2008 3:39 AM Modify HTML View code to display an illustration on your post.
    Wednesday, July 16, 2008 1:36 AM

All replies

  • yogly said:

    i am getting this error message while trying to Connect to a Database from the Server Explorer:

    "Unable to add data connection.
      The IVsDataConnectionDialog could not be initialized"




    The IVsDataConnectionDialog provides access to the Add Connection dialog box, with which you can obtain data connection information from users.

    Please check this similar issue for reference:
    http://www.eggheadcafe.com/software/aspnet/30355862/unable-to-add-data-connec.aspx

    Wednesday, July 23, 2008 2:46 AM
  • I am having the same issue. Dialog works with any problems in 2005 version but not in 2008. Repairing 2008 will not help at all. Were you able to resolve this?
    Wednesday, December 17, 2008 10:37 PM
  • It works fine with VS 2005 and VS 2008 on my machine. I cannot repro this issue.

    IVsDataConnectionDialog Interface
    Provides access to the Add Connection dialog box, with which you can obtain data connection information from users.
    Namespace:  Microsoft.VisualStudio.Data.Services
    Assembly:  Microsoft.VisualStudio.Data.Services (in Microsoft.VisualStudio.Data.Services.dll)

    1. As you said that this issue occurs in VS 2008, you can consider reinstalling .NET Framework 3.5 SP1 and VS 2008 SP1.

    .NET Framework 3.5 Service Pack 1
    http://www.microsoft.com/downloads/details.aspx?FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7&DisplayLang=en

    Visual Studio 2008 Service Pack 1
    http://www.microsoft.com/downloads/details.aspx?FamilyID=fbee1648-7106-44a7-9649-6d9f6d58056e&DisplayLang=en


    2. Here is similar issue about: Unable to add data connection in VS 2005
    http://social.msdn.microsoft.com/forums/en-US/Vsexpressinstall/thread/ae47e254-e4af-4290-a221-1abd7ad839d0 
    Try to modify Registry:
       1) Open the registry
       2) Rename [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0]
           To [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0back]
       3) Restart Visual Studio

    3. Try general troubleshooting to Visual Studio IDE issues:

    http://social.msdn.microsoft.com/Forums/en/vbide/thread/15a42319-26f2-4a17-9943-f6feda086322/
    Monday, December 22, 2008 4:10 AM
  •  Thanks for the post.

    I did the Registry modification and it solved my issue.

    I wish I would have seen this post before I removed VS2005 and VS2008 off of my computer.

    Thanks again
    Yann.
    Friday, March 06, 2009 5:57 PM
  •  Thanks for the post.

    I have the same problem

    I did the Registry modification and it solved my issue.


    Wednesday, December 16, 2009 10:33 PM
  • To save others confusion I'd like to add a few things to this thread that discovered by trial and error. 

    My environment is VBExpress 2008 (shows in the registry as VBExpress 9.0) on WinXp sp3.  After deleting the Registry Keys mentioned earlier in this post  I was able to get rid of the ivsConnectionDialog messge but only after I deleted the key and the profile folders for it (C:\Documents and Settings\{my login}\Application Data\Microsoft C:\Documents and Settings\{my login}\Local Settings\Application Data\Microsoft--http://stackoverflow.com/questions/976542/how-do-i-fix-a-unable-to-add-data-connection-the-ivsdataconnectiondialog-could), deleting the VBExpress folders.  Once that was done I started getting a package error "Package 'visual studio data designer extensibility package' has failed to load properly."   Searching this error pointed me toward running the command devenv /resetskippkgs from the command line.  Devenv.exe however is the startup executable for VB and does not exist in VBExpress.  Fortunately the command line switch is the same so once I figured out the VB executable's name VBExpress.exe it worked great.  As soon as I reloaded my application the connection object reappeared without further errors. 

    Since my original error was the package message I suspect that if I had tied the latter solution first it might have saved a heartache but when my initial attempts to fix it failed I tried removing the bad connection and re-adding it which is when the ivsDataConnectionDialog error started.  It all might have been easier if MS used the same executable for Express and the full version. 

    As to why this occured I am going to lay out some clues and maybe someone will recognize something that may have caused the problem.  The application is a front end wrapper for a batch of legacy MSAccess applications, all of which use a common workgroup security file.  To enhance the security I created a new workgroup with only a few "power user" accounts assigned to it with some very complex passwording.  The orignal work group file was to have only the account for the VB App to access a master security DB that would assign users rights to one or more of the various apps, the corresponding "power user" account & password  and then redirect them to the appropriate .mdb and corresponding workgroup file.  Initially this seemed to work very well but after a few logon\logoff cycles my applications no longer would start giving me a "not valid account name or password message".  Trouble shooting this led me to put both the front end wrapper and the applications into the same work group.  That caused everything to fail.  Thinking I had somehow cached some bad data somewhere I decided to reboot and then everything went down hill resulting in the problem I spelled out above.  With any luck I will resolve the workgroup problem and get my wrapper working but in the meantime if anyone thinks they know what caused the VB errors (or my Work group problem), please share.

     

    Tuesday, February 02, 2010 3:14 AM
  • yogly said:

    i am getting this error message while trying to Connect to a Database frm the Server Explorer:

    "Unable to add data connection.
      The IVsDataConnectionDialog could not be initialized"




    The IVsDataConnectionDialog provides access to the Add Connection dialog box, with which you can obtain data connection information from users.

    Please check this similar issue for reference:
    http://www.eggheadcafe.com/software/aspnet/30355862/unable-to-add-data-connec.aspx


    Could you give more explanation on it? I know it's something stupid, But I still do not understand.
    Tuesday, August 17, 2010 2:16 AM