Michael Dyrnaes's Q&A profile

• SQL Server Using the results of a script component

  Hi There, I have to populate data from two oracle databases. I have a list of ids from one table and I have to query those ids in the second table (in a different database) and populate that data into a sql server. This is the approach I have taken... I have populated the ids into a recordset destination. I use a script component to extract those ids (from an object) into an ouput buffer. I am wondering how I can iterate throu these ids and query the table in the second database for these ids. Can somebody please help me Thanks a lot!! You could use Data Flow task Make DB1 as source Use a Lookup Transform to match IDs from DB2 Mr Thomson has a god article on this: http://blogs.conchango.com/jamiethomson/archive/2006/0 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What tools do I need to write sprite-based games?

  Hi guys. I am intending to try my hand at 2D game programming as a hobby. I have recently downloaded MS Visual C# '05 Express Ed. and MS XNA Game Studio express. Will these two enable me to write complete 2D games for Windows or will I also need the DirectX Development software I will be using Blender to create all sprites and backgrounds, not that that really matter now. I have *some* experience with Python, though I never really went outside console-based apps, save my short venture into the world of TKinter. Thanks in advance for your replies! Your truly, Peter Yes, you can create a full 2D sprite-based game for Windows with the tools you listed off. Visual C# Express + XNA Game Studio Express will pre ...Show All

• Visual Studio #if MSBuild ...

  Hi What #if statement can I use to detect MSBuild in my code I tried MSBUILD, but no luck. Do I have to define one I if, how regards Kjelli I'm using AzMan to control page/code access and are having trouble configuring this on WinXP. On the team build server / test site it's working and would be appropriate to have security applied. Please explain where I should put your statement. I've tried in TFSBuild.proj: <Project DefaultTargets="DesktopBuild" xmlns=" http://schemas.microsoft.com/developer/msbuild/2003 "> <PropertyGroup> <DefineConstants>$(DefineConstants);MSBUILD</DefineConstants> This is without the conditional statement. (Don' ...Show All

• Smart Device Development Connecting emulator to network?

  Hi i wish to connect the Phone emulator to my network. I have downloaded and installed netsvwrap.exe the virtual network piece of software. Under PocketPc configure/network/ Enable NE2000 PCMCIA net adaptor i have it enabled. What else do i have to do Thanks for your time. Im new to PocketPc's gafferuk wrote: Hi i wish to connect the Phone emulator to my network. I have downloaded and installed netsvwrap.exe the virtual network piece of software. Under PocketPc configure/network/ Enable NE2000 PCMCIA net adaptor i have it enabled. What else do i have to do Thanks for your time. Im new to PocketPc's i'm supousing your are using Visual Studio but are you using Vis ...Show All

• Visual C# VB to VC# translation

  the code in VB AddHandler wb.DocumentCompleted, AddressOf WebBrowser1_DocumentCompleted what's the equivalent in VC# (via Instant C#) wb.DocumentCompleted += new System.EventHandler(WebBrowser1_DocumentCompleted); David Anton www.tangiblesoftwaresolutions.com Instant C#: VB to C# converter Instant VB: C# to VB converter Instant C++: C# to C++ converter, VB to C++ converter Instant Python: VB to Python converter ...Show All

• .NET Development Issue About Registry Entry Through Setup

  Hello All Actually I have made a setup project that has to make the entry in registry.The specified dll will be in the %Systemdrive%Program Files folder at the client machine from where the setup will run. I have make this registry entry value type as Reg_EXPAND_SZ and its path as %Systemdrive%Program Files but when this setup runs it makes the entry as %Systemdrive%Program Files, I wonder why setup don't replaces the SystemDrive with (c:/,d:/) while it runs. I want the entry with the C:/ProgramFIles ....and I wanted that setup to detect the systemdrive at the Target Machine and then replace the variable "systemdrive" with actual drive and then make the entry in the registry. your help in this ...Show All

• Visual Studio Express Editions How to find a row in dataset with more than one column value in keyobj?

  I am not getting any row with this Function getPaternByKeys(ByVal codeValue As String) As String ' actually column can be identified either by number or its name Const MyCodeTblkey As String = "codeTableName = \'DataPatrn \'", myValueColumn As String = "value" Const myCodeName As String = "code = " Dim keyobj() As Object = {MyCodeTblkey, myCodeName & "\'" & codeValue.PadRight(14 - codeValue.Length) & "\'"} Dim dr As DataRow = Nothing Try dr = Me.IeStringTmpDataSet.CodeTable.Rows.Find(keyobj) 'or even you can get array of rows if you want to if its not unique value ' Dim dr() As DataRow = IeStringTmpDataSet.CodeTable.Rows.Find("c ...Show All

• SQL Server sql data source error

  when going through the data source configuration wizard i am having a problem. when the wizard asks "which database object do u want in your database i get this error An error occurred while retrieving the information from the databse: Failed to retrieve data for this request. Could not continue scan with NOLOCK due to data movement Can someone help me with this error im doing this throught he tutorials that came with the express Edition download and i am stuck at this point. i have done some vb6 and want to refresh my self with the diffrences in express The error is raised if your underlying data is changed during the execution of nolock query. This is the drawback for using nolock (i.e. ...Show All

• Software Development for Windows Vista InfoCard and CardSpace Self Issued STS

  Hi, I would like to know how can my service communicates with the built-in Self Issued STS service when using CardSpace: do I still need to provide my WCF service with a certificate or can it work without Thanks, Amadrias Relying Party should identify itself and support secure communication otherwise client has no reasons to give away his identity. However, theoretically, client app can take the whole responsibility, itself request a security token and send it wherever it wants. In this case client app is actually a RP itself. But anyway I'm sure that Windows CardSpace card selector and its built-in STS will not issue a token without identifying the RP. ...Show All

• Visual Basic Special type of ListBox?

  I need a multi-columed list box where the entire row is one item though, kind of like the listbox that the IDE uses for build error listing. Is their such a control, or property for the listbox control I don't see either of those properties, i am in alphabetic listing but all i see that starts with V is: * ValueMember * Visible and for F all I see is: * Font * ForeColor * FormatString * FormattingEnabled no View and no FullRowSelect. ...Show All

• .NET Development Access database.

  Hi! How do i access an MS Access database from .net /Jimmy What connectionString should be used for MS Access I allways get an error telling that the Provider keyword is wrong /Jimmy ...Show All

• Internet Explorer Development Installing MS patches through IE

  As far as I can figure out, this might be some kind of IE-associated bug. I have created a patch for my product, lets say it's Patch.msp We redistribute the patch through our website, and have a tool that automatically creates a zip pack. The overall zip pack includes: Patch.msp Readme.htm files. The zip pack creation has an option to include a button in the readme file that autolaunches Patch.msp, this is accomplished through inserting <form action='Patch.msp' method='POST'><input type='submit's value='Install Now' align='MIDDLE'></form> code in the readme file. When I attempt to perform the installation through readme by clicking on the "Install Now" button, MSP installation will fail. Error we get is 2324, co ...Show All

• SQL Server Problem with PreComputed Partitions and numeric partition key (HOST_NAME())

  BOL says the following (headed with important): "The HOST_NAME () function returns an nchar value, so you must use CONVERT if the column in the filter clause is of a numeric data type, as it is in the example above. For performance reasons, we recommended that you not apply functions to column names in parameterized row filter clauses, such as CONVERT(nchar,EmployeeID) = HOST_NAME () . Instead, we recommend using the approach shown in the example: EmployeeID = CONVERT(int, HOST_NAME ()) . This clause can be used for the @subset_filterclause parameter of sp_addmergearticle (Transact-SQL), but it typically cannot be used in the New Publication Wizard (the wizard executes the filter clause to validate it, which fails because the compu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using Pixel Shader 3.0

  For another project I need to use pixel shader 3.0. When I attempted to get the effect to work in pixel shader 3.0 I noticed that pixel shader 3.0 was not working anywhere. So I even tried using the code from How to: Create Custom Texture Effects. The HLSL code is written to compile it for pixel shader 2.0. When I changed it to pixel shader 3.0 it failed. It gave an InvalidOperationException on the graphics.GraphicsDevice.DrawIndexedPrimitives(PrimitiveType.TriangleList, 0, 0, cubeVertices.Length, 0, 12 );. When I switch back to pixel shader 2.0 the program works just fine. I added code to test which version of pixel shader I have, and I do have pixel shader 3.0 (my video card is 7900gt so it should ...Show All

• Visual Studio Express Editions LINK : fatal error LNK1104: cannot open file 'user32.lib'.

  Hello,   I've tried everything to get ANY program to work and they won't. Not even "Hello World" or code copied directly from help.   Always the same:   LINK : fatal error LNK1104: cannot open file 'user32.lib'.   I've read all the suggestions here, followed all the directions including from the websites:     1. Uninstall beta versions   Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0 (this includes Tech Preview, Beta, or CTP versions).   2. Download and install Visual C++ 2005 Express Edition!!   3. Register   4. ...Show All