daphneDolphin's Q&A profile

• SQL Server Using stored procedure to read from ODBC ?

  Dear all, I am using SQL 2000 and would like to dynamically assign ODBC data source to transform data task. Do you have a stored procedure to perform read/write from/to ODBC data source I would like to input data source and table name. Thank you and Best regards, Chaivat Hello Jens, I tried to define link server using both sp_linkedserver and enterprise manager approach. It seems that I cannot add the ODBC datasource to Microsoft OLE DB provider for ODBC. My datasource is SAS and I have SAS ODBC driver which able to read/write in DTS. I also can read data from SAS to Excel using the same DSN. Do we have another way to code stored procedure that works like adding OD ...Show All

• SQL Server unable to load package

  I have created an SSIS package in BI dev studio which i can debug and run fine. I have saved the dtsx file to a production server which calls it using dtexec as part of a batch script (we are migrating from foxpro). I am getting the following error that i dont understand. I dont know if this is relevant but i cant execute packages by double clicking them as DTexecui is not installed (not sure why as i have installed the client tools and integration server). Hardware is Dell poweredge 2850 dual xeon 2gb ram with win 2k sp4 and sql 2005 sp1. Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:29:19 Error: 2006-07-06 12:29:20.75 Cod ...Show All

• Visual Studio Team System Solution File, file format changed

  It looks like the solution file format has changed from VS 2005 to VS 2005 Team Edition. This is despite that the format version is 9.00 in both versions. This is a rather big problem in our company because we're several developers working on the same solution. The solution file is under source control and changes ought to be merged between branches. This is, however, not feasible with this format change and a solution with 45 projects. Of course the best solution would be to use the same VS version. But what can we do until all have upgraded No No I haven't investigated if I need to do something that positively requires changing the solution file. However, when I save the solution file ...Show All

• Visual Basic Key short cut help

  Ok I know this is easy, but...... Sometimess when I open a project all of the code blocks are expanded. I have to go through and close them up clicking on the - sign. I have lookded around and don't see anyway to close them all at once. Is there a key short cut to close all of those open blocks Dave Try hitting Control+m, then Control+o to collapse methods to just their definitions. When it comes to finding other shortcuts, I'd take a look at this page . ...Show All

• Software Development for Windows Vista Outlook 2007 On Vista Crashes When Calendar Reminder Pops Up

  Hi, I'm not sure if this forum is the right place to be asking this question. However, two weeks ago I installed Windows Vista Ultimate and Office 2007 on my Dell laptop. Everything works fine, except Outlook 2007. Whan a calendar reminder pops up, Outlook 2007 crashes. Has anyone else seen this problem or know of a solution It is incredibly annoying! Thanks very much in advance, Mike Puddephat. Hello Mike Puddephat, I would recomend posting this question in the TechNet Office 2007 forums located here http://forums.microsoft.com/TechNet/default.aspx ForumGroupID=155&SiteID=17 as the MSDN forums are geared more towards developers. Thanks! Matthew Braun ...Show All

• Visual Studio IDE Menu Duplication

  I have just installed Visual Studio, and whenever I launch it, the menus and the items in them are duplicated. Another copy of them is made whenever I launch VS. Restarting my computer or VS doesn't fix the problem. Here is a screenshot: http://www.rightflux.com/menu_dupes.jpg I apologize if this is the wrong place to post this, let me know where it should go if this is incorrect. interesting! Have you tried to reset the IDE settings, just in case start > run > devenv /resetide This only works on the full version of Visual Studio, not the express editions ...Show All

• SQL Server Table transfer errors

  Hello, I am trying to transfer a database from one server to another using the Import Export wizard in SSIS and I am consistantly getting this error on 2 different tables so far. - Execute the transfer with the TransferProvider. (Error) Messages * ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (79)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider) This error message is beyond cryptic and when I click on the link it sends me to a web page the just tells me that there is no informat ...Show All

• Visual Studio Express Editions .vshost.exe wont stop restarting!

  I'm trying to debug my project and get an error that states: "The operation could not be completed.  The process cannot access the file because it is being used by another process."   To work around this I have to close my solution, but don't have to completely close EE C# and kill the XXXX.vshost.exe process in task manager.   Does anyone know what's wrong with my project and why it won't let me debug the app more than once The only thing I found was that if I checked all the checkboxes under Enable Debuggers, I was able to work without seeing the error. I am not sure what it does, but it did stop the unexpected exiting of the program. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Generate random numbers for every class instance

  I'm trying out some AI techniques but I'm having a problem generating a TRULY random number. I create 20 instances of an ant class that should move and change directions on a random basis. They are doing that, but all in unison instead of each changing directions at different times. Its like synchronized ants. Anyone know how to create a truly random number each time the ants use this method Random r = new Random (); if (r.Next(100) < 5) ant.Speed = new Microsoft.Xna.Framework. Vector3 (-ant.Speed.X, ant.Speed.Y, ant.Speed.Z); if (r.Next(500) < 2) ant.Speed = new Microsoft.Xna.Framework. Vector3 (ant.Speed.X, -ant.Speed.Y, ant.Speed.Z); George Clingerman wrote: You ...Show All

• Visual C++ console application entry point for al option main

  I have another post concerning how to embed an xml file in the assembly. But this question is deeper within. Thought a new post is warranted. I can not determine the proper /main option setting for my console test application. (I have tried a variety and looked at ILDasm to no avail: main, assembly.main, console.main among others) Can someone supply the correct option setting. E:\VS8\TestStuff>al debug\TestStuff.exe /embed:productlist.xml /out:jkj.exe /target:exe /main:main Microsoft (R) Assembly Linker version 8.00.50727.42 for Microsoft (R) Windows (R) .NET Framework version 2.0.50727 Copyright (C) Microsoft Corporation 2001-2003. All rights reserved. ALINK: warning AL1020: Ignoring included assembly 'e:\VS8\TestStuff ...Show All

• Visual Studio Team System override BuildDirectoryPath

  Is it possible to put a condition on the <BuildDirectoryPath> property and pass in a parameter from TFSBuild.rsp to set that condition i.e.: in TFSBuild.rsp: /p: BuildAgent=Buddy in TFSBuild.proj < BuildDirectoryPath Condition = " '$(BuildAgent)'=='Nightly' " > d:\Nightly </ BuildDirectoryPath > < BuildDirectoryPath Condition = " '$(BuildAgent)'=='Buddy' " > d:\Buddy </ BuildDirectoryPath > I know there is an opportunity to override this value when running a build from the GUI , but for my Buddy (CI) and Nightly Builds I will be executing builds by calling the BuildController service What I'm trying to avoid is having multiple build types for Buddy, Nightly and On D ...Show All

• Visual Studio Team System Storing Common Data Between Build Types

  Is there a good place to store common files that you want to share between build types so that Team Build will retrieve it automatically when a build is initiated Aaron, is there a workaround for your first bullet other than manually deploying to the teambuild server everytime you make a change to the common script ...Show All

• Visual Studio Team System Need help regarding Introspection engine's behaviour towards calling of overriding methods.

  I have created a custom rule in FxCop 1.35 where I m checking for the proper documentation of exceptions thrown from a method or methods called from the method being analyzed. I m analyzing the following code using this rule. /// <summary>  /// This class is a base class which we will  /// use to derive other classes from.  /// </summary>  public class BaseClass  {   /// <summary>   ///   /// </summary>   public virtual void TestMethod ()   {    throw new ArgumentNullException();   }  }  /// <summary>  /// This class is a derived class which overrides  /// base class method.  /// & ...Show All

• Visual Studio Error Crystal report for Visual Studio Professional 2005

  Please help me I have VS2005 and CR10.2. When run report return error: "the request could not be submitted for background processing crystal report viewer". Why Ty but i have the special version of Crystal Reports for with Visual Studio Professional 2005. i dont have CR XI. ...Show All

• SQL Server How to setup SQL auth. for SQLserver 2005 express?

  Hi, I can't seem to set up SQL server authentication for SQLserver 2005 Express edition.. I simply can't find the settings for that. I have Management Studio Express installed and I can see the SA user but I can't login using that user.. I know that there's supposed to be a setting for turning on SQL auth. but it's not like it used to be in Enterprise manager :) so I can't find it.. ;/ I couldn't find any documentation on how to do this so I thought I'll try here.. (I need SQL auth for my project :) - it must be done with that..) Thanks in advance, ZenX Hi, have a look in on my site in the Screencast section, there is a detailed Screencast for this which will show you the steps. HTH, jens Su ...Show All