Nick P's Q&A profile

• SQL Server SQL 2005 SP1 Upgrade Error for Upgrade Advisor

  Hi, We are performing a SQL 2005 SP1 upgrade from SQL 2000 on our Windows 2003 SP1 Standard Edition. When we run the upgrade, we got a error "Upgrade Advisor Return -1" as a pop-up window. When we run the Upgrade Advisor separately, we get this error : =================================== Common Language Runtime detected an invalid program. =================================== Common Language Runtime detected an invalid program. (System.Xml) ------------------------------ Program Location: at System.Xml.Schema.SchemaInfo..ctor() at System.Xml.Schema.XmlSchemaSet..ctor(XmlNameTable nameTable) at System.Xml.XmlReaderSettings.get_Schemas() at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UARepo ...Show All

• Smart Device Development .NET Assemblies compatibility between CF1.0 and CF2.0

  Hi I have a .NET assembly (.dll) developed in VS 2005 - CF2.0 and want to import this .dll into my VS2003 . It gives me the error: "A reference to 'C:\....................\xxxxx.dll' could not be loaded. This is not a .NET assembly" Anyway to get the .dll working or I need to recompile the assemly under VS2003-CF1.0 Thanks Older framework/compiler knows nothing about newer assembly. So yes, you need to recompile DLL for V1 or move V2 project to V2. Second option probably would be significantly easer. ...Show All

• Windows Forms how te get date only?

  I am using this code to get all available doctors in a specefic dates (regardless of the time). sql_command = new SqlCommand ( "sp_get_available_staff" , sql_connection); sql_command.CommandType = CommandType .StoredProcedure; sql_command.Parameters.Add( "@starttime" , SqlDbType .DateTime).Value = e.Start.Date; sql_reader = sql_command.ExecuteReader(); and this is mt stored procedure: SELECT working_schedule . id_number , persons . person_name FROM working_schedule INNER JOIN persons ON working_schedule . id_number = persons . id_number WHERE DATEDIFF ( mi , starttime , @starttime ) = 0 ORDER BY persons . person_name but it's not retriveing anything t ...Show All

• Smart Device Development XML Character Encodings

  Hello everybody, I am doing the following steps: 1.- I do an HTTP Post to a host 2.- I get an XML as response 3.- I read the XML 4.- I add the xml readed values into a comboBox. The response contains special characters like a , o... Where do I have to set the encoding Thank you. In 1 and 3. E.g. if you're using TextWriter/TextReader classes to read/write your XML look into Encoding property of these classes. AFAIK UTF8 would be used by default which should be able to handle pretty any character you can possibly have. ...Show All

• Visual Basic Waiting for a Document to Load to Process

  I'm trying to process the information in an HTML file, but I can't get it to wait for the file to load before trying to process its information. Here's what I've tried (using Visual Basic/Visual Studio, but language shouldn't matter too much): Web.Navigate(" page url here" ) While (Web.ReadyState = WebBrowserReadyState.Loading) End While Dim stream As StringReader = New StringReader(Web.DocumentText) Dim num As Integer = 0 Dim currentLine As String = stream.ReadLine() Debug.Print(currentLine) While (Not currentLine.Substring(0, 4).Equals("<td>")) ........currentLine = stream.ReadLine() End While The Debug statement always prints null, and the Exception comes on that last While statement. ...Show All

• Smart Device Development Setting audio system volume in CE.NET 4.2

  Is there a generic way to set the system volume. I'm assuming it's through Pinovke. I have my WavOut class setting the waveOutSetVolume for the wav stream, but that doesn't set the volume in the "master volume". (The one I see on the control panel applet). The closest I have seen is using the hardware mixer audio functions: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcewave/html/cerefHardwareAudioMixerReference.asp I haven't seen any sample code or tutorials on using this mixerOpen/Close Pinvoke calls. If anyone has done this, please let me know if I'm on the right track, and if you have some sample code, that would be great. If I get this on my own, I'll post back the answer. Thanks ...Show All

• SQL Server Steps involved in uploading a SQL database to ASP.NET 2.0 server space

  I am using (and making some enhancements to) the auto-generated ASPNETDB database in Visual Studio 2005. Now, I would like to deploy the application I have built (together with the data it contains and uses) to my ISP's ASP.NET 2.0 server and my freshly-purchased MS SQL database. I haven't a clue how to do the above. Some other posts mention Entreprise Manager and Data Transformation Tools, but I really don't know where to start. I wonder if someone would be kind enough to go through each step in detail Don't worry about sounding condescending... I really am a novice! I apologise for the naivety of this message...! Any and all help hugely appreciated! Josh Ord-Hume ...Show All

• Visual Studio 2008 (Pre-release) Whether there is a way which do not need .svc file while the service is hosted in IIS?

  Hi Whether there is a way which do not need .svc file while the service is hosted in IIS If you have 100 services,so you should create 100 .svc file to map it. I think it's not convenient Thanks, Zhihao Hi Zhihao, yes, you need to have one .svc file per service. We don't support non-svc services. Actually from usability standpoint of view, you would benefit from this model since each service would have its own base address based on the .svc file's virtual path. If you don't have code in the .svc files, they would be very small physical files. ...Show All

• Visual Studio June GAT Installation Issues

  Hi All, I had major issues in in uninstalling previous version of GAX. I had to revert to editing the registry and using msizap.exe as pointed by Tom in the thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=502698&SiteID=1 . After doing so I successfully installed the June version of GAX. Since then I am not able to install GAT. It says GAX is not installed. If I try to uninstall June GAX it wants me to unregister following package(s) guid81f72285_df90_4e71_9ca5_233fdadf6200, MetaGuidancePackage. I have removed every file or registry entry which has 81f72285 in it. No success. I have installed and installed VS 2005 twice but still can't get around this problem. Any help / pointers would be appreciated. Regards, ...Show All

• .NET Development how to display text on the image

  hi, I have displayed the image in the picturebox . i can do zooming of the image. I would like to display some text on the image without affecting the zoom of the image can anyone help me in this regards, Singam. I agree to Ian's viewpoint.By the way our requirement is to show the text on the image.I think the approach I have specified will be holding good.The picture box control will be providing only the basic functionality.It wont support anything like what we need.If we need to display the text in the picture box,the orginal image should have the text embedded on it by using some tools like MS paint.We cannot do it programatically. ...Show All

• Windows Forms Adding new column to an Access database

  My application works with an Access database that contains valuable production data. I need to add a couple of new columns to one of the tables, but don't want to trash the user's data. At startup, I would like to check the existing database for whether or not it has been modified and, if not, add the new columns. What is the best way to do this Thanks, that did it, although I needed to translate VB. When you do, it looks something like this Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + myDir & _ "\3602.mdb; Persist Security Info=False" Dim cnnConnection As OleDbConnection = New OleDbConnection(strConn) cnnCon ...Show All

• Software Development for Windows Vista Super Slow Indexing

  Hey everyone. My name is Scott, and this is my first visit to ths msdn forums so howdy all. My issue is with three processes that, I believe, are acting in a way that they shouldn't be. Here they are: SearchFIlterHost.exe SearchIndexer.exe SearchProtocolHost.exe I looked them up and I believe they are Windows Desktop Seach. Basically what happens is whenever I try to explore any directory (whether its the root of C:\ or some deep subdirectory) on any drive (even the control panel), it takes about 10-15 seconds to display all the files/folders that should appear relatively instantly. The little green progress bar moves across my navigation bar, and then it works. I discovered that windows desktop search makes periodic updates the the In ...Show All

• .NET Development Simple FTP upload sample code

  I'm looking for a sample code for a small ftp operation. Basically, it's only to download/upload a file from/to a directory in a server, no need for ssh, listing/creating/deleting directory. It's just to receive/send a regular ascii text file, with a given name and password, to a directory. Some of the sample code I've seen have complicated scheme, I was wondering if anyone has examples for something like this. Here are some links.. Download file : http://msdn2.microsoft.com/en-us/library/ms229711.aspx Upload file : http://msdn2.microsoft.com/en-us/library/ms229715.aspx -Amit ...Show All

• Visual Studio Express Editions Nplot.dll - Free .NET chart plotter component - How to implement?

  Hi, Anyone has used this component In VB Express How does one get the plotspace in a form   Download at http://www.nplot.com Thanks Jake   Hi, Got the basic thing working. Reference material found at http://www.andrewtheken.com/nplot/ Still would like to see (eventually discuss) some implementation of multiple real-time measured  values, plotted against  a time-based X axis, in a VB Express application. Mouse interaction on the graph should make settings like 'zoom' and 'shift' possible. One doesnt have to re-invent the wheel...   Credits to Matt Howlett and Paolo Pierini Thanks Jake ...Show All

• SQL Server question on using xp_cmdshell

  I am trying to run an exe file like: EXEC master.dbo.xp_cmdshell '\\Share\sharepoint\folder1\folder2\test.exe "input parameter"' And executing the above with the input should give me an output.But the input parameter is not recognised. Any help. Thanks you may want to note that XPs are to no longer exist after SQL 2005 via this quote that is everywhere in BOL2005: "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead." And regardless of xp_cmdShells future I would encourage you to port what your doing into the ...Show All