StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONew Connection fails during Add New Data Source Dialog
text
Body
copied!<h2>The Problem</h2> <p>If I have Visual Studio 2010, Service Pack 1 installed, and I go to Data, Add New Data Source and click Database, it brings up the standard Choose Your Data Connection wizard page.</p> <p>On that page, if I have an existing connection configured, I can then select it, and add that data source to my project, no problems, no issues.</p> <p>On the other hand, if I click New Connection... it just bombs out, wizard closes, as if I had done nothing. Now keep in mind, Visual Studio doesn't close, and there are no exceptions, errors, or warnings, the dialog window just disappears.</p> <h2>Unsuccessful Attempts to Resolve Issue</h2> <p>I've checked the simple things, using a debugger, and a valid machine config file, not sure what else I might be missing.</p> <ol> <li><p><strong>Using a Debugger</strong></p> <p>I tried starting a 2nd copy of Visual Studio as I did this, and attaching a debugger to the process, with all exceptions checked in my debug menu, and still nothing.</p></li> <li><p><strong>Validating machine.config file is valid</strong> </p> <p>I backed up my machine.config file, and used another person's working machine's machine.config file, and I'm still having issues.</p> <p>I have since reverted back to my own machine.config file.</p> <p>I suspect the machine.config might be the issue, but I thought taking a working one should work, unless I'm missing one of the registered providers? I don't know enough about how this wizard works behind the scenes though, or what sections/lines of the machine.config file exactly drive the wizard.</p></li> <li><p><strong>Uninstalling all third-party database providers</strong> </p> <p>I have recently tried uninstalling Oracle, SQLite, beta versions of SQL Server Compact Edition, and MySQL providers in hopes that one of them set a registry entry or configuration entry that was negatively impacting my ability to create new connections and the error still occurs.</p></li> <li><p><strong>Reinstalling Visual Studio</strong> </p> <p>I reinstalled Visual Studio, complete uninstall, and reinstall, no extensions, or nothing, and the issue exists, definitely convinced its a configuration error at this point, I could use the expert opinion of someone who knows more about the configuration behind the scenes for this dialog though.</p></li> </ol> <p>Any help in resolving the issue would be greatly appreciated.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload