Skurcey2's Q&A profile

• SQL Server Catching errors in SSIS Backup Database Task

  Hi, In my SSIS package, I have a backup database task. When I run the package with DestinationAutoFolderPath set to a folder ("Network Service" account has full permission on this folder) and DestinationCreationType set to Auto, the task works just fine creating a backup with its own name. (similar to database_date<count>). But what I want is in my front-end I am allowing the user to specify the name of the backup file. So I want the task to create the backup file in the name I supply. I set the DestinationCreationType to manual and in the application code added the DestinationManualList with the path from the UI. Now the pacakge runs fine but does not take any backup. There is no errors as well. If I set the Fail ...Show All

• Visual Basic if statements using an empty variable?

  curious how to do an if statement like the following : dim variable as string if variable = null then do something else do something else end if the variable will be populated by a combobox and if nothing is selected in that combo box it remains as nothing just an empty variable and I want to be able to execute certian code if a variable is selected and execute different code if nothing is selected. Anyways how would I go about this, am I on the right track with my if statement no thats awsome, I probably owuld have figured it out if I hadn't already been staring at code for the last 8 hours, I think my brain is starting to shutdown so thank you very much that solved my problem perfectly ...Show All

• SQL Server Dynamic Dimension Security using something else than ROLES

  We are incorporating some OLAP cubes into our secure website and what to restrict the cubes information base on the person or client logged in. We are using Dundas OLAP as the front end for displaying the cubes. The Roles approach is not a viable solution since it is impossible for us to gather and keep track of our client’s windows usernames.   Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members > Is there a way to somehow pass a value through the control or the connection string and later use this value to filter dimension members Yes, there is a connection string property called ...Show All

• Visual Studio 2008 (Pre-release) Back to back video playback: problems + inconsistent behavior

  Hi, I'm trying to play video clips, back to back, inside a canvas. My first approach was to hold two mediaelements in the canvas, and switch their visibility, loading the data in each element while the other was playing. This turned out to be unusable, as for some strange reason, the second element would consistently drop a lot of frames. I got this behavior even when the project was reduced to the bare minimum. If anyone has any idea why this is so, please don't hesitate to share the knowledge (using June CTP). I then tried to switch from direct MediaElement manipulation (Source, Play, Stop etc.), to the mediatimeline/mediaclock approach. This turned out to be very tricky, but after a lot of voodoo work (e.g, explicitly assigning null to ...Show All

• Visual Studio Express Editions I can't install!

  This is the error: Error 32003.File 'C:\Program Files\Microsoft Visual Studio 8\Common 7\Tools\vsvars32.bat' could not be opened for write. It won't install! Can anyone help Moved to the install forum. Are you running as administrator The error is common when not having enough permissions. Be sure to be logged in as administrator or a user that have permissions to complete the installation. ...Show All

• SQL Server Using Report Builder from the internet

  Hi When i click on report builder I am getting the remote server returned an error: (401) Unauthorized. It works locally What kind of permissions i need I am using Windows authentication Thanks Ruvy When providing access to Report Builder over the internet, you need to allow Anonymous access to the Report Builder virtual folder in order for ClickOnce to successfully download the application. It can only provide the user's default credentials on the client (it can't prompt for other credentials), and those don't work when connecting to an untrusted domain. Hope this helps! ...Show All

• Visual Basic Selected Value in ComboBox Populates DataGridView

  'I need assistance on how to Load the GridView By selecting a value in the ComboBox '1. ComboBox is loaded with Satellite SCC #s' From SQL Server 2005 Express '2. The DatGridView is loaded with signals that correspond to the Transponders on the Satellite From SQL Server Express 2005 'The GridView also contains the Satellite SCC #s'. '3. I need the GridView to only load the Signal that Matches the Satellite SCC #s' that are Selected from the ComboBox. '4. So when you click the SCC # in the ComboBox, it will search the Signal Database Table for all the matching 'Satellite SCC #s' and then load the signal information into the GridView. DataBase: SQL Server 2005 express Language: VB.NET 2005 FrameWork: .NET 2.0 Imports System ...Show All

• Windows Forms Windows Form Designer Fails to Load

  I'm attempting to design a form but the Windows Form Designer Package in Visual C++ express does not load. I received the following message: The Windows Forms Designer Package ({7494682B-37A0-11D2-A273-00C04F8EF4FF}) did not load because of previous errors. For assistance, contact the package vendor. To attempt to load this package again, type 'VCExpress /resetskippkgs' at the command prompt. Did I install Visual C++ correctly ...Show All

• Visual Basic Making a bubble sort prog hlp

  Hi i was just wondering if some could list the steps on how to make a bubble sort program etc i have 4 text boxs each with a differnt number in and i need to sort the numbers into the order 1 2 3 4 from lets say 3 2 4 1 any ones hlp would hlp a lot thxs Hello can some one please write a step to step guide on how to write a program that can sort numbers into ther corect order say 1 3 4 2 5 6 to 1 2 3 4 5 6 ...Show All

• SQL Server where do I find Sql Reproting services designer 2003 (had to rebuild my computer)

  I had to rebuild my computer with .net 2003, i cant remembrer how I installed reporting services designer Please HELP you have to install the sql reporting services client tools. i believe i just ran the setup as if i were going to install sql reporting services again, and there is an option to install client tools i believe. ...Show All

• Visual Studio Tools for Office Does the Tools for Office edition still have the ability to build and deploy traditional VS applications or .NET websites?

  Wrote an email to a college for advise about which version of Studio to upgrade to from 2003 professional I am asking for an upgrade of Studio for next year. Thinking that the "Visual Studio Tools for Office" might be better for me that the regular "Visual Studio Professional Edition". Main difference is that I only get vb & c++, and no Crystal Reports", but I get "Office Access 2003 Developer Extensions". College wrote: That sounds like a good idea at first, but I'm not sure that you assumptions of the capabilities of the Tools for Office edition on its own is entirely accurate. I am suspicious that you will only have the ability to build MS Office applications with the Tools for Office. I am not cer ...Show All

• Visual Basic Starting an application in runtime. Running IE in a new window.

  I am programming in VB.net 2005. I know I can start an IE browser using code that looks like this: System.Diagnostics.Process.Start( www.anywebsite.com ) But the problem is that if there is already an open browser, my VB program will use it and any information that was previously brought up in that browser will be lost (unless the user clicks on the "Back" button of the browser window). I would like to know how to involke a NEW browser each time the user clicks on a button or makes a selection of some kind. Any ideas Thanks, Al W. DMan - Thank you so much! You are THE MAN !!! I pasted your lines of code directly into a simple "H ...Show All

• SQL Server full uninstall of MSSQL 2005 Ent SP1

  Hi, I am facing a serious problem with the unproper uninstall. I have installed MSSQL 2005 Enterprise and created an Active Directory at the server. I have removed the AD and wanted to uninstall SQL 2005. I was not able to uninstall it fully. I have reinstalled it several times, just to tryying to remove the registry entries. Is there a solution / tool or a document describing, how I can fully manually remove MS SQL 2005 from a server I have already installed SP1. Dejan Hi, after uninstall, I noticed on many places that registry entries have not been removed (several hundred places). I do not have a complete list (too many entries). After uninstall, I try to install MSS ...Show All

• Software Development for Windows Vista Strange error when loading workflow from sql persistence service

  Hello, I'm currenlty developing a workflow within an ASP.NET web application. All steps are working fine (creating the workflow instance and storing it in the SQL persistence service). But when I try to reload my stored workflow instance using the following code: Dim objWorkflowInstance As WorkflowInstance = objWorkflowRuntime.GetWorkflow(guidWorkflowInstanceID) Then I receive the following error: Object of type 'System.Workflow.Activities.ListenActivity' cannot be converted to type 'System.Workflow.ComponentModel.IActivityEventListener`1[System.Workflow.ComponentModel.QueueEventArgs]'. What am I doing wrong My workflow consists of three steps: 1. a CallExternalMethod activity 2. a Listen activity containing a ...Show All

• Visual C++ C++/CLI - SortedList vs get_Item/set_Item

  Hi,   Converting actually applications originally from Managed C++, I couldn't find any C++/CLI equivalent of following statements:            SLst_estime-> set_Item (Descr_Itm, cur_Estm_Itm);               CL_PriceLst^ cur_Estm_Itm = dynamic_cast <CL_PriceLst^>(SLst_estime-> get_Item (Descr_Itm));   SLst_estime is actually a SortedList, "Descr_Itm" being my key value and "cur_Estm_Itm", and object from class "CL_PriceLst".   Any hint of what is now the equivalent of "set_Item" and "get_Item" Couldn't find any infos in my book or MSDN...:( Thanks in advance, Stephane ...Show All