Motzl's Q&A profile

• SQL Server Combining tables

  Here's an issue I am having, I am currently getting data from a customer table, sales table, and a definitions table, it has 2 inner joins, It creates a temporary output table. Now, this table only includes data from the customers that actually had sales. I need a way to select into that temp table all the customers that are not currently in that table. Is there a way to do this Any help would be greatly appreciated. Jim Hi, therefore better use a LEFT JOIN which will be also applied to those customers which don’t have any entries in the joined tables. But this is just a common approach which *could* fit to your needs. Before givin ...Show All

• .NET Development Access Database and x64 OleDB Connect

  Hi, i've written a programm wich access an .mdb Database with OLE-DB. Under Win x32 everything works fine Under x64 no Database is found. Is there no way to access an mdb Database from x64 There is no way to access a .mdb database from 64bit. It has been decided to not port the Microsoft Jet Database engine to 64Bit. Brad Rhodes This message is provided as is.... ...Show All

• Windows Forms How to: part of the form is opaque, and the rest may have a 50% opacity

  Dear All, After I saw a screen shot of Longhorn, I started wondering current .net framework offered feature for us to implement that style of forms. This is true. We have implemented a TranslucentWindow class in VG.net. With this class you can use various VG.net Pictures, which are like windowless controls, but it is not possible to use true windows forms controls in them. However it is still a lot of fun! ...Show All

• SQL Server Using SSMS to Manage SSIS

  (Also posted on the beta newsgroups...) I'm having problems using SSMS on a workstation to manage SSIS on a server.  I cannot connect to SSIS on the server.  The SSIS service and the RPC service are both running on the server, but I get an "RPC server is unavailable" error message. I have CTP 15 running on the workstation but CTP 14 running on the server.  Probably not a great idea, I know.  Anyone know if that is definitely the problem   Or could it be something else Thanks, Dave Fackler I have the same problem. I'm using windows xp and visual studio 2005. When I ask Visual S ...Show All

• .NET Development .NET framework adoption rate?

  We are trying to decide on whether to maintain 1.1 compatibility for our software or use some of the new features in 2.0. Thus we need to know how widely .NET 1.1 has been adopted by end users. If few machines have 1.1 installed we might as well use 2.0 since most users will have to download the redistributable anyway. But if many 2000/XP machines already have .NET 1.1 installed it would make sense to rather stay compatible with 1.1, since our application footprint is small relative to the redistributable. I haven't been able to find good information on the adoption rate of .NET, so I would appreciate any links. It would also be interesting ...Show All

• SQL Server CustomReportItem Question

  Is there any documentation currently outlining how to make use of the CustomReportItem element or class   My thoughts on this are that it might act as a server control for an ASP.NET application.  Is that correct I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report. Lastly, will support for installing custom report items be included i ...Show All

• Visual C# Loading html into an object

  I need a way to convert a full web page I have in a string variable into an object like the IE Dom so I can get values out of cells in the tables on the web page. I am using VS 2005 for Software Testers (VSST). What I am testing is dynamic and I can't get away with direct record and playback. (As if anyone ever can) What I need to do is post information to the web server and then get out of the response some key information that needs to be used to create the next post . To post to the web server the test software uses the WebTestRequest object. To get data out of the response you use an Extraction Rule. The test developer (me) can cr ...Show All

• SQL Server upgrading MSDE with SP4

  Hi, I'm trying to upgrade MSDE with SP4. I used the following in command prompt. setup /upgradesp sqlrun INSTANCENAME= MSDE1 SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD= 12345678 /L*v C:\MSDELog.log i got the message " Please go the control panel to install and configure system components." What does it mean How to upgrade it Thank U! Hi, did you consider this thread here for your problem: http://groups.google.de/group/microsoft.public.sqlserver.msde/browse_frm/thread/4b441544bc86d202 HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Tools for Office Unable to Show/Hide NamedRange object from the ActionPane

  By invoking folloving code from my my Action Pane I'm getting an exception on the line: object h = nr.Hidden;   The whole method's code: private void btn_RangeShowHide_Click( object sender, EventArgs e) { Tools. NamedRange nr = Globals .Sheet6.Controls[ "subj_1" ] as Tools. NamedRange ; if ( null == nr) return ; object h = nr.Hidden; nr.Hidden = true ; }     Am I missing something Exception: Unable to get the Hidden property of the Range class ************** Exception Text ************** System.Runtime.InteropServices.COMException (0x800A03EC): Unable to get the Hidden property of the Range clas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Animation in directX

  I have a bird (drawn in 3dmax, without animation). Wings are separate object. I want to get the wing (in directx) as a vector of points to find the leftmost (rightmost), to use it as a rotation axis for other points. How to do it You will need to define a skeleton (many matrix in a tree format) Then you will assign each vertex to one of those matrix (bone) A simple skeleton for your bird would be one central matrix (body) and one matrix for the left wing and one for the right Wing Since the vertex of each wing will be connected to their respective matrix You will be able to move them separatly I'm sure ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. june sample issues

  it seems that when I run some of the samples a few of the device checks fail, and the program wants to switch over to a software device, if I remove this line of code if (caps.PixelShaderVersion < new Version(1,1)) return false ;   the sample runs but all the meshes have lost there textures, how can I fix this   Smacker wrote: I guess my problem with this is that when ever you make changes like this you lose a base of players with game creating, not everyone is willing to update there graphics card with every addition of new technology. Just a quick comment... it's ...Show All

• Visual Studio 2008 (Pre-release) sugegstions for anonymous types

  As it stands, its not possible to create structs using the anonymous type mechanism. Its also not possible to create immutable anonymous types. Id like to suggest the following syntax: // a mutable anonymous class var a = new { X = 1, Y = 2}; // a mutable anonymous struct var b = new struct { X = 1, Y = 2 }; // an immutable anonymous class var c = new readonly { X = 1; Y = 2}; // an immutable anonymous struct var d = new readonly struct { X = 1; Y = 2}; Hi Damien, Thanks for your suggestion. Anonymous types are kind of annoying from a language designer's perspective, because they seem to constantly "cry for more& ...Show All

• Visual Studio Team System New Group remains invisible by WIT system - round 2

  Hi guys, We add new group to TFS (through Visual Studio Team Explorer). When we are trying to use this group in WI type definition, witimport fails. We already have this problem once. It was resolved then by adding permissions and classifications to group. This time everything looking fine: - project level group was created - members added - group defined correctly in classifications - it is not latency (too much time pass) - TFSServerScheduler is running - there are no errors in event log - it is NOT the first project level group we adding and using in WI Still when trying to import work item type we receive "'[Project]\OurG ...Show All

• SQL Server Database restores using Enterprise Manager

  Good afternoon. I am using MS SQL 2K and was wondering if it is possible to restore multiple back-up files (database and transaction logs) to a database, if you haven't created a back-up set, using Enterprise Manager. I know that you can write T-SQL to first restore the back-up file and each of the transaction log files, except the last one, with the option of norecovery, and then the last transaction log file, with recovery. Any help would be greatly appreciated. Thank you. Chris That the way, restoring the database files one by one. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Find Text Validation Rule - passes on hidden text

  I've created a web test using the Find Text Validation rule. Unexpectedly, the validation "passed" on text that was hidden in the meta data and not displayed on the web page. Is this the way it was designed to work or is this a defect that needs to be reported to Microsoft If this is the way it was designed to work - shouldn't there be some indicator as to what level you are using the Find Text command (i.e. on hidden text, displayed text , or for both ) Note: this has also been posted in the VSTS General section The build-in FindText validation rule searches the whole response body f ...Show All