Alexx4's Q&A profile

• SQL Server June CTP - Passing NULL value to a Sub-Report Parameter

  Passing NULL value to a Sub-Report Parameter fails with this message - "A parameter or data source credential is missing a value.  Prompting for this value has been disabled.  Supply a value or enable prompting." Anyone else seen this Thanks Paas the parameter to subreport . Syntax is paramField.ReportName="Transferee"; paramField--> ParameterField Transferee--> Sub report name Total Syntax is paramField = new ParameterField(); discreteVal= new ParameterDiscreteValue(); paramField.ParameterFieldName = "@CustId"; discreteVal.Value = 2463; ...Show All

• Windows Forms Imitate ShowDialog / modal form without blocking on the call

  Hi! I would like to show my form in a similar way to ShowDialog, so it will always have focus and prevent selecting of any other form in application, but without blocking on the ShowDialog call. Is there any way to just call Show() and then make the form modal I need this because I have created a user interface "flow", where during background work some status form is opened and after the task finishes, status form closes and result form appears. Both of them should be modal and they should switch from one to another without interaction with code, which created the initial status form. I tried following approaches: set MainForm's ...Show All

• Visual C++ linking problems (invalid or corrupt file)

  Hello experts! I was testing compilation programs with dlls. So I have created simple dll with header: int sum(int size) { return size*2; } And I have compiled it. I have also created simple console application using this library. In project options I have added headers path and libs path, but I have linking errors: Linking... C:\Documents and Settings\Jacek\Moje dokumenty\Visual Studio 2005\Projects\mylib\release\mylib.dll : fatal error LNK1107: invalid or corrupt file: cannot read at 0x278 Please help, I don't understand this error and I don't know what to do. Greetings Are you using Visual C++ 2003 or ...Show All

• Windows Forms AddHandler

  Hi everyone, can you explain to me what does AddHandler do I mean where it should be used and what it really do, i am reading some explanation over the web about AddHandler but I didn't understand it . Thanks. Yeah, "BillingItems" popped into my head. and probably isn't the simplest example! Let's go back to forms and controls. If you create a simple windows form, drag a button onto it, double click the button, you get the method i described earlier. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub This is the ...Show All

• Visual Studio Express Editions Nested Loops In OOP

  Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim a, b, c As Integer For a = 0 To 1 For b = 0 To 1 For c = 0 To 1 MsgBox( "Fish" ) Next MsgBox( "Dog" ) Next MsgBox( "Cat" ) Next End Sub I Started VBE in Nov/05..... My first OOP Language... I am having extreme Difficulty in Learning OOP.... Would someone please Translate these Procedural Nested Loops in the Button to Pure OOP..... Thanks I don't know what you want to do, but this is just a nested loop. This can't be created otherwise, t ...Show All

• Visual Studio Team System Creation of AreaRootNode/IterationRootNode

  Hi, I am trying to create AreaPath nodes through OM API. I can use CommonStructureService.CreateNode method to do it. The question is: how I can create root node What should I supply as parentUri to CreateNode for root nodes Or may be there is other special function to do it Thanks, Leon Hi Allen, I understand that. What I meant was "How I can create node located directly under Area or Iteration ". What would be its parent URI ...Show All

• SQL Server Watching an incoming directory for files to process

  Here's the senario:  We have 3000 stores each sending detail sales data polling files to our FTP site. Most of these files arrive between 10 pm and 4:00 am, with stragglers coming in all day.  We receive several different files from each store, containing different types of data (payroll, order header, order detail etc...).  Detail files could be up to 5000 rows per store. We have built several test SSIS packages that will process these files using multiple flat file connectors to load each file thru to one or more destination tables in our data warehouse.   My question:  What is the best way to execute the ...Show All

• SQL Server Error 87 while installing SQL Server 2005

  Hi everyone! I'm not sure if this is an old issue, but I couldn't find it in any thread. Here I go: I downloaded SQL Server 2005 Enterprise Edition from the MSDN site; but when I run the installation wizard I get this error: Errors occurred during the installation Error 87 installing .NET Framework 2.0 The parameter is incorrect And then I have to cancel the installation. This machine meets the hardware requirements, and it already has the .NET framework 2.0 installed. Humm, what else It's a Windows 2003 Server SP1 machine...let me know if you need more information. I've been trying to figure out a solution, but I finall ...Show All

• SQL Server "Bad Request" error

  Hi, I've installed Reporting Services and configured it without any problem. When I browse to http://x.x.x.x/reports I'm getting " Bad Request " error. Is it related somehow to the IP mapping issue Any other clues Thanks, Mark ps SQL 2005 RTM W2K3 Std If you want to run Reporting Services under a different port than normal, you have to change these two config files: rsreportserver.config and RSWebApplication.config Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot> The result is then <Co ...Show All

• SQL Server Problems Creating a Full-Text Catalog

  When I attempt to create a full-text catalog on a database, I receive the following error: Create failed for FullTextCatalog 'AccountNotes'. (Microsoft.SqlServer.Smo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service. (Microsoft SQL Server, Error: 9955) --------------------------- ...Show All

• Visual Studio Express Editions Package and Deployment problem

  Dear Guys,     I am a new VB Programmer. I have developed a saimple database application using some activeX controls. Now I want to distribute my application to some of clients or friends who don't have Visual Basic or other activeX control files are not installed. So I went through Package and Deployment tool and Build a setup file for installation. I am using Windows Xp platform to package the application. Now when I run the setup file on my friends computer on which windows 98 is installed it doesn't. I says "Some of the files on your system are outdated. You need to restart to update the files. Do you want to restart the c ...Show All

• SQL Server Combining text data rows

  I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I combine the rows with the same DocumentID into a single row of text data This will put the entire text content of each document in its own row. TEXT001 table as it is Documen ...Show All

• Visual Basic How To: Implement a Form class with overloaded shared methods and how to destroy it once the calling method has finished.

  Overview: I am writing applications that drive manufacturing automation equipment such as those found on an assembly line. (Robot Welders etc…)   The operators and technicians use touch screens monitors to interact with the system (Human Machine Interface (HMI) or Graphical User Interface (GUI) to put it into Windows development terms.   No keyboard or Mouse is available to them.     Problem: The standard MsgBox and System.Windows.Forms.MessageBox do not work well in this application because the buttons are small which makes it hard for them to click on.   Solution: I would like to write a ...Show All

• .NET Development WSE3 : Is MTOM supposed to work?

  According to the quick start info: All you do is write the service and then simply indicate that this service supports MTOM encoding in the application's configuration file. Any byte[] types returned from the service are then MTOM-automatically encoded. I have the quickstarts and have tried writing my own webmethods that return byte arrays.  I used the WSE Settings 3.0 menu to enable MTOM for both the client and the service, but when I view the transmission with TCPTrace I am not getting any special encoding.  My byte array is a base64 encoded soap message just like it was without WSE3.0 Any thoughts MikeH ...Show All

• SQL Server Programmatically loop over variables in the variable dispenser?

  In my custom task, I would like to loop over the variables in the variable dispenser, and only modify those that are of a certain type. Is this possible Thanks! I think you can use Me.variables(x).getType to get the type of each variable. If that is not correct, you can define variables name sXXX for string, iXXX for integer, etc. Then parse the variable name, get the first character and determine the variable type. ...Show All