Mike Chapman's Q&A profile

• SQL Server Installing SP1 problem

  Hi folks I recently downloaded SP1 for SQL Server Express. When I ran the install program, I eventually reached the page where it asked me what features I wanted to install. I chose to do a full install on both the Database Services and the Client Components. Next it asked me did I want to run it against the default instance or a named instance. I chose the named instance option with SQLExpress as the particular instance. Next a page was displayed stating that Database Services 9.1.2047.00 and Workstation components and development tools 9.1.2047.00 were already installed. Clicking on the Details button resulted in a page stating that your upgrade is blocked. It did allow me to click on the next button which resulted ...Show All

• SQL Server Providing database to client without SQL Server

  Hi I'm new to SQL Server but not to VB or Access, but would like to design a database in SQL Server for a set of users who currently do not have SQL Server loaded on any of their networked machines or their Network server. Can I design a database on my machine which has SQL Server and then load it all onto their server without them having SQL Server, or do I have to load SQL Server onto their server Thanks for any help. Hi, The could use SQL Server 2000 MSDE or SQL Server 2005 Express Edition. Both are free. That's the way to go Regards, Worf ...Show All

• Visual Studio Express Editions Graph

  I already have a real time graph reading and plotting one point every single second from a txt file, this is done using paint event. I now want to learn how to add another real time graph which plot the average of every 60 data of the txt as one point, and this is running continuosly as long as the data are still available. These two graph have to run simultanously.. Is that possible to have 2 graphs running at the same time using paint event ...Show All

• Visual Studio *bump*

  Hi, folks. I am writing an Add-in for VS 2005 for vizualizing the debuggee's memory content in different ways to the memory window in the IDE. I am using C# My problem is that it seems to be very slow for me to get and parse the memory content. I am generally looking for large amounts of memory to view - but even with just 16kb, it all takes a bit long. How am I doing it now I am currently using the Debugger.GetExpression to get at the memory. I have tried a couple of ways and have problems with both. The expressions I am using: 1) (char*)<memoryaddress>,mb The resulting value from this is relatively easily parseable, returning 16 hex bytes in a string : "0x<hexmemoryaddress><space><hexbyte><space>< ...Show All

• Smart Device Development Deploying Multiple cab files at once

  I have developed my application and created the .cab file for this application. I followed the tutorial on creating an MSI file and custominstaller and this works fine. My problem comes from the fact that my application must also install .NET framework 2.0 and the SQLMobile .Cab file. I am wanting to package all of these together and be able to deploy them at one time from a users PC. I am not wanting to make the user click on each cab file to execute them. Can anyone point me in the direction of a good tutorial to accomplish this, or give me a good idea on how to do it. Thanks for any help It probably would work if you add some code to wait for CeAppMgr to exit before running next INI. Her ...Show All

• Visual Studio Express Editions Need to copy a project

  I need to copy one project including the form and create a new project. I will then make changes to the new project that allow the code to operate on a very similar manner but on a different data base. I don't want to clutter up the original project to make it do both. It would seem that the ability to copy an entire project and put a different name on it would be a simple way to save time and coding efforts. Thanks. It's easy to do with Windows Explorer. Select the directory containing the project Right Click Context Menu - Copy Select another Directory or the Current directory, right click context menu .... Paste ...Show All

• .NET Development exception streamwriter.writeline

  Hi all, i dont know why this exception occurs can some body throw light tia sahridhayan i checked the following, but still error occurs 1. i checked whether the string value is null or empty string, if so i add a default "NO message" 2. i am doing a concatenation of System.Environment.NewLine inside my logger code is below. wSW.Write(message + System. Environment .NewLine); Message: Server was unable to process request. ---> System.ArguementOutofRangeException Count cannot be less than zero. Parameter name: count at System.String.CopyTo(Int32 sourceIndex,Char[] destination,Int32 destinationIndex,Int32 Count) at System.IO.StreamWriter.WriteLine(String value) at SI.Logger.Web ...Show All

• SQL Server Jet.OLEDB.4.0 and Linked Servers (SQL standard 2005 on Win2003 SP1)

  I have been trying to figure out for some time why Linked Servers do not continue to run.  I start up my SQL Server Database service, and then using SQL Server Management Studio I create one or more linked servers to Microsoft Access Databases using the Jet Provider.  I then run some queries to that access those linked servers without any problems.  (One currently is called 'THE') After some time has passed, possibly minutes, hours or days, I can no longer access any of the linked servers.  No data, queries, tables, or anything is accessible to me anymore.  I use this command "EXEC sp_testlinkedserver N 'THE' " to test the linked server and get the following error msg. OLE DB provider "Microsoft.Jet.OL ...Show All

• Visual Studio Team System Problem in running build -error MSB3073

  Hi I am trying to run a build using TFS and I geting an error. It looks like it fail on some post events (md directory + copy) of a VS project. Is it a known bug in TFS build If I build the solution without using TFS build it works ! Thanks, Error: Solution: MasterSolution.sln, Project: Destinator.PC.Services.Local.csproj, Compilation errors and warnings C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(3089,13): error MSB3073: The command "md C:\console_build\Destinator_IL\PCPortal Master\Sources\PCPortal\DestinatorPC\\Destinator.PC.App\C:\console_build\Destinator_IL\PCPortal Master\Binaries\Release\ copy *.* C:\console_build\Destinator_IL\PCPortal Master\Sources\PCPortal\DestinatorPC\ ...Show All

• Visual C# read pdf content using c#.net

  Dear all, I am trying to read PDF content using C#.net, but its returning content as a unicode characters .so how can i read the characters form PDF Thanks, Aya. ...Show All

• Visual Studio Express Editions String to number

  Is there a quick way to convert the string "2.334.654,23" to the number 2334654.23 I have tried decimal.parse but does not like the format of the string (it works with 2,334,654.23). Thanks, Antonio Here's the code to do it: Dim nfi As NumberFormatInfo = New CultureInfo( "en-US" , False ).NumberFormat nfi.NumberDecimalSeparator = "," nfi.NumberGroupSeparator = "." Dim s As String = "2.334.654,23" Dim d As Decimal = Decimal .Parse(s, NumberStyles.AllowDecimalPoint Or NumberStyles.AllowThousands, nfi) Note that some european cultures already have that number format. If you use one of those cultures, ...Show All

• SQL Server How to kill running query?

  Hi! Our users often run malicious queries which could take up to quarter of CPU power for couple of hours. If there is more that one such query, the whole environment is severely impacted with no other recovery that restarting the service. Is there any (easy) way how to kill unwanted connections and related queries If not, could someone please give some explanation for that (is it design issue or what ). Otherwise I'd like to see that functionality in SP2-3. Someone with similar experience out there For Excel case this needs to be investigated. If this is not about Office 12 Beta Excel then the client probably executes the queries on non user interface thread and when user tries to cancel the query the cl ...Show All

• Visual Studio Team System Source Control (project file)

  Is it common practice to checkin the project file Everytime someone adds/removes a class it is forcing a merge.. if the user does not merge the project file, then classes will be downloaded to his local drive but not be in his project.. anyone have solutions for this I'm not sure why one would ever choose *not* to check in the project file. How else would you get a single known project file to be used by multiple developers You'd have to rely on developers sending emails to each other telling each other to add files into the project. That would get out of hand quickly. Project files, at least in VSS, were always problems for me. Frequently we ended up with duplicate file entries in the project file that had to be manually removed ...Show All

• .NET Development Cannot disable breaking into debugger on exeception

  I am in VB.NET For some reason (not the config file), a particular project I open in Visual Studio will not run without breaking into the debugger when an exception occurs.  I have tried looking under "Debug/Exceptions" and nothing is checked in there, and I've also gone through the "Options/Debugging" dialog.  I have no g.d. idea why the code insists on breaking into the debugger... even when there's a Try/Catch specifically catching the exeception that was thrown. Any ideas ...Show All

• Visual Basic Yet another DataGridView ComBox question

  OK, Here's the problem: I need to create a DataGridView to display various states and cities within the states. There are two pair of these side by side for a total of 4 columns: toState, toCity, fmState, fmCity. The trick here is that each is a combobox. When I pull down the toState combox and select a state, a new row should be added (as it is in the vanilla DateGridView), and I need to immediately populate the toCity dropdown enum list with the cities in the state that was just selected. Same goes with the fmState/fmCity pair. After the four items have been selected, the user can then add more rows using the same method, or save their entries. The SAVE function has to get the entries to an SQL database through some ingenious methods ...Show All