How can we help you today? How can we help you today?
berkshireseany
Activity overview Badges (0) Posts (2) Comments (5)

Activity overview

Latest activity by berkshireseany

this appears to still be an issue.  I have a developer using version 4.3.20211 and every time we refresh, the target connection strings get broken again.  this is a bit absurd of a bug to be honest, why is our connection string being altered and broken?  you also drop the passwords off when we explicitly have it set to keep the passwords.  when will this be fixed?  it is massively decreasing productivity / comments
  1. Community
  2. SQL Change Automation
  3. "Invalid connection string: Keyword not supported: 'multiple active result sets'" when changing conn
this appears to still be an issue.  I have a developer using version 4.3.20211 and every time we refresh, the target connection strings get broken again.  this is a bit absurd of a bug to be honest...
0 votes
Alex, I seem to have solved the issue.  We have always linked our NuGet packages to C:\packages, so that we don't get duplicate files being pulled down in a ton of different places.  I didn't have my nuget.config set up on my new machine, so it was pulling files down to a different location.  I had separate build errors that led me to find that problem.  Once I resolved that, I closed and reopened my solution and the projects are now working ok.  Sorry about that, I never would have correlated that to the messages I was getting before. If I run into anything else I will let you know.  For now everything appears to be working. Thanks, Sean / comments
  1. Community
  2. SQL Change Automation
  3. Error when loading Visual Studio 2017
Alex,I seem to have solved the issue.  We have always linked our NuGet packages to C:\packages, so that we don't get duplicate files being pulled down in a ton of different places.  I didn't have m...
0 votes
Hi Alex, I came in after being off for a little bit, and it seems to have resolved itself.  Very odd.  However, I'm running into a different issue, and I can't tell if it's a problem with SQL Change Automation, or VS and SQL Server Projects.  This is only happening on my machine, and the machine of one other developer in our team, both are brand new machines. My machine has SQL Server Data Tools 15.1 installed, and I have the targeting packs for every .NET Framework version up through v4.7.2. When I got latest of our code from TFS, I receive this error when trying to load any of our existing database projects. I've seen similar errors before, but never where the target framework was listed as "" (blank). My project file, before choosing any of the options on that prompt, looks like this (we are using .NET Framework v4.6.2). Option 2 does nothing (presumably because it doesn't know what the target framework is), and option 3 just leaves the project unavailable. So I used option 1, thinking it would resolve whatever the problem was. Upon choosing the option, my project file changed to this (changed to .NET Framework v4.5.2). Of note, if I close and reopen the project, I get the same prompt showing that the target framework is still blank. So option 1 effectively did nothing as well. Since the project was at least accessible now, I figured I could use project properties to change it back to v4.6.2. When I opened the project properties, I found that the framework version dropdown was disabled, which I've never seen before. Nothing I've tried has allowed me to get the project to open correctly. I've uninstalled all of Visual Studio and my plugins/extensions and reinstalled from scratch, but the error persists. My old machine also had Visual Studio 2015 installed, so I installed that too, thinking maybe we had some weird project dependency, but that didn't change anything. Finally, I created 2 brand new SQL Server projects on my machine to test to see if they worked. One of them I created as a basic SQL Server Data project, and the other I created as a SQL Change Automation project. BOTH of the brand new projects work flawlessly. The framework dropdown looks as I would expect it to I had none of these issues on my old machine. My new machine is the only one with this problem, so I don't want to try to recreate the projects from scratch if I can help it, as it may affect the rest of my team.  Have you guys seen this happen at all before?  Is there any way to solve it? / comments
  1. Community
  2. SQL Change Automation
  3. Error when loading Visual Studio 2017
Hi Alex,I came in after being off for a little bit, and it seems to have resolved itself.  Very odd.  However, I'm running into a different issue, and I can't tell if it's a problem with SQL Change...
0 votes
Error when loading Visual Studio 2017
  1. Community
  2. SQL Change Automation
I recently just got a new computer, and had to reinstall SQL Change Automation on top of my new Visual Studio instance.  On my old machine, I was able to use SQL Change Automation on Visual Studio ...
2 followers 4 comments 0 votes
Hello, Nobody has yet answered my question about the ViewManager.ActiveView error from above.  An answer would be appreciated. Thanks, Sean / comments
  1. Community
  2. SQL Change Automation
  3. Issues since converting to SQL Change Automation from ReadyRoll
Hello,Nobody has yet answered my question about the ViewManager.ActiveView error from above.  An answer would be appreciated.Thanks,Sean
0 votes
Hi Ben, Thank you for your response.  Yes I recall reading that was the case, but for some reason on my machine I got a license expired message and was unable to continue using ReadyRoll in my VisualStudio 2015 instance.  Another team member originally had the same problem, but is apparently now ok to continue using ReadyRoll.  I've already performed the upgrade, so it isn't worth me trying to go backwards at this point. I did send a sample project over through the support request that was opened.  Using that project should show both issues I am running into - the deploy project button not working, and the static data refresh error. Additionally, I am occasionally getting an error with one of the SQL Change Automation windows when opening Visual Studio 2015.  I got it a few times the first day of install, but it seemed to go away until I got it once again this morning.  The error is: System.ArgumentException: The ViewManager.ActiveView must be a View contained within the ViewManager.WindowProfile.    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)    at RedGate.Versioning.Client.VsShell.VisualStudio.Windows.ToolWindow.ToolWindowVisibility.FindOrCreateAndShowToolWindow()    at RedGate.Versioning.Client.VsShell.VisualStudio.Windows.ToolWindow.ToolWindowVisibility.<LoadProjectInToolWindowAndShowWindowAsync>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.Versioning.Client.VsShell.VisualStudio.ShellIntegration.Events.VsSolutionEvents.<OnAfterOpenProjectAsync>d__33.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.Versioning.Client.VsShell.VisualStudio.EventsDispatcher.<InitializeFirstLoadedProjectAsync>d__21.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.Versioning.Client.VsShell.VisualStudio.VsPackage.EntryPoints.SqlChangeAutomationVsPackage.<<InitializeAsync>b__2_0>d.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at RedGate.Versioning.Client.VsShell.Utilities.Threading.TaskRunner.<>c__DisplayClass13_0.<<FileAndForget>b__0>d.MoveNext() Thanks, Sean / comments
  1. Community
  2. SQL Change Automation
  3. Issues since converting to SQL Change Automation from ReadyRoll
Hi Ben,Thank you for your response.  Yes I recall reading that was the case, but for some reason on my machine I got a license expired message and was unable to continue using ReadyRoll in my Visua...
0 votes
Issues since converting to SQL Change Automation from ReadyRoll
  1. Community
  2. SQL Change Automation
Hello,I needed to use ReadyRoll yesterday, and found that I had to update to SQL Change Automation to get it to work.  We are running Visual Studio 2015.I ran the update and rebooted my machine.  U...
3 followers 6 comments 0 votes
Total activity
10
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3