RichardCasey's Q&A profile

• SQL Server CTE Error: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause,

  I am having this error when using execute query for CTE Help will be appriciated So your suggestion to check the compatability level led me to the answer. The database server I was trying to run the query against is a SQL2000 server. We have many instances of SQL Server running for development purposes, and I didn't realize I was working against a SQL2000 instance. That database has the data I need in it, so I will have to move it to another machine. A silly mistake, but I wouldn't have realized it, Thanks for your help! ...Show All

• Visual C# System Tray Icon with background processes

  Hello Background I'm writing a system service style application. It consists of a NotifyIcon in the sys'tray that has several functions that are called from the ContextMenu / Event s. When the app' starts it should do nothing but sit there until the 'Start Sending' MenuItem 's Event is called. This event starts a new Thread which checks a file repository between Thread.Sleep(15*60*1000) . Problem To cut to the chase, the application is maxing out the cpu usage during a loop: while ( this .Created){ Application.DoEvents();} How to I prevent this excesive usage Do I need to access the System Idle Process This usage doesn't actually halt the server or even slow it down it just capitalizes the usage as there is no ot ...Show All

• SQL Server temporary table

  hi ! i used some temporary table in store procedure ( sqlserver 2005 ) our team have report software calisto . the calisto use crystal and reports which use this store procedure . because of that , we have list of many temporary table with the same name #dbo . sug_name ... , #dbo . sug_name ... ,...... in the system database . what could be the reason for that and how can we drop it Msg 3701 , Level 11 , State 5 , Line 2 Cannot drop the table '#sug_name' , because it does not exist or you do not have permission . " when i run query : select * from sysobjects where name like '#tmp% ...Show All

• Visual Studio Team System Solution: "cannot locate license assembly" during Team Build process when using third-party components

  Hi there, when using Team Build with a project that uses third-party components such as Infragistics that use the license.lix licensing mechanism I get the error "cannot locate license assembly" during the compilation phase of the build process. I do not consider installing the Infragistics controls on my build servers since they are supposed to be clean. What am I doing wrong here What would be the recommended way to accomplish this Why is a license neccessary to compile Thanks, Neno Steps to Reproduce: -> Open Team Explorer -> Create a BuildType for a Team Project that references Infragistics -> assemblies Start Build => Receive build error "cannot locate license assembly" I ...Show All

• .NET Development Base-64 encoding

  I recently read this blog post: http://blogs.msdn.com/shawnfa/archive/2005/11/10/491431.aspx and it said that I should use base-64 encoding to turn strings into bytes because "base 64 encoding is guaranteed to be able to accurately represent any input byte sequence" well when I run this code: Dim clearBytes As Byte () = Convert.FromBase64String(strInput) I get a FormatException with the message "Invalid character in a Base-64 string" strInput just contains the contents of an xml documument. There isn't anything besides ascii characters in there. What could be causing this Base-64 is encoded by characters A-Z, a-z, 0-9, +, / and =. The classic XML characters '< ...Show All

• Visual Basic How to "know" all controls on a window (I mean: any running program that have a form) and Extract the display current screen val

  Any VB example , how to "know" all controls on a window (I mean: any running program that have a form). If I know the program using controls like MSflexGrid, textbox, and labels. I just wanted to extract screen value from the running program. Any solution. So far I only can come out with the following codes, which only can return title of exe program I try to use Microsoft spy++ to know all the running instance names and its properties. I manage to get the class name for the program which I wanted to extract the form data. Following is the progress I can come out. Any other idea please help. Class Name: ThunderRT6FormDC Dim lHwnd As Long Dim sTitle As String, sIncidentNo As String Dim lRet As Long ...Show All

• Visual Studio Tools for Office Excel Edit Delete Disabled

  I created an Excel Workbook project using Visual Studio and VSTO. This project uses the ListObject control bound to a DataTable to display and update data in SQL Server 2000 database. When deployed to the user's workstation, this application has an annoying habit of disabling the Delete item on the Edit menu, preventing the user from deleting columns, rows or cells. Actually this is more than annoying - it's a show stopper. Researching the problem online produced very little in the way of amswers. Are other people seeing this behavior I did find a reference in this forum article: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=309265&SiteID=1 which suggests deleting Application Data\Microsoft\Excel\Excel11.xlb. Thi ...Show All

• Windows Live Developer Forums LOADING GEORSS not working

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/VEMapControl/HTML/WorkingWithLayers.asp The above page references the ability to load a GEOrss file. However the example only shows loading a "collection". I have followed the code correctly - however when I attempt to load a GEORSS compliant file - it says "0" items have been loaded. Could you provide example page of loading georss Can you please show the source code exactly like was used for the Interactive SDK (including the link to the geoRSS used - so we can see how the georss xml file was written), as well as how the icons were loaded and the popup layer was structured with pushpin hover. Thanks   Easy fix: just replace your callback funct ...Show All

• .NET Development request help with DLL on database machine & thin Client application

  Hello, Here is what I'm doing: 1. SQL Server 2005 database is created on machine using Transact-SQL (this includes dropping any previous files). This is created onto the Defaul instance (MSSQLSERVER). 2. a DLL (class library) is made in VB.NET using ADO.NET connection objects. The connection string looks like this: strConnection = "Data Source=.;Initial Catalog=" & dbName & ";Integrated Security=True" where "dbName" is "SQLdatabase1" 3. the Client application adds a Reference to this DLL and will run from the development machine. Here is the problem and the question: When I install the DLL onto the database machine, and I shut off the .MDF database on my developm ...Show All

• Visual Studio Dependent build task running before output of parent task is written to disk?

  I recently aquired a dual processor system. This has caused my build to start failing in odd ways. Picture the following scenario. Task A depends on Task B and Task B depends on Task C. Task C outputs a file. Task B modifies that file. Task A utilizes the same file. On a multi processor system, task A errors out because the file doesn't exist. Running the task manually from a command prompt after the failed build succeeds just fine. On a single processor system, task A works fine. What is going on here I figured it out. Task B was using the WindowsInstaller.Installer COM object. This object was not freeing up the file untill garbage collection occured in the custom task. I forced the garb ...Show All

• Visual Studio Need help opening crystal report based off 2 tables in dataset

  I have a form with a dataset that contains account records in one table and another table that contains transactions for accounts that are in the other table. I'm trying to create a report based on the two tables using an inner join. I used the report wizard to create my report and when I open it it just sits there not populating like it is hanging. The dataset maybe has about 4500 records in one table and the transaction file has 35K records. here is the code I'm using to open the report viewer and load the report. Any help would be great! Private Sub Form3_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load reportDocument1.Load(Application.StartupPath & "\CrystalReport2.rpt ...Show All

• Visual Studio 2008 (Pre-release) Not able to get "A Visual" from VisualCollection object, although it exists

  I am drawing lots of custom visuals; some using custom geometry objects using streamgeometry and some are drawn using plain vanila draweclipse using drawingContext. Once all of the above objects are created and displayed on the form,On hit testing I am not able to reference back any of the objects created by the streamgeometry. None of this working ... _currentVisualCollection.IndexOf((Visual)_hitResultsList ) _currentVisualCollection.Contains(((Visual)_hitResultsList ) Using VisualTreeHelper .GetDrawing(visual), i do get the visual back but I cannot do anything if I cannot locate the same visual in the visualCollection and remove it as I need to update the layout. Any leads.. Hopefully this post will catch any M ...Show All

• Visual Basic How to compare grapical (bitmap) data?

  I'm making this program for printable binary data. (that desn't matter now) But what does is how to compare that graphical data from a existing data base. This might give you the idea. You have seen how CSIs get a fingerprint, scan it(make it a piture) and then search AFIS, or another crime database That is what I'm trying to acheave. Please Dont let me down, on this! Or simply put, I'm trying to make a binary (bitmap)data comparing program. Of course after that data has been pocessed ( deleted all colors that would interrupt search, just the fingerprint color is there, nothing else). I wrote this function to demonstrate exact comparison between the image in two Bitmap classes. If they are having the same size, pixel format, pi ...Show All

• Smart Device Development library load failed

  after build my cab file and when i'm trying to deploy it on pocket pc this message view library load failed Please see this, items 7, 9, 10, 17. http://www.danielmoth.com/Blog/2005/03/please-read-before-posting-to-ng.html ...Show All

• SQL Server using SCOPE_IDENTITY

  I need to create two records in two seperate tables, and place both their generated keys into another record. What I have tried is creating a variable like this DECLARE @filedata_id int; then after the record has been created with an insert statement i do this EXEC @filedata_id = SCOPE_IDENTITY ; I get the following error when running the stored procedure Could not find stored procedure 'SCOPE_IDENTITY'. Would someone be so kind as to help me out a litte Slightly lost here. Any help is appreciated. Thank you :) select @filedata_id = SCOPE_IDENTITY() or set @filedata_id = SCOPE_IDENTITY() Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All