macyp's Q&A profile

• SQL Server Configuration File not always used

  I have a simple SSIS package (stored in the file system) that gets a file path from a configuration file. The configuration type is an indirect XML configuration file that uses an environment variable to store the location of the configuration file. When I run the package using dtexecui, or just dtexec from a command line, the package successfully picks up the file path from the configuration file (for verification I am writing out the variable containing the path to the log file). However when I run the package from a SQL Agent job it appears that the configuration file is not being used (the path is set to the same dummy path that I used during development). I have tried running the job as both a CmdExec and an Integrati ...Show All

• Visual Studio Uninstall framework 1.1 from windows 2003 server and install v.2

  I am using Microsoft windows 2003 server standard Edition with service pack 1. I wanted to use framework version 2. I have unistalled framework 1.1 using control panel -> Add and Remove and then I installed framework version 2, which was installed successfully. After that I noticed that framework 1.1 was still in my computer. I can't see framework 1.1 in control panel -> add and remove list but it is in Adminstrative Tools menu, which also has Framework v.2. So is there anyone who help me to remove/uninstall framework 1.1 becuase i want to use only framework v.2 The 1.1 Framework is a system component on your operating system. You shouldn't have to remove it as it works side by side with the 2.0 framework. ...Show All

• Visual Studio Team System Environment variables passed through nunit tests from msbuild

  I have a team build on VS2005 which is set up to run NUnit unit tests as part of the build. The code that is being unit tested integrates with some legacy COM code which in turn calls external processes to do the required task. When I run a build from the command prompt using msbuild on TFSBuild.proj on either a development PC or the build sever using @TFSBUILD.rsp, my build works properly. The system environment variables are passed down thouugh the various processes and work as expected. However when the same TFSBuild.proj is called from the tfsbuildservice.exe service, the environment variables are not set properly. They are available in the MSBuild file but not in the processes that are created. What environment does the ...Show All

• SQL Server Problem using an AXIS Webservice

  Helo: I am trying to use an axis webservice as a datasource to a report. I have an error : Failed to prepare web request for the specified URL When I run the query in query designer. I test the webservice in a windows aplication and works fine. I think that the problem I have is with the target namespace/url   I am using the folowing data in the report: datasource conection string: http://191.158.134.200:8080/CatalogWS/services/CatalogWebService dataset query: <Query>    <Method Namespace="urn:CatalogWebService" Name="findArticulos"/>    <SoapAction>urn:CatalogWebService/findArticulos</SoapAction> </Query>   And here is a ...Show All

• Windows Forms Problem with Visual Inheritance when i change the size of the Father form

  Hello I have a form called FormMain - this form has controls on it (some are windows controls and other are infragistics controls) I changed the private void InitializeComponent() of the FormMain to public void InitializeComponent() in addition, i changed the decleration of the controls on the form from private to public Naturally i have done all this so i could inherit from FormMain (i know that i should have changed these to protected rather then public but when i change it to protected it doesnt work , found there's a bug on this) On any case, in my formMain i adjusted the size of the controls in the designer the way i wanted them Now i created another form called FormMainTester which inherits from formMain, the pro ...Show All

• Visual Basic Passing a Byte Array to a COM object expecting a variant

  I'm trying to pass a byte array to a COM object, SHDocVw.dll, which expects a variant variable. VB.NET won't let me do this. I understand that the variant type is no longer supported in VB.NET, and I have come accross several references to marshaling, but none that make any sense to me. Anyone have any ideas [my appologies, but as this is an urgent issue for my project, I posted this issue (sort of) on another thread with a subject meant to attract a different knowledge base - sorry for the duplication] Are you now getting the POST information on the web page If not, then take a look at the dissasembly (IL using ildasm) for the Navigate method and send me the declaration. "FName%3dJoh ...Show All

• Windows Forms Docking strangeness

  Hi, I have a form with one panel containing a label and combobox, and a third-party grid. The grid should fill all the available form apart from the panel at the top with the combobox. But for some reason no docking style combinations seem to support this. pnl.Dock=DockStyle.Top, 3rdGrid.Dock=DockStyle.Bottom / Fill, setting the 3rdGrid's location just beneath the panel etc... Nothing seems to work as expected. Anyone any pointers Hi, Thanks, but just to be clear, I want something like this:- Label---Combobox---------------------------------------------------------- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | | | \/ so the label and combobox occupies one virtual line of the form, a ...Show All

• .NET Development winxp service in c#

  services are suppose to run before a user logs in right   i have a tcplistener socket that is suppose to accept incoming connections, the computer could have a wired or wireless nic.  what service should mine depend on so that network connectivity is available if either of the nics are used   i do not want to depend on the "wireless zero configuration" service on the wireless nics and something else entirely on the wired nics, something universal is what i am looking for.  what am i missing that will make my service work   here is my configuration code in c# [ RunInstaller ( true )]     public class ClientInstaller : Installer     {      &nbs ...Show All

• Visual Basic StreamWriter Problems

  Cant quite work this one out.... All I am trying to do is read all the data from a file (while locking any other access to it), amend the data thats currently saved and then write the amended text back out to the original file. The odd problem I'm getting is that when I write the text back out again, it doesn't write all the text I've given it. When I check the value of sb.ToString at the point where the streamwriter writes it to the file stream, the stringbuilder returns all the text correctly but the streamwriter doesn't write all this text out again. Anyone got any ideas If File.Exists(objErrorLog.FilePath) Then Dim str As String = "" Dim intTrys As Integer = 0 ' Try and gain read writ ...Show All

• Software Development for Windows Vista Custom Perisistence: There can only be one service of type "WorkflowPersistenceService"

  I initially created a simple ASP.NET app to demonstrate a state machine and passing data to a workflow using a local service. It works fines. Now I am trying to play with persistence. I have created a custom persistence service using MySQL. I have followed the steps outlined in the SDK help. I have added the needed entries in the web.config line. Here is my Global.asax entries. protected void Application_Start(object sender, EventArgs e) { System.Workflow.Runtime.WorkflowRuntime workflowRuntime = new System.Workflow.Runtime.WorkflowRuntime("WorkflowRuntime"); Application[Constants.WorkflowRuntime] = workflowRuntime; // attach persistence service MySqlPersistenceService stateservice = new M ...Show All

• Silverlight (formerly WPF/E) Trouble with install: no mime-type association

  I installed the first CTP release on two Windows XP machines running IE7 and Firefox 1.5. In both cases, the plugin doesn't seem to be properly registered with the browser. The page that includes XAML still asks me to install WPF/E after reloading it or even restarting the browser. Any tips Thanks, Julien My bad. I installed the SDK, instead of the normal package. I incorrectly assumed that the SDK included the normal install as well. Cheers, Julien ...Show All

• Visual FoxPro Change tooltips when Hovering over a grid cell.

  I am not sure if this is possible: I need to implement something like the new memo field content preview (When you hover over a memo field of a grid, it will show its content in a tooltip style). I need to show some additional info about a customer when the user is hovering over the account # in the grid. I have tried to manipulate the tooltip of the textbox, or the tooltip of the column at run time and it didn't work for me. Is this possible I'd rather not use a click or doubleclick to open a form, but rather hover over a cell in a grid. Thanks. Cetin; I'm looking for any kind of solution. If you are aware of a better solution using hover over the grid cell, I would gladly t ...Show All

• SQL Server Long time SSIS package loading

  I load SSIS package using following code: Application app = new Application (); Package pac = app.LoadFromSqlServer( packageName , serverName , null , null , null ); For simple package containing 2 tasks this code executes about 20 seconds. If I load old version (SQL2K) package from SQL2000 then it takes 5 seconds. Is any way to increase loading speed for SSIS packages Much of the time on the initial load of the package is due to validation of the metadata of each of your tasks. In order to speed of the initial load, you could change the DelayValidation property of your package and all tasks to true. However, that's not really best practices. ...Show All

• SQL Server Error: Server Error in '/ReportServer' Application.

  I get the following error when going to http://localhost/reportserver, I did try what it recommended but it did't work. Error: Failed to access IIS metabase. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase. The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/ kbid=267904 . Source Error: An unhandled exception was g ...Show All

• Visual Studio Express Editions I need some help creating a simple dll

  Yes, the good old dlls. I have tried some examples and read topics but I can never get the dll to work. I just want to try something simple. I have a form with 3 textboxes and a button. Once I click the button textboxes 1 and 2 have their strings added and inserted into textbox 3. My dll simple adds the two strings. Can any one point me in the right direction Thank you, Wellnow Yeah I can create Classes and Application. Oh hey, wadda ya know ! That worked nicely! Actually I has to change the Function to Shared Function though but it works! Thank you ahmedilyas! ...Show All