Kevin Dente's Q&A profile

• SQL Server Transactions and Create Table statements

  I have some problems getting my SSIS package to run in a transaction, I wonder if anyone can assist. What I want to do is run one package, which consists of a - 1) create staging table SQL statement - 2) read (all) from Access MDB to staging - 3) copy (only new) from staging table to real table - 4) drop the staging table I changed the package to "require" a transactions, and left all containers in it to "supported" (default, I think). I left all the transaction type to default "serializeable". The package does not work, since the table I created on step one is not "seen" when step 2 wants to insert into it. If I set the package transaction back to "supported" (default) ...Show All

• Visual Studio 2008 (Pre-release) WCF X.509 CAs?

  Can anyone point me to CA's of certificates suitable for WCF encryption and what do I ask for I understand that the standard SSL certs do not work and the sales reps are not knowledgeable about WCF requirements. Thanks John Thanks for the replies. I am testing with a MakeCert generated cert but will want to go live soon with a cert chained to a trusted CA as I want to use WCF services with a clickonce deployed web app. I have an SSL cert but several blogs talking about certs say that standard SSL certs do not work for WCF. John ...Show All

• SQL Server execute sql task resultset

  hi all, in my execute sql task, i have a try catch statement to catch error code if there's an error... begin try insert into person.contact (contactid) values ('1') end try begin catch select @@error as ErrorCode end catch this ErrorCode will be mapped to a user variable. my problem is the value for ResultSet. in order to assign ErrorCode to the variable, i have to set the ResultSet value to Single row, but if this task does not fail, i need to set ResultSet value to None in order for it to run successfully. How do i go about solving this problem Please help. thanks! hi Phil, thanks for your reply. but what resultset value should i set None or single row there'll still be ...Show All

• Visual Studio 2008 (Pre-release) how to use Claim.CreateRoleClaim for a role with clientCredentialType=windows

  Hi, I'm using wshttpbinding with message clientcredentialType of windows. When I decorate my operation with: [ PrincipalPermission ( SecurityAction .Demand, Role = @"domain\role" )] this works. (although changes in active directory are only picked up after a reboot of my machine ). Now I'm building a more flexible system, which will look at the claims provided and will compare it to a claim of my own (like in com-430): Claim requiredClaim = Claim .CreateRoleClaim( "domain\role" ); However, when using a comparer like this: ClaimComparer comp = ClaimComparer .GetDefaultComparer( requiredClaim.ClaimType); in an iteration of the claims, it will not be found. The claimset provided is mostl ...Show All

• Visual C++ Getting overriding inherited functions to work

  I am trying to override a function from a base class, but cannot get my program to use the derived class' fuction at runtime. To test it out, I wrote this: class ClassA { public : ClassA( void ); public : void talk() { cout << "CLASSA" ; } }; class ClassB : public ClassA { public : ClassB( void ); void talk() { cout << "CLASSB" ; } }; int main () { ClassA *B = &ClassB(); (*B).talk(); int i; cin >> i; } To my understanding, (*B).talk(); should result in ClassB's function being called, but when I run the program ClassA's is called. What am I doing wrong Maybe the 3rd tim ...Show All

• Windows Forms Datagridview dynamically added cell contents removed after sorting

  Hi all, I just started a very simple tool which should create some resource files for me. For the moment it is just a form with a datagridview and only this code: private void Form1_Load(object sender, EventArgs e) { DataSet bitmapSet = new DataSet(); bitmapSet.ReadXml("bitmaps.xml"); dataGridView.DataSource = bitmapSet; dataGridView.DataMember = "bitmap"; DataGridViewImageColumn bitmapColumn = new DataGridViewImageColumn(); bitmapColumn.Name = "bitmapColumn"; bitmapColumn.HeaderText = "Bitmap"; dataGridView.Columns.Add(bitmapColumn); dataGridView.Columns.Add("widthColumn", "Width"); dataGridView.Columns.Add("heightColumn", "Height"); for (int i = 0; i &l ...Show All

• SQL Server Parameterized MDX Query Performance Issue in SSRS

  Hi, I'm having issues with a reasonably complex MDX query used in a Reporting Services report. I have executed the query and traced activity on the SSAS box and have discovered that there is a major difference in performance between the parameterized query and the exact same one but with 'hard coded' values. The difference we are talking about is from a couple of seconds (hard coded) to minutes when parameterized!! The key difference is that the parameterized query is causing litterally hundreds of thousands of Query Dimension events (EventSubClass : 1 - Cache Data) to occur against one of the dimensions (the Date dimension to be exact). This dimension is not even large with only a few hundred leaf level members and about five levels ...Show All

• Windows Forms tableadapter query wizard to create a stored procedure

  Hi, i used the tableadapter query wizard to create a stored procedure that returns records. the schema is different and using the sp returns an error. so i modified the code to give this.: bad coding but until i find the solution.. i'm having to clear the constraint twice. the first time only works on the second try. can someone enlighten me on how to not even reach this error and my sp should work fine. Me .CostingDataSet.Costing_Bill.Constraints.Clear() Try Me .Costing_BillTableAdapter.FillBy1( Me .CostingDataSet.Costing_Bill, name, pono) Catch r As ConstraintException Me .CostingDataSet.Costing_Bill.Constraints.Clear() Me .Costing_BillTableAdapter.FillBy1( Me .CostingDataSet.Costing_Bill, name, pono) End ...Show All

• Visual Basic Running a batch file

  Is there a special way of running a batch file I have tried process.start but it is not working. The batch file works when I double click it but not when I try to run it through my program. Thank you, Troy L The following will work without any clicking at all and will start xyz.bat with no arguments. Process.start("xyz.bat","") If your requiring a double click - then its probably something in your code or the bat file as process.start should not require any user involvement. ...Show All

• Software Development for Windows Vista How to start process in session before user logs on?

  I have a need to start a process in a session before the user logons on. On XP I used a Windows Logon Notification Package to do this. When a new session was created, Winlogon.exe in that new session called my WLNP and it was able to start the process before the user logged on. The process is used to support smart card logons for that session. I'm trying to find out how to do something similar on Vista. I know logon notification packages are no longer supported. I know how to write a service to get session creation notification, but I don't know how to start a process in the new session before the user logs on. Is there a function I can use to start a process in another session If so, I could have my session tracking sevice start th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How many swapchains is supported by a single device in D3D 10?

  1)How many swapchains is supported by a single device in D3D 10 2)Is it possible to create more than one swapchain per device in D3D, just like in D3D9 As far as I know it’s only limited be the available memory. To create additional swap chains you will need a DXGIFactory. ...Show All

• Audio and Video Development A question about the media file's title.

  I want to set the title for the windows media player to display just near the trackbar,for example"clip:river"(river is the title).I can only get the title form the URL.For example,"rtsp://127.0.0.1/123_river_movie.asm".The real url is "rtsp://127.0.0.1/123.asm" while the title is "river". So,which function can be used to set the title displayed on windows media player to be "river" Another question .Because the url "rtsp://127.0.0.1/123_river_movie.asm" is not the real url,but "rtsp://127.0.0.1/123.asm" is, I want to input the former in the windows media player url input dialog,and change it to the latter in the source filter. In this way, I can both get th ...Show All

• Visual J# jung for .net

  Hi, Has anyone tried converting jung (java unversal network/graph framework) the source is available in jung.sourceforge.net. I've tried importing all the source code, but have problem with the apache component. This probably lead to further question, have you tried converting apache to J#. Sincerely Anthony Oh well, nevermind. Your answer sounded like, I might have offended you. i was hoping a simple answer yes or no to both questions. or someone might have tried and can tell experience. Anthony ...Show All

• Software Development for Windows Vista Workflow with id "xxxxxxxx" not found in state persistence store ???!!!

    Hi friends: Please Help me !!!  -_-|| I use WWF beta2, StateMachine Workflow When run WWF beta2, I use 2 databases, the name was WorkflowStore and WorkflowTracking, the string below is the connection strings to the 2 databases in web.config <add type="System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService,System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral,PublicKeyToken=31bf3856ad364e35" connectionString=" Data Source=ServerName ;Initial Catalog=WorkflowStore;User ID=sa;Password=MyPass;" LoadIntervalSeconds="2" UnloadOnIdle="true" /> <add type="System.Workflow.Runtime.Tracking.SqlTrackingService, System.Workflow.Runtime, Version=3.0.00000.0, Culture=neutral, PublicKeyToken=31bf3856a ...Show All

• Silverlight (formerly WPF/E) WPF/E SDK Sample Issues on FireFox

  I am using FireFox 2.0 and two of the samples are not working under FireFox. The problem is that is says that it needs a plugin, but obviously since it works for some samples and not others the plugin is installed. The problem samples are Sprawl and SleekVideoPlayer. I've tried using different agHost.js but that does not seem to be the issue. Is this a known issue ...Show All