KoryS's Q&A profile

• Windows Forms Access Data Export to Excel spreadsheet

  Hello everybody, ---------------------------------------------------------------------------------- Development Tool: Visual Studio .NET 2005 Programming Language: Visual Basic .NET Application Type: Windows Form based Issue: Take Access data (maybe even data from forms controls) and export to an Excel file ---------------------------------------------------------------------------------- I have created a windows forms application that interacts with a Microsoft Access database. This database collects tons of statistical information on trainees and what we call solutions. It also tracks user login and logout times and dates, as well as other information. I presented the alpha version of the software to a large group ...Show All

• Visual Studio Embedding shapes in v1

  Hi, First of all congratulations on getting v1 out. It's looking pretty cool! I have been trying to migrate a DSL I developed in the June CTP version, but I have run into some errors. A couple of examples are.. Error 23 A GeometryShape may not be parented on a GeometryShape. In the ShapeMap mapping State to StateShape, the parent element path leads to StateManager, whose mapped shape is StateManagerShape. Error 26 A ImageShape may not be parented on a GeometryShape. In the ShapeMap mapping EnterCommand to EnterCommandShape, the parent element path leads to State, whose mapped shape is StateShape. Basically my DSL is similar to UML statechart notation, but I want to be able to nest states inside one another hierarchically in ...Show All

• Windows Search Technologies Would it be possible to use a central index location for our whole network clients?

  Hi developers, we would like to offer Windows desktop search to every employee in order to search our fileserver for useful content. Two problems still to be solved: A Indexing of network drives consumes a lot of bandwidth - would it be possible to create a central index every day and point the clients' desktop search to it B If those clients could use an index created by an administrator of that fileserver (see A), would it be possible to find words but to hide the cached content Background: Sometimes people are looking for information they are not allowed to access at the moment. If they could find some words that lead them to the information needed, they could ask for permission afterwards. But, and that's the reason for que ...Show All

• SQL Server SQL Server 2005 Database Tuning Advisor DTA tuning SQL Server 2000 FAILS

  Hi all, I am using the SQL Server 2005 Enterprise Database Tuning Advisor to try to tune an SQL Server 2000 Enterprise Edition database. I created a .trc file uning the SQL Server 2000 Profiler. I ran this for 24 hours. I chose the template SQLProfilerTuning. In the Gui, for workload file, I entered the name of my trace file that I captured over the last 24 hours. In database for workload analysis I chose: tempdb. In select databases to tune, I put a check mark next to the name of my production database. On the toolbar, I clicked the button representing "Start Analysis" In the Progress Tab, after 5 minutes, I big STOP X appeared. It died on the step "Consuming Workload" It said: Error: ...Show All

• SQL Server Connection Issues To Report Services

  Hello all, I just installed the SQL 2k5 standard suite of services on a w2k3 enterprise edition server. All went well except for the connection to the reporting server. I get the error below. "No connection could be made because the target machine actively refused it" I can't seem to find any information on this error and have no clue where to even start. I've done 10+ installations of this software on various machines and have not encountered this error on any of them. I have uninstalled, then reinstalled the reporting services and still no solution. All connection attempts are being made on the actual server, not from a desktop. sp1 for sql 2k5 is also installed, if that helps. Windows Firewall is off. What w ...Show All

• .NET Development Big DATASET Problems

  At our company we use a Dataset to convert a selection from one of our databases to nested XML. We use about 10 stored procedures to extract the data under the control of a SHAPE command. We feed the SHAPE string to a FILL command that creates the dataset with 10 result datatables and all their datarelations. This arrangement has worked well for us for over a year with a large amount of data, but as our database has continued to grow, we are running into an OutofMemoryException. This exception is thrown while the machine is still showing almost a gig of free memory (It’s a 3 gig machine). There is also 15 gig of free space on the C: drive. Is there an upper limit to how much can be stored in a Dataset Is i ...Show All

• Visual Studio Team System Project creation fails

  Hi, I'm getting the following error when creating a new project in TFS: Event Description: Task "Currituck.WITs" failed Exception Type: System.Web.Services.Protocols.SoapException Exception Message: Server was unable to process request. ---> Violation of UNIQUE KEY constraint 'UQ_ADObjects__DomainName_SamAccountName'. Cannot insert duplicate key in object 'dbo.ADObjects'. SoapException Detail: <soap:Detail xmlns:soap="http://www.w3.org/2003/05/soap-envelope" /> SoapException Full Info: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Violation of UNIQUE KEY constraint 'UQ_ADObjects__DomainName_SamAccountName'. Cannot insert duplicate key in object 'dbo.ADObjects'.    at System.W ...Show All

• Visual Studio Express Editions My.Settings file location

  Hi. Is there an easy way to change the location of user config files without having to re-write the entire settings class and provider Reason: I'm the only user of my PC, and I do a lot of small samples that never make it to real life (at least, not on their own.) Usually when I'm done with the test/sample project it's deleted or at least never used again. Then I have several unused user configfiles floating around in the Application Data folders. What I would like was, to be able to save the config files in the bin folder, so if I choose to delete a solution, the config files are deleted as well. I have no need for individual user files. Just one. The Application Settings would be ideal, except that they are read-only. Is ther ...Show All

• .NET Development bug on the registry function

  Hello, A program is reading some value in the registry to apply some configuration. When reading the registry in sequence for several keys, there is about 2% chance that the read will fail and return an empty string on some machine. This program was in C and upgraded to VB.net. It is run with the framework 1.1. The program always worked well in C, the bug appeared with VB.NET. I have made an application to make a stress test to the registry. Begin //Each time you make a read, you open the key, get the value and then close the key. loop from 1 to 100 var1 = readRegistryKey var2 = readRegistryKey var3 = readRegistryKey var4 = readRegistryKey var5 = readRegistryKey var6 = readRegistryKey var7 = readRegistryKey var8 = readRegistry ...Show All

• SQL Server Your upgrade is blocked because of cross-language compatibility rules

  I am getting this error in the installation of Sql server 2005 express. I have windows xp service pack 2 in spanish. Net Framework 2.0 installed. Please, What can i do Jose. You must have the appropiate language update pack, cross language installations / upgrades are not supported. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Smart Device Development MS Access query from Mobile App

  I'm trying to determine what is and isn't possible before starting development of a mobile application for this mobile device ( http://www.intermec.com/eprise/main/GSS/Service/Content/Tools/Tools_ListProductManual section=Tools&Category=CMPTR&Family=CMPTR2&Product=CMPTRCN2B&Tool=Manual&Language=English ) The current plan is to have a laptop acting as a central server and 2 handheld devices. On the laptop will be an Access database. The devices (barcode scanners) would be connected through wifi to the laptop. Would I be able to create a C# application on the mobile device that can pass the read barcode to a query to the Access database on the laptop through the wifi connection Or what would need to be done to enable i ...Show All

• Windows Forms windows service confirmation

  Dear All, I have created a windows service with the installer and successfully installed it. But I am lost and dont know whether or not my service is running or not I have put debug.write in my code but I dont know where to check either My service code I put in the onstart function is this correct or must I need an extra main function how to control my service to run just on a particular hours of a day Thanks. Dear Ashish, Sorry I am quite new. So when do we use debug.write I would like to confirm with you is that when I start a new windows service project in VS2005 I just have 2 function in it OnStart and OnStop. So I put my code in the OnStart it that correct to do or not Another ...Show All

• Visual Studio can't installing

  I am follow " Extensibility Guided Tour" article to make my msi file. But, when setup it then have messagebox " This is a VsPackage and Requires Visual Studio to be installed". Please help me.. thanks.. PS: I have PLK. Sorry but I didn't use the standard setup project for creating the installer.   I use WiX toolset instead to do that. This toolset includes extension for Visual Studio which allows you to create special project type inside your solution. Maybe it will be helpful to read my post related to WiX here .   IronPython sample includes the Setup created with Wix toolset. You can find it in C:\Program Files\Visual Studio 2005 SDK\2006.11\Visu ...Show All

• Visual Studio Team System Microsoft.Tools.FxCop.Sdk.Introspection.RuleUtilities.IsInterface -> Microsoft.FxCop.Sdk.Introspection.RuleUtilities.OOPS!..

  I was using some old FxCop version with my custom rules set. After migrating to new FxCop i've got a kind of a stuck - after change Microsoft.Tools.FxCop.Sdk.Introspection old namespace to Microsoft.FxCop.Sdk.Introspection new namespace i've got realised that RuleUtilities.IsInterface is now obsolete. How can i check TypeNode whether it deals with an interface now Thank you in advance! I'm not sure what you mean by private variables, but if you are talking about getting access to a method's local variables, see the following FAQ: How do I access the locals of a method in a custom rule ...Show All

• Windows Forms VB2005 Add system Date to new record in Datagridview

  Hello, When I push the add button a new row is added to my datagridview. How can I automatically insert the system date in the new row in the column 'Date' Yes that will work. I prefer the defaultvaluesneeded event because it will fire when the user presses the add new button or goes to the datagridview's add new record row (the one with the *) ...Show All