Ron Dean's Q&A profile

• SQL Server Memory Configuration

  How do I configure DTS 2005 to not consume all the memory on my machine when processing large tables I have 1 table that is particularly large and it causes DTS to run out of memory when it tries to extend its internal buffer during a sort merge. Thanks! I am running the June CTP. Studio 2005 Beta2.050215-4400 .NET Framework 2.0.50215 Integration Services (Version 9.00.1116.00) ...Show All

• Visual Basic ComboBox

  Hi folks, maybe you could help me a little. If I understand right the idea behind Object oriented is that I can use the same object in different forms. I've created and used the ComboBox in one form and now I want to use it in two more. Can I do this How thanks a billion, Chris Hi Randy, I agree, I am not for hard coding - what I provided was a simple example to convey the concept of having a utility method f ...Show All

• Microsoft ISV Community Center Forums Excel ShapesText

  Hi, How can I get ( and change ) the text of a grouped shape in excel  Thank's for replies         Hi Denis, Here's some info from our support engineer: As I know, we can not directly get the Text property from a set of grouped Shapes. The workaround is to ungroup them temporarily in code, and re-group after getting the value of Text property. Here’s the sample ...Show All

• .NET Development Access, ADO.NET, Memory?

  I have a quick question. I have a VS2005 application which uses an Access database. The application and ADO.Net do all the work that most people would use a database engine to do. My question is about memory utilization. Suppose I had table A. It simply has pointers or references to a table of large documents stored as OLE Data objects. When JET/ADO.NET bring that table into memory does it bring the entirety of that table into memor ...Show All

• Visual Studio Restoring Add-Ins after Resetting the IDE

  Hi, When i reset the IDE by "devenv /resetsettings" from the commandline, my add-in gets removed from the 'Tools' menu. Then i need to drag it from the Tools\Customize.. to the 'Tools' menu. Can anyone tell me how to restore my Add-in to the Tools menu after resetting the IDE or point me articles regarding this Hi Padma, When you do a /resetsettings, the command bars are reset to defaults and you lose th ...Show All

• Windows Forms change ms access password....

  Hi, Is there any way I can programmatically change the password of an MS Access db Thanks Sorry Freja, I have no idea - I found that link by searching within MSDN. I did more searching now, and found this one, which might be& ...Show All

• Visual Studio Ho to get active document file name with VSIP?

  I added context menu item to all editors. And in menuItemCallback I wan't to get filename of opened document. Please provide code snippet. Hi Yury, You can use the monitor selection service to get to the active hierarchy. IntPtr hierPtr = IntPtr.Zero; IntPtr selPtr = IntPtr.Zero; IVsMultiItemSelect pMult; uint itemid; string document; IVsMonitorSelection monSel = GetService(typeof(IVs ...Show All

• Visual Studio How can I manipulate configuration/platform information in Solution file?

  Hello, Is there a way to programmatically modifiy/populate the configuration/platform information in the solution file Specifically, the following sections: GlobalSection(SolutionConfigurationPlatforms) = preSolution Default|.NET = Default|.NET Default|None = Default|None None|.NET = None|.NET None|None = None|None EndGlobalSection GlobalSection(ProjectConfigurationPlatforms) = postSolution {00643628-BB5E-4048-B264-233391C4A4A9}.Defa ...Show All

• SQL Server ole db destination not inserting data

  my package has a data flow task that is attempting to insert data into a sql server table using the ole db destination. the package validates and runs without reporting any errors, but the data was not inserted into the table. my data mappings look fine. how can i see what's happening when the component attempts to insert the data into the table Jamie Thomson wrote: Can you post all log messages that are produced from your data-flow ...Show All

• SQL Server columns order in entities

  Hi friends i've report model with entities that depend on views. my question is , currently all columns in a entity in the same order as view has them. i mean if i have a view like below create view vname as select name,addess,status from mytable when i create entity based on this i get attributes in this order name,address,status but i want address,name,status how can i change it to alphabatical order i know i can change manually in model desi ...Show All

• Visual FoxPro How to get the UserID and password login to windows in Visual Foxpro?

  Could you show me the way (in Visual Foxpro) to get the UserID and password that i've logged into windows please Thanks. ChinhNguyen GETENV("USERNAME") Will give you the username. I don’t think you can get the password, if Microsoft allowed that, it would pose a security risk. Dave M. ...Show All

• Visual FoxPro Help With Dynamic Forms

  Hello there; My Problem is : I want to create a form without determine to control source for each field. why, because i want to create it with the SQL statment such as : select no,name,age,id,address from perone; after run the sql statment i want to determine to result to the fields. can i do that plz help me An easier way would be not to include a destination. ie: select no,name,age,id,a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. C++ or C# ??

  I've been programming professionally for 8 years - all web and business programming in ASP, ASP.NET, and Java. I have a very solid knowledge of OO application development but I'm simply not challenged. The apps are all the same - build database, put front end on database to present data, allow data to be edited/updated, allow data to be deleted. Wash-rinse-repeat. I've been a gamer since I was 8 and I still play games like mad (own a PSP, DS, ...Show All

• SQL Server Report model GetUserID() function

  Guys, What is "GetUserID()" function returns when the report server, report builder and everything is using windows authentication http://msdn2.microsoft.com/en-us/library/ms156292.aspx Enkh. "Just use USERID" What do you mean USERID Is that a global variable, windows authentication username Enkh. ...Show All

• Microsoft ISV Community Center Forums VB and Excel - Change Event

  I am new user. Any help is appreciated. I have column with drop down selection - If a certain value is chosen, I want to control the format of the next cell. The Worksheet_Change event seems to capture this event if the user selects the change from the drop-down, but not if the user types the value in the cell and presses <enter>. How can I make sure that I capture this in both cases Here's some ...Show All