SteinerA's Q&A profile

• SQL Server Deleting, Updating and Inserting---is it LOCKING the table?

  I have created a single Data Flow Task that reads a set of records from a source table and then makes determinations whether to insert, update or delete from a destination table. The data is basically being copied from one database to another with a small amount of data manipulation and lookups. The problem seems to be that when running the task, even a small amount of records read from the source table seem to take a long time for the task to finish. I feed the records into a Script Component (the brains) that sorts the records to three separate outputs. I use OLE DB Commands to perform the DELETE and UPDATE and an OLE DB Destination for INSERT. I thought that by using three separate database connections would help, but it just appears to ...Show All

• Visual C++ release build problem

  Hi ppl Whenever I build release version it is shows some errors wherease same source code in debug version does not cause any problem. What can be the problem What type of Error you are getting .Linking Error or Something Else. Did u try to Find out in MSDN Why you are getting error in Such Condition. And this type of a short note is not enough to resolve the error. so Provide More info about your Error. Thanx ...Show All

• Software Development for Windows Vista TPM Management MMC Fails with WMI Error 0x8029010C

  Hi All, I’m doing some tests with Vista’s new BitLocker feature and having some TPM issues. When working on the Feb. CTP build, I can create Encrypted Volumes fine using a USB flash drive for the recovery/start up key, but I can’t seem to get the TPM MMC Snap-in to initialize. Each time I start the TPM MMC Snap-in I receive a TPM Management WMI Error 0x8029010C. Anyone have an idea on this one I’m using a Gateway M280 and they swear it supports TPM 1.2 as required by Vista. On all my non-1.2 compliant systems the TPM MMC Snap-in states that the system is non-compliant. Along these lines It sure would be nice to have a TPM simulator. Anyone know of one It would also be helpful to know if anyone has been s ...Show All

• .NET Development Errors after successful install of .net framework 3.0

  I am a consumer, not a programmer.    On 1/29/2007 I went to Microsoft Update and got two items from the software(optional) pane, they were as listed below.  After I got the updates the computer did not ask me to reboot as it had advised me I might have to before the update.  So after the successful download and install of these items and waiting a good while after the Microsoft Update website said success and I had closed it, I rebooted the computer using the start menu restart.  After the restart the computer would not access the internet whatsoever, even though my ISP said I had a valid IP number and my IP phone from Comcast was working fine.  I called McAfee because their software was not able to run and t ...Show All

• Visual Basic textbox to textbox #2

    i am working with one form, i want the text inputed by a user from one textbox to be displayed in another read-only textbox here is the code: i would like to have the readonly textbox display the current input textbox text and the previous readonlytextbox text   so i would imagine it would be something like readonlytextbox.text = inputtextbox.text + readonlytextbox.text thanks for your time       Private Sub inputTextBox_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles inputTextBox.TextChanged     readonlyTextBox.Text = inputTextBox.Text End Sub ...Show All

• Windows Networking Development Weird one - Router Death by Vista

  Here's a weird one. It seems that Vista RC2 is routinely killing my ADSL router I have a dual boot system (patched up XP Pro vs Vista RC2). Vista seems to be killing my D-Link DSL-500 like...., several times a day while Vista is running. Has anyone else noticed this I'm thinking.... some sort of weird network plug and play thing (which is disabled - by the way) RickW I have been having problems with my DLink DI-624 rev C. Whenever Vista is booted I cannot connect to the wireless side from my XP tablet. It works fine when Vista is shut down, or I'm running XP. I tried turning off UPnP in the router, and then the router just keeps rebooting. ...Show All

• Visual Studio row_set error when i create report with two views linked using primary key

  I am creating asp .net report using crystal. report has two views linked by common key. when i run the report it give error unable to generate row_set. If i remove the links and add match condition in record filtering it works fine but takes a lot of time. Is there article or document on how to use cr in above situation. ...Show All

• SQL Server Set results destination with script?

  In SQL Server Management Studio, can you set the destination of results (e.g. Results to Grid) with SQL script, or do you have to use the toolbar Thanks Chris I assume you mean "can tell the server to get the results in either a grid, file or finally text using t-sql" No. You have to use the toolbar, obviously thats not neccessarily true for text. You could get output to text using code. Is this what you require Barry ...Show All

• Audio and Video Development Adv. Cont. Playback on HD-A1 >> NO RENDERING

  Hi All, I am having trouble getting an advanced content application to play once burned on a DVD-R and inserted into the Toshiba HD-A1 HD DVD player. Video and audio play fine using this method, but once the advanced content object is reached the player stops playback and gives an error. Does anyone have any advice on this We have tried the samples posted here and we get the same results. Thanks. Have you run your project through the new HDDVD Validator that ships with the Jumpstart package Do you actually have a PrimaryAudioVideoClip that points to a valid multiplexed EVOB file containing a compliant bitstreatm, etc. Note that the spec requires you to have video, even though iHDSim does not. ...Show All

• Smart Device Development Maintaining C# Code

  I am working on a C# project for the Compact Framework. I have noticed that debugging for the compact framework can be a pain (can't change code durring run time, takes a long time for the code to start using the emulator or a handheld device, etc). I have also noticed that most of the code files (class.cs) can be used in a normal C# desktop application. I would like to be able to create a desktop application that utilizes the code that I created for the Mobile Application, and still have my Mobile Application, and have them share the same code files. That way, changes in one project would change the files in the other project, and I can quickly code in the desktop application, and check for any problems in the Mobile application. Has a ...Show All

• SQL Server dataset with parameterized top query

  I have a report based on a dataset that has a "top()" statement in it. SELECT TOP (10) name, val FROM tab ORDER BY val DESC I wanted wanted to return a report with 10 rows as the default. But allow the user to change the default and regenerate the report with more rows. I tried the following; SELECT TOP (@N) name, val FROM tab ORDER BY val DESC Normally in VS2005, the paraemeters work fine for things like the WHERE clause. But when i do the TOP(@N) the query/report parameter synchronization messes up. If i manual go to the parameter tab of the dataset and configure the matching between query and report params it works. But doing anything to the dataset resets this. Its getting very tiring. Any advice for a ...Show All

• Smart Device Development SQL mobile 2005

  Hi There, I'm currently writing an application for a windows mobile 5 device which will store data in sql mobile 2005. I would like to know which would be the most efficient way of writing the following example to work with the above. (up until now all the code i have written has been in vb6 and connecting to an access database) Set db = DBEngine.OpenDatabase("location\database.mdb") ' strSQL = "SELECT * FROM Floats WHERE AgentName = '" & lblAgentName.Caption & "' AND Status = 0 " ' Set rs3 = db.OpenRecordset(strSQL) If rs3.RecordCount > 0 Then rs3.MoveLast lngRecordCount3 = rs3.RecordCount rs3.MoveFirst Else lngRecordCount3 = 0 End If ' If lngRecordCoun ...Show All

• Visual C# principal.IsInRole working locally but not remotely?

  Hi all, I have a function I wrote which grabs a list of security groups from a sql table and then combines that with the domain name to check the users security groups to decide what they have specific access too. The function works 100% perfect when I run it against a localhost database, the second I point it to a remote database with same data and same structure it dies returns all groups failed and I can't for the life of me figure out why. Thanks in advance for any help anyone can give :) <code> // AD Groups the user belongs too public Stack retGroups = new Stack(); #region Get security groups private void getSecGroups() { SqlConnection getGroups = new SqlConnection(connect); // Select distinct from the databa ...Show All

• SQL Server How to include a Express 2005 database in a setup

  How can i include a express 2005 database in a setup My program is a single user program, and i want express 2005 and the database to be installed on the users computer, when they install my program. I am using Vb.net Visual Studio 2005, and i am using the 'Setup and deployment' template to create the setup. Kindly Peer First you need to create an installer class in your main project. This will inherit from the Installer class which exposes four methods: Install, Uninstall, Commit and rollback. These methods are where you can put your code to create or attach databases. You then select your deployment project and in the solution window there is a toolbar. The second from the right icon brings up the cu ...Show All

• Windows Forms Flicker Cursor with DoubleBufffered

  Hi! I'm painting with Graphics object to form. Everything I'm painting in Form_Paint method. To reduce flicker of painted picture I'm using DoubleBuffer. Now painted picture is not flickering. However mouse cursor starts to flicker. I want to repaint form every e.g. 500ms, so I tried call form.Refresh(), form.Invalidate(), I tried to invalidate even only some parts of form, but cursor is still flickering. Today I tried to use not regular mouse cursor (default arrow) but Cross or IBeam cursor (which consists only from "lines" and not consists from some "area") and these cursors aren't flickering. Can somebody advise me how to use DoubleBuffer with no frickering default cursor Thanks a lot... Mike. ...Show All