Greg J. Brown's Q&A profile

• SQL Server Model for Report Builder

  I made a model for report builder and I am limited to selecting from 2 tables I have one main table table1 with a PK to FK with table2 - table12. I am limited to only going 2 levels deep is this right How can I correct this or work around it. I tried building a view, but have never had to do so with so many joins it this possible or do I have to break things up I'm not aware of any existing issues like this. Here's a few things you could double check: - The entities in the model that correspond to the "other" tables all have IsLookup=false and Hidden=false - The roles in the model from the main entity to the "other" entities all have Cardinality=OptionalMany - I assume you are ...Show All

• Visual Studio Team System ServerMap.xml issue?

  Here's my ServerMap.xml file: <ArrayOfEntry xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd=" http://www.w3.org/2001/XMLSchema "> <Entry> <Key xsi:type="xsd:string">http://tfsvr1.foo.com:8080/Services/v1.0/Registration.asmx</Key> <Value xsi:type="xsd:string">137027A7-AF9D-4C57-BBEA-ADA7970899E7</Value> </Entry> <Entry> <Key xsi:type="xsd:string">http://tfs-testing.foo.com:8080/Services/v1.0/Registration.asmx</Key> <Value xsi:type="xsd:string">137027A7-AF9D-4C57-BBEA-ADA7970899E7</Value> </Entry> <Entry> <Key xsi:type="xsd:string">http://tfs01.foo. ...Show All

• Visual Studio Team System How to handle large numbers of projects and binary references

  Currently we are in the midsts of moving from VS 2003 and VSS to VS 2005 and Team Foundation Server. Although we are a small development team of 4 developers, we manage and code over 200 projects which we currently have broken down into approximately 30 solutions. Right now our VSS has the following structure: $/ $/Company $/Company/Folder $Company/Folder/Solution1 $Company/Folder/Solution1/bin $Company/Folder/Solution1/scripts $Company/Folder/Solution1/Project1 $Company/Folder/Solution1/Project2 ... $Company/Folder/Solution1/ProjectN $Company/Folder/Solution1/refs $Company/Folder/Solution2 $Company/Folder/Solution2/bin $Company/Folder/Solution2/scripts $Company/Folder/Solution2/Project1 $Company/Folder/Solution2/Project2 etc... The ...Show All

• .NET Development C# equiv of isdate?

  Hi, How do i check if a string contains a valid date Ex, i have a string ="jan 6 15:15", I want to set the year to 2006, but only if it's not already a valid date as is the case. so, the resulting string should be "jan 6 2006 15:15". but if the string already has a valid date, ex "jan 7 2005", I don't want to touch it. I try to use the datetime.parse inside a try/catch, but i couldn't get it to fail. It keeps setting the date to now(). Has anyone done this before public static bool IsDate(Object obj) { string strDate = obj.ToString(); try { DateTime dt = DateTime.Parse(strDate); if(dt != DateTime.MinValue && dt != DateTime.MaxValue) ...Show All

• SQL Server "Login timeout expired" prevents package deployment

  I'm trying to deploy an SSIS package to a server ("SQL Server" deployment). The package does have an encrypted password, which has both worked nicely and not in the past. It's entirely possible that our other "DBA" has busted something on the server, thus preventing my access to it, but I'm curious if anyone has any experience w/ error code 0x80004005 (Login timeout expired) in the SaveToSqlServer method. Is that just the generic you-can't-log-in message, or is it really trying to imply that the SQL Server is not responding to login attempts Thanks for any help, Ben =================================== Could not save the package "C:\Documents and Settings\foo\bar\bin\Deployment\foo.dtsx" to SQL Ser ...Show All

• Visual Studio Need help opening crystal report based off 2 tables in dataset

  I have a form with a dataset that contains account records in one table and another table that contains transactions for accounts that are in the other table. I'm trying to create a report based on the two tables using an inner join. I used the report wizard to create my report and when I open it it just sits there not populating like it is hanging. The dataset maybe has about 4500 records in one table and the transaction file has 35K records. here is the code I'm using to open the report viewer and load the report. Any help would be great! Private Sub Form3_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load reportDocument1.Load(Application.StartupPath & "\CrystalReport2.rpt ...Show All

• Smart Device Development Disable Camera Function

  Hi all I am new to development in PPC (WM5 and WM2003). I got a project that require to disable the function of the camera and only activate when the password is key in. Anyone can advice Thank. espana wrote: Hi all I am new to development in PPC (WM5 and WM2003). I got a project that require to disable the function of the camera and only activate when the password is key in. Anyone can advice Thank. this might be a bit of a hack, but try moving the camera software (often "camera.exe") out of the folder it usually lives in, and only move it back when the password has been entered. I don't know of any fashion (in managed code at least) by which you can explicitly restrict a hardware/software resource on ...Show All

• Software Development for Windows Vista transactions with C# and class library

  Im dealing with a class library which contain several of the methods Id like to wrap in a single transaction. Each of these methods in turn, call stored procedures. How can I wrap a single transaction around calls like so: BusinessObject1 biz1 = new BusinessObject1(); BusinessObject2 biz2 = new BusinessObject2(); BusinessObject3 biz3 = new BusinessObject3(); Then using them, biz1.updateSale(someguid) biz2.insertUserInfo(sometext) biz3.addNote(someguid) How can I wrap the above three calls into a single transaction Ideally, your code will look something like the following: using ( TransactionScope scope = new TransactionScope ()) { biz1.updateSale(someguid); biz2.insertUserInfo(somete ...Show All

• Visual Basic Run a macro with .Net

  Hello! I just wonder how can I run a macro with .Net I have an excel workbook and I need to open a workbook, run a macro, close the workbook... My code actually opens the workbook and runs the macro, but the instance-thread doesn't stop running... If I execute the code three times so I'd have 3 instance of EXCEL.EXE running I really need a solution .... I w onder these post could help! Thanks a lot. ---------------------------------- The code: Private Sub runMacro() Dim oExcel As Excel.ApplicationClass Dim oBook As Excel.WorkbookClass Dim oBooks As Excel.Workbooks Dim fileName As Object = "c:\MYFILE.xls" Dim updateLinks As Object = 1 Dim macroName As ...Show All

• Microsoft ISV Community Center Forums Refer to Mail Merge Fields from Embedded Excel Chart

  Hi, I'm trying to make a chart of a table of mailmerged data. As far as I can see MSGrpah 2.0 does not support changing the data source so I assume I must use an embedded MSExcel chart. How do I refer to MAilMerge fields from this chart I also need to make sure the chart updates as the user changes mail merge record. ...Show All

• Audio and Video Development DXVA 2.0 Video Decoding [Typo] //dxva2api.h in MicrosoftR WindowsR Software Development Kit for RC1

  // compressed buffer types. enum { DXVA2_PictureParametersBufferType = 0, DXVA2_MacroBlockControlBufferType = 1, DXVA2_ResidualDifferenceBufferType = 2, DXVA2_DeblockingControlBufferType = 3, DXVA2_InverseQuantizationMatrixBufferType = 4, DXVA2_SliceControlBufferType = 5, DXVA2_BitStreamDateBufferType = 6, DXVA2_MotionVectorBuffer = 7, DXVA2_FilmGrainBuffer = 8 }; I assume there is a typo in the names, the following is probably a better match DXVA2_MotionVectorBuffer Type = 7, DXVA2_FilmGrainBuffer Type ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Extending the content pipeline for model loading...

  Hi, I'm sorry if this has been answered before, I've searched a bit and not really found anything too helpful. My basic question is how do you go about extending the model loading pipeline I found this example in the help files but it did not want to compile: [ContentProcessor] class ScalingModelProcessor : ModelProcessor { public override ModelContent Process( NodeContent input, ContentProcessorContext context) { MeshHelper.TransformScene(input, Matrix.CreateScale(10.0f)); return base.Process(input, context); } } I put this in the spacewar starter game, and got some errors like so: Error 2 The type or namespace name 'ModelProcessor' could not be found (are you missing a using directive or an assembly refer ...Show All

• SQL Server Registering AdventureWorks

  The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:\ProgramFiles\Microsoft SQL Server\90\Tools\Samples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection P ...Show All

• SQL Server Just Installed SQL 2005, no servers showing up in SQL Server configuration manager. Plz help!

  I have just installed SQL 2005 enterprise and every apeared to install ok. But using SQL config manager nothing is showing up under SQL 2005 Services tab. Anyone got any ideas Can you look into Summary.txt file under C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG Machine : <Your Machine Name Here> Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Successful While setup did you see if Database Services was getting installed Please paste whole content on Summary.txt in next post. ...Show All

• Visual Basic PLEASE HELP - Executable properties - right click

  When I browse to a file in a directory in Windows and RIGHT CLICK ON My executable, on the version tab of an executable's properties, how do you set the following fields PLEASE EXPLAIN HOW TO DO THIS IN THE DEVELOPMENT ENVIRONMENT IN DETAIL. I'M TRYING TO SHIP A PRODUCT. THANKS IN ADVANCE Description copyright comments company Legal Trademarks Product name Product Version ------------------------------ on the summary tab, title subject author most of these are configured in the Assembly.cs file. Or perhaps in VS2005, right click the project and go to properties then click on the application tab and select "Assembly Information" and fill out the details there ...Show All