Vik B's Q&A profile

• SQL Server Execute package via a web application failing

  I have created a web interface for an ETL.  The SSIS packages run via the GUI package utility and the command line; however, they fail miserably via the web application.  The web app discovers the package without a problem, as I can view various properties of the package within the web app.  However, when I call execute and step through the code a DtsError is returned referencing "System.__ComObject".  Any ideas string pkgLocation; Package pkg = new Package (); Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); DTSExecResult pkgResults; IDTSEvents dtsEv ...Show All

• SQL Server MSDE -> Express Upgrade problem.

  Hello! I'm trying to upgrade old MSDE instances to SQL Server 2005 Express SP1. The following command fails: SQLEXPR.EXE /qb UPGRADE=SQL_Engine INSTANCENAME=XXX ADDLOCAL=Client_Components,Connectivity because the domain\x user cannot login. We have disabled Windows authentication. Is there a way to supply the SA login instead of a domain user Problem no #2: After upgrading with Windows Authentication turned on, current SQL users cannot login (sa). Is Mixed authentication mode turned off during upgrade Or what else could be the problem Our application is distributed around Europe. We have no control over our customers security ...Show All

• Visual Studio Search Returns 0 results

  Hi, I tried searching for a keyword in the Documentation. There was no results found. But when I Tried Typing it in the Index Tab I could clearly see it... Is this a known Bug BTW, Im using VC++ Express Beta 2 Note: no filters are active during the search... cheers, Paul June A. Domag Hi Paul, MSDN and MSDN Express Libraries do indeed use a stoplist to weed out common words from search results. This wouldn't explain the bad results from the term 'RaftingContainer' as it would have been treated as one word, and it's not on the stoplist. Since I am not sure what previous term you were searching for I can't say for certain ...Show All

• Visual Studio Express Editions RGB Problems

  First let me outline the problem I'm having. I want to be able to draw a line on my screen, and specify the RGB color of the line. But the RGB function returns an integer, not a colour. And I can't find a conversion function. Can anyone help ...Show All

• Visual Studio Express Editions Order Tables Ascending in DataSet

  Hey there, I have a problem cause I don't know how to order tables ascending within a dataset, so I need to know how can I do that, I have for example these tablenames within a dataset in this order: "0050Colors" "0021Cars" "0120Symbols" "1008Field" "0215Country" that's the order in what the tables are added into the dataset, and I need them in the next order: "0021Cars" "0050Colors" "0120Symbols" "0215Country" "1008Field" So what would be the code, to order the tables in that way, please help, thanks!!!. ...Show All

• SQL Server AS 2005 Business Intelligence Wizard scripts

  In Analysis Services 2005, using the Business Intelligence Wizard in the BI Development Studio to add time calculations to a cube worked fine when only base measures are included in the scope.   When a calculated measure is added to the scope of the Business Intelligence Wizard time calculation, all that is returned for the Business Intelligence Wizard time calculation value is “NA”.   What could be the problem/how can I make this work correctly   The exact same time calculation was being created by the Business Intelligence Wizard - the only difference was adding one calculated measure to the scope.  Could this have an ...Show All

• SQL Server No ODBC Data Source?

  Hi! I'm trying to add a new data source from an ODBC data source in Visual C++ 2005 (express edition), but in the database explorer, when I click on "Add connection...", I can only choose between "Microsft Access Database File" and "Microsoft SQL Server Database File". Where's "Microsoft ODBC Data Source" Is this a "Express Edition" limitation Or am I doing something wrong My ODBC data source seems to be well configured. Thank for the answers. Helmut. I don't know whether it is a limitation or a bug. In the same machine, I can see ODBC data source in Visual Stduio, but not in Visual C++. Tha ...Show All

• Visual Studio Team System How to debug FxCop custom rules?

  How to debug FxCop custom rules code Thanks in advance, Grace Excellent.   My first try did not copy pdb file to FxCop.exe "Rules Directory" thus failed. After copied it, it works. ...Show All

• Visual FoxPro Which is best?

  Which is better I am thinking mainly in terms of maintainability and readability, perhaps even performance issues. This way  *-- Check overridding the bank account is even allowed If This.lBankAssigned     *-- Bank Account has already been assigned by TCustomer.NewReceipt()     If Empty(This.oCustomer.oProfile.cNominalBankAccount)         *-- Check sales parameters for override setting         If NOT This.oCompany.oSalesParameters.lOverrideBankAccount             ...Show All

• Visual Studio Team System Static Analyzer reports leaking memory in atldbcli.h, is there a workaround?

  When I run the VC 2005 static analyzer in release mode with ATLdbcli.h included I get the following warning: c :\program files\microsoft visual studio 8\vc\atlmfc\include\atldbcli.h(4095) : warning C6211: Leaking memory 'pBinding' due to an exception. Consider using a local catch block to clean up memory: Lines: 4066, 4067, 4068, 4069, 4072, 4073, 4074, 4078, 4092, 4094, 4095 C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\atldbcli.h(4065) : while compiling class template member function 'HRESULT ATL::CDynamicStringAccessorT<BaseType,OleDbType>::BindColumns(IUnknown *) throw()' with [ BaseType=WCHAR ...Show All

• Visual C# authentication

  hi,    i don't know if this is the right forum for my problem.     i am making a web form(authentication). In my front.aspx i have 2 textboxes which ask for username and password. i also have a button(Login).  if the user presses the button it will go to a page login.aspx. however, i am having difficulty passing the data from two textboxes to another page since in my login.aspx it will validate the username and password. front.aspx private void btnlogin_Click( object sender, System.EventArgs e) { if (txtbox1.Text=="" || txtbox2.Text=="") { Response.Write("<script language='JavaScript'> alert('Fill d ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using Hardware with DirectX

  This is a bit of a sticky one and I don't know how this happened. I recently upgraded my DirectX SDK to the Dec 2005 release. Prior to this the samples and other applicatons that I have compiled ran very fast and were using my hardwares capabilities. I have a 64MB NVIDIA GeForce2 MX. After the upgrade the samples want to switch into Reference. And of course everything runs slow. I have search all around the web and other forums for similar problems and I find nothing. Has anyone seen any similar problems or is there a setting in DirectX someone could point me at I have looked closely at the Direct3D settings in the control pannel and ...Show All

• Software Development for Windows Vista No Templates

  Hi, After installing and reinstalling the VS extensions for WF (long with the latest beta 2) I do not get the templates for workflows when adding items to my projects. The weird thing is, a colleague created a project on his machine (where it is working OK with an earlier beta) and then gave me a copy of the project. If I right-click that project I do get the templates. But only for that project. As soon as I try my own, it doesn't work. Any thoughts Thanks, Kent That didn't fix it, but thanks for the info. To circumvent the issue (for now) I copied my colleague's VS project and added it to my s ...Show All

• Visual Studio Opening mscorlib sources in editor

  Hi! In my add-in I'm trying to open source files of classes in editor. It works well with classes inside projects, but I don't know working meth to open any system class (e.g. System.String). I tried to to get CodeType object for this class - it works, but exception occurs while getting Start/End Point or ProjectItem. Maybe someone knows rigth desicion VS is using sources generated from metadata - is there any way to obtain such sources without metadata parsing Thnx. The C# project system will generate this data on the fly, and there is no programmatic access to do this yourself. If you wish to do this, yo ...Show All

• Visual Studio Tools for Office Why VSTO doesnt work on WinXp and it does work on Win2k?

  This is on open question  So any ideas are welcome in order to get a VSTO solution working in WinXp that works on Win2k. 100% sure it has to do with the dlls, but which ones and can they be updated manually   The two main errors HRESULT x800A03EC or  COM object that has been separated from its underlying RCW cannot be used Sorry, I don't know how to get them. As the article says, they're only available for English versions of Office and you have to have a volume license agreement or something similar. Perhaps you coul ...Show All