Tryin2Bgood's Q&A profile

• SQL Server App.config?

  Hello All, I am trying to use a custom C# dll from within a script task. The C# dll relies on the Enterprise Library 2.0. Where do I put the enterprise library configuration when I am debugging a package and then when I have the package in production. I cannot find any documentation anywhere on this. Thanks for any help, Justin Hi Jamie, Thanks for the quick reply. Will that apply the config to all packages If so, is there a way to supply a config file for a specific custom dll Also, do I need to put the same config in all 3 of those files Thanks, Justin ...Show All

• SQL Server NEED COMMENTS: Why SQL Server Allow so

  this is not a question i need nice comments on this "Why did SQL Server can have same name of indexes on different tables, but Oracle do not" (i maen SQL Server allow same Index name, for any number of time on different tables, but Oracle dont allow to do so) my personal Opinion is , Oracel is Right.(if so then why SQL Server allow this) what about you Regards, Thanks. Gurpreet S. Gill Why not   Indexes are scoped per table -- so there is no clash by having multiple tables with similarly-named indexes.   It's the same with schemas and table names.  Both Oracle and SQL Server allow you to create tables of the same name that exist in different schem ...Show All

• Visual Basic Word Interop creating Tif's on some machines but not others

  I have written an application which uses MS Word to perform a MailMerge with data entered into a VB form to generate letters to be sent out to people. Some machines are expieirencing issues where a TIF file generated by the Microsoft Office Document Image Writer printer are invalid or corrupted files. I have had our Tech group make sure to apply the SP2 patch to all of the users MS Office. The version of the MODI Writer printer matches mine along with my test boxes. Some documents will be generated find and appear in the image viewer fine but some others do not. I cannot replicate this behavior on any of my machines as all of the documents generate fine and submit to our document storage system without a problem on my development machine a ...Show All

• Visual Studio 2008 (Pre-release) Drilling down to the source of a WCF error

  I'm having trouble finding the source of a WCF exception I get calling a function returning a complex type over a netTcpBinding. Judging from the trace, my problem comes from an array (see bolded part below, near the end of the very long trace). There are indeed array members in classes included in my return type (members of members of the return type to be exact). Now, how do I go about finding which array is wreaking havoc and why Edit : the problem is better defined in my further posts below System.ServiceModel Transfer: 0 : , relatedActivityId=18d927d1-79df-4388-95cf-43cc8ce9cb87 DateTime=2007-01-15T18:16:20.0184792Z Callstack= at System.Environment.get_StackTrace() at System.Diagnostics.TraceEventCache.get_Callstack() at Sy ...Show All

• Visual Basic how to create separate database for every year using SQL 2000 and VB

  how to create separate database for every year using SQL 2000 and VB Its a bit simple........... using the VB code you can find the systems date.... And when the systems date matches to a new year then using the SQL command you can create a table with the required fields.......... ...Show All

• .NET Development Error: 'Must declare the scalar variable "@categoryID".'

  Hello, I'm creating a Data Access Layer in an ASP.NET 2.0 project in Visual Studio 2005 Professional. My database is SQL Server 2005 Developer Edition. After I Added a parameterized method to the Data Access Layer via a SQL SELECT statement (SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE CategoryID = @CategoryID) I get the following error in the TableAdapter Query Configuration Wizard: The wizzard detected the following problems when configuring TableAdapter query "Products": Details: Generated SELECT statement. Deferred prepare could not be completed. Statement(s) could not be prepared. Must de ...Show All

• Visual Studio Team System Build BI Project

  I'm currently developing a BI solution. The solution includes: TFS for Database Professional SQL2005 database project Analysis Services 2005 project Integration Services project Reporting Services project Database and web tests I know that it's not possible to include Database projects in builds yet. I've also seen posts specifying that it's not possible to include Reporting Services either. I'd like to know whether it should be possible to include and deploy IS and AS projects. I've not had any success when attempting this. Is this possible and if so are there any things I should be configuring specifically A post to indicate which types of project it should and shouldn't be possible to build would be very help ...Show All

• Windows Forms CrossPagePostBack

  Please! Need Help! I have two pages as followed 1. Loading.aspx                      (contain a TextBox1 and a Button1.) 2. PrintL.aspx                         (contain a TextBox2) Both pages has the same MasterPage.master When click Button1 on Loading.aspx page, it will PostBackUrl to PrintL.aspx The question is how can I pass a value from TextBox1 to Text Box2 I try using this but it doesn't work (code in PrintL.aspx)   TextBox SourceText = ( TextBox ...Show All

• SQL Server Quick search algorithm in database

  Hi, I need in my app. a good search option in datafields of dataset. Maybe someone can help me find an algorithm WHat do you mean by a lagorythm for searching in datafields Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions [Problem] Console Application / Namespace

  Ok well I just started Cpp programming and im having a few slight problems. Please don't flame im very new to the express edition and Cpp as a whole. Im trying to get a console application to run. But I keep getting the same problem. I think its related to something im doing wrong with the header includes or the namespace. The code.. Yes very basic but my first testing program.   Jonathan Caves - MSFT wrote: No: the console will exit as soon as your program completes - after all it is now done. If you want it to stay on the screen try adding this as the last line of the program: system("pause"); This will cause the console to wait for you to press any key to continue. How old am I ... old enough that I probably don't w ...Show All

• Visual C++ COM/ATL App Method Return/Pass defined types

  Alright, I am not by any means an expert C++ programmer, so please bare with me. I have created a com object that will be implemented within C#, the reason for this com object is to create a persistent object of another library. My situation is this. I have the complete com object created, but would like to add additional supporting features, i.e.: An object that is defined within the C++ com object, such as a struct containing an int, a wchar_t*, and a boolean value. I would like to be able to utilize the object type from within C# to store the object rather than have a new object type in C#. I have seen this done in many cases, but just have no clue where to find such direction for supporting this. I would also like the come objec ...Show All

• Visual C++ WM_MOUSEWHEEL Message Handler and SetParent Functions

  As soon as I call for the SetParent function the WM_MOUSEWHEEL event is disabled and but all the other message Handlers still active such as Mouse Button Down. I am usig Visual C++ 6.0 ATL Control Project. Thanks For compatibility reasons, SetParent does not modify the WS_CHILD or WS_POPUP window styles of the window whose parent is being changed. Therefore, if hWndNewParent is NULL, you should also clear the WS_CHILD bit and set the WS_POPUP style after calling SetParent . Conversely, if hWndNewParent is not NULL and the window was previously a child of the desktop, you should clear the WS_POPUP style and set the WS_CHILD style before calling SetParent . And you can use the below lines to do these changes. Dont forget that GetDesk ...Show All

• Visual Studio Tools for Office Name of Word document changing when publishing (VSTO 2005)

  Hi, I am using VS and VSTO 2005 to develop a Word template. Deploying, publishing and afterwards opening my document works perfectly fine. Except that when I want to access in the code the Word document name such as “myDocument.doc” with the following code [ Globals .ThisDocument.Name ], the name has changed in the mean time! I guess VSTO is modifying my documents name at the end such as “myDocument-1.doc”!!! This number at the end of the document will increment every time I ‘execute’ or try to open the document. So the next time, it will be “myDocument-2.doc”, “myDocument-3.doc”, etc. Do you have any idea, how I can stop this from happening (Can it come from the fact tha ...Show All

• SQL Server User unable to Save/Open Report in "Report Builder"

  Hi, I have environment that use SSRS 2005 ad hoc reporting. One of the users (out of 200) is unable to open or save reports in the report builder. the user succeed to open the report builder, when he try to save report that he build from shema he get error. as well when he try to open an existing report that build in the report builder he also get an error, On open the error is: The numeric portion of 2pt cannot be parsed as a unit of the type point. The Initilizer for 'Microsoft.ReportingServices.Design.Constants' threw an exception On Save the error is: System.IO.StreamReader: Deserialization failed: The type initializer for 'Microsoft.ReportingServices.Design.Constants' threw an exception. Line 2, position 2 P ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Screen dimensions for the 360

  I'm wanting to port my XNA Beta 2 games across to the 360 but before I start I have a couple of questions about the screen resolution. I'm wanting to be able to support standard def 4:3 and 16:9 as well as high def 4:3 and 16:9. Now, for the aspect ratio, I'm assuming I can just create a project matrix with the correct ratio, like: Matrix.CreatePerspectiveFieldOfView(MathHelper.ToRadians(45.0f), 16.0f / 9.0f, 1.0f, 10000.0f); ...for a 16:9 ratio. But, what resolution would I have to set the screen to for the standard def and high def I'm assuming that it defaults to a standard def resolution but I'm not sure what or even how to go about changing it. Please help. 480i (non-hidef) = 640x480 720i/720p = 1 ...Show All