holthaus's Q&A profile

• SQL Server FlatTextFile Licence Limitation with SQL 2005 Standard

  I have developped a package that loads a flat text file into DB. Runs OK from SQL BI Studio. When I run it from SQL IIS, I have the following error message "Erreur, le niveau de produit est insuffisant pour composant <<file IN>>" that let me think this FLATTEXT ConnectionManager is only in SQL 2005 Enterprise version Can you help Does the machine running SSMS actually have the full SSIS server installed, not just the workstation components This is more often the issue, rather than the "license" or edition. I don't think I have ever seen a MS supplied list, but to the best of my knowledge this article still holds true, including the list of components which are Enterprise only- SQL ...Show All

• Visual Studio Team System Setting up Project Alerts by Project Administrators

  It looks to me that project alerts are set by individual users in such a way that if a developer wants to be alerted for any new work items assigned to him/her, he/she will have to set it up on the client he/she is using. Is there a way for project administrators to set up project alerts For example, when a work item is assinged to a user, the user will receive an email alert even if the user has not set up project alert himself. Thanks for your reply but I cannot seem to be able to find bissubscribe.exe or workitem event subscription tool as displayed in the link to the blogs above. Is the bissubscribe.exe supplied by Team Foundation Server How do I get to the workitem event subscription scree ...Show All

• SQL Server .NET Runtime 2.0 Error with EventID 5000

  Hi, We are performing a SQL 2000 to SQL 2005 upgrade on a Windows 2003 SP1 server. We encountered error in the SQL 2005 upgrade with the following 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.UAReportController.LoadAndValidateDataFile() at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReport.ValidateDataFil ...Show All

• .NET Development Regex search for two words seperated by a space

  I have a text file that I need to match on. I load the file into a string and then strip out the newline characters (\012’s) and replace them with stars (\052’s) to make working with them simpler. So then I have a string variable made up of groups of text separated by double stars (**) with the occasional star in-between the double stars. I need to find names within those ‘groups’ but I also need all the text within the group. I build my regex by using a string variable for the name and end up with a regex like this: Dim textForRegex As String = "( xism)\*\*[^\*]*" & strName This works as long as I use a single name in my ‘Prompt’ string. When I type in two words such as ‘John Smith’ my regex search fail ...Show All

• Visual Basic Datagridview Scrollbars Freeze up after binding datata to the control

  Problem: Scrollbars are not functioning after the datagridview control is populated with data. I am having a hard time trying to figure this out, but I am loading an excel file into a table, and then binding the table to the datagridview control. However, after the datagridview control is filled. The scrollbars seem to be frozon. I have tried loading a table with 10 rows and tried other sizes as well but same result. The only way, I was able to get the scrollbars to function correctly was to hide the form and then show the form again. After showing the form again with the datagridview already populated the scrollbars function correctly. I have also tried to refresh the datagridview control, the form and I also tried application.doeve ...Show All

• .NET Development HOw to check whether there are null rows in datareader

  Hi How to check whether there are null rows in a datareader. here is the query which returns null value. "select max(attendence) from tblattendance where loginid=34 and att_month='"+december+"'"; but when i check is datareader.hasRows it shows true when there are no such rows corresponding to month 'december'. please help me regarding this query. Thanking you Issuing select max(attendence) from tblattendance where loginid=34 and att_month='"+december+"'; will return 1 row with a value of NULL for max(attendence) if no records meet your criteria. Therefore, all you need to do is check if the returned column contains NULL and you'll know that no rows exist ...Show All

• Visual Basic Can't kill Excel.Exe after using Excel component in vb.net

  Hi , I'm using Excel.Application generating excel report via vb.net 2003 , the problem is excel.exe process reminds even after generated excel report closed . I have been using the followed code to close or dispose the process , but it does'nt work either. thenks Dim procList() As Process = Process.GetProcesses() Dim k As Integer For k = 0 To procList.GetUpperBound(0) Step k + 1 If procList(k).ProcessName = "EXCEL" Then procList(k).Close() procList(k).Dispose() End If Next Hi, that is really not the supposed way of releasing a COM server ;) Call System.Runtime.InteropServices.Marshal.ReleaseComObject on every COM va ...Show All

• Visual Studio Team System Avg. Response Time for transaction.

  After I run load test, in the table view for counter, I can see "Avg. Response Time" for my transaction. In the table, there are also "Min, Max, and Avg." When I select the counter "Avg. Response Time" in this case, there is another table that shows up on the right corner. However, I am confused by this one table. And it usually looks like below. What is the "value" in this table mean I saw one case like I have "Avg. Response Time" for one transaction like "Min" is 2, "Max" is 694 and "Avg" is 57. But in the table below, those values are much smaller than the values I got from Min, Max, or Avg> Avg. Response Time Value - ...Show All

• Visual Studio How to filter ItemTemplates in "Add New Item" dialog?

  Hi there, I implemented my own Project SubType and some Project and ProjectItemTemplates. When adding a new item, I'd like to filter the shown list of ItemTemplates. Is that somehow possible Regards, Jens Thanks for the hint, but i think you meant GetGuidProperty instead of GetProperty ;) ...Show All

• Visual Studio 2008 (Pre-release) How to Generate multiple bitmapimage fastest ?

  Hi, I'm a beginner with WPF. I try to make a little picture browser so i need to generate multiple thumbnail. With GDI+ in .net 2.0 the peformance was good : For Each path As String In System.IO.Directory.GetFiles("D:\Images\wall paper", "*.jpg") Dim strm As IO.Stream = New IO.FileStream(path, IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.Read) Dim img As System.Drawing.Image = System.Drawing.Image.FromStream(strm, False, False) Dim thumb As System.Drawing.Bitmap = img.GetThumbnailImage(250, 250, Nothing, System.IntPtr.Zero) img.Dispose() strm.Dispose() Next (1740ms) But with WPF this code is too slow : For Each path As String In System.IO.Directory.GetFiles("D:\Images\wall paper& ...Show All

• Visual Studio Express Editions How to transfer HBITMAP (C++) to Bitmap (C#) ?

  Dear Everyone, I have created the following codes to capture frame from a video using DirectShow in C++. It uses HBITMAP to hold the bitmap data. Now, I want to transfer the HBITMAP to C# Bitmap. How could I do Thank you. ====================== long size; hr = pDet->GetBitmapBits(1, &size, 0, width, height); printf("Size %i \n", size); if(SUCCEEDED(hr)){ char* pBuffer = new char[size]; if(!pBuffer) return E_OUTOFMEMORY; try{ hr = pDet->GetBitmapBits(1, 0, pBuffer, width, height); printf("pBuffer [%c] \n", pBuffer[3]); } catch(...){ delete[] pBuffer; throw; } if(SUCCEEDED(hr)){ BITMAPINFOHEADER *bmih = (BITMAPINFOHEADER*)pBuffer; HDC hdcDest = GetDC(0); void *pData = pBuffer + sizeof(BIT ...Show All

• SQL Server I can't connect to my local database.mdf file

  I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2. Now I can't connect to my local database.mdf file. When trying to open or doubleclick or expand my .mdf file the following message pops up: Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances. What is the solution for this problem Hi Andrea. I have entered your code in the query editor and saved it as SQLQuery5.sql. SQL server is restarted. I right clicked in the query editor and hit Execute and get the folloving error: Msg 233, Level 20, State 0, Line 0 A transport-level error has occurred when sending the request to the server. (provider: Shared ...Show All

• Visual C# How to check if an instance was created alrady.

  Hi, How to check if an instance was created already. Ex: If I create an instance and than i f I try to create another instance, it will check if it was created already than display an error message.   Thank you, It its question about single instance of any class within the application then use Singleton (creational) pattern, please refer the following links for the sample: http://msdn2.microsoft.com/en-us/library/ms998426.aspx http://msdn2.microsoft.com/en-us/library/ms998558.aspx If its single instance at application level means if you want your exe should run only as single instance and you want to restrict the user to open multiple same application, and if one application i ...Show All

• Smart Device Development HTTPS problems with .NETCF 2.0 SP 1

  Hi all, I am currently facing a severe problem with HTTPS posts in my application. My application connects to various banking servers (which are unfortunately outside of my control) posting transaction data transaction through a HTTPS POST. The application works fine at 5000+ customers who are using .NETCF 1.0 and the very same communication code also works fine on the desktop using .NET 1.1 or .NET 2.0. Since introduction of .NETCF 2.0 suddenly problems appeared and the application gets a System.Net.WebException when connecting to some (not all) servers. Thus I simply required my customers to install .NETCF 1.0 and included a config-file that restricted execution to .NETCF 1.0 SP2 or SP3. With .NETCF 2.0 SP1 things got much be ...Show All

• Visual Studio 2008 (Pre-release) Cider support for local assembly references?

  Am I doing something wrong Or do i possibly have an bad interaction between Cider and ReSharper (my guess). every time i make a reference to the local namespace in the same assembly... e.g. < Page x:Class = " MyNameSpace .TestPage " xmlns = http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x = http://schemas.microsoft.com/winfx/2006/xaml xmlns:local = " clr-namespace:MyNameSpace " Title = " TestPage " > < Page.Resources > < local:MyConverter x:Key = " myConverter " /> I end up getting all sorts of errors, even though it all compiles fine. In just the snippet i've pasted here, I get three errors: Assembly '' was not found. Th ...Show All