ShurikAg's Q&A profile

• SQL Server DataReader output column length

  Hello, I have an ODBC connection manager to a Progress database. In that database there is a column declared as a string of 10 characters long. However, some data in this column is actually up to 15 characters long. This makes my DataReader Source fail everytime I try to run my package because it sets the output column like this : Datatype : Unicode string [DT_WSTR] Length : 10 Is there any way to solve this without changing the datatype in the Progress database (that is beyond my control) tanks in advance ... renyx wrote: In that database there is a column declared as a string of 10 characters long. However, some data in this column is actually up to 15 characters long. T ...Show All

• Visual Studio Team System Test Director Defect Mapping to VSTS Work Item

  We need to be able to map Mercury Test Director defects into VSTS Work Items for developers to work...has anyone written a custom conversion utility We have implemented 1-way synchronizer from TD/QC to VSTS which could pretty easily be converted into 2-way. Was not that hard and we will probably turn this into small utility for others as well. ...Show All

• Visual Studio 2008 (Pre-release) Problem building a WPF (WinFX) project with MSBuild.

  Hi, I thought I should report a very strange problem that I encountered using MSBuild on a WinFX (WPF) project. Maybe someone else has encountered the same problem... The project works perfectly fine when building it in Visual Studio 2005 with Orcas extensions, but when building it with MSBuild for the command line the following error occurs: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.WinFX.targets(236,9): error MC1000: Unknown build error, 'API restriction: The assembly 'file:///C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.XML.dll' has already loaded from a different location. It cannot be loaded from a new location within the same appdomain.' Done building project "Editor.csproj" -- FAILED. The problem was ...Show All

• Visual Studio Express Editions Updates to VBEE?

  Are any updates (hotfixes, Service Packs, new features) planned for Visual Basic Express Edition A service pack for VB 2005 is in the works but no firm dates on when this will arrive yet. Always Community Technology Previews (CTP) for new features such as LINQ  Are you experiencing any specific issues or is this just general enquiring.   ...Show All

• SQL Server Tutorial Error

  Guys, I am working on SQL Server 2005 and I am working through the tutorial. In lesson 6 we build calculations, and then use the product category hierarchy to view them. At this point I discovered that if I select a single product sub-category (eg mountain bikes) I get an error along the lines of "Error opening file;\\ \c\program files\microsoft sql server\mssql 2\olpa\data\analysis services tutorial 0.db\product.19.dim\20 product subcategory key.fact.data is not a disk file or is not accessible" Selecting more than one subcategory works fine. Can anyone please shed some light on this behaviour. Thanks Cliff Hi Thomas, Thanks for your reply. I looked at your thread but my ...Show All

• .NET Development Connecting to Access Database

  Does anyone know how to connect to a access database using vb.net I created the database in access and added the Odbcdataadapter and was able to preview the contents of the database. I have a text box with a next button and a new button. Each time I click next i want to see the names that i have in the database appear. When i click new i want to be able to enter a new name in the textbox and it gets written to the database i already have with the names. Any thoughts Thanks!! I am new to connecting to database in VB. Does anyone have a simple code to show me how to use the odbcdataadapter and the odbcconnection, there was also mention about datagridview. I have know idea how that works. I have made a few ...Show All

• Visual Studio Team System What is CA2209 and how to fix it?

  Hi folks, my code analysis says:- Warning 5 CA2209 : Microsoft.Usage : No valid permission requests were found for assembly 'Foo.Bar'. You should always specify the minimum security permissions using SecurityAction.RequestMinimum. Hmm. Ok. I've read the help and it explains the cause and how to resolve it. Unfortunately, i don't understand what it really means. So i need to provide some code that describes some permission about my assembly dll. I'm assuming this is for some security stuff. Ok... but i'm just doing some boring old website code and i have never had to think about someone trying to get access to the fileserver via the code or whatnot. Ok, so now could be a good time .. but i still don't understand what the three opt ...Show All

• Visual Studio crystal reports 9.x compatibilty with Windows Vista

  Unable to gauge out whether Crystal Report 9.x is reqd as minimum or absolute in Windows Vista if not then which version is required as minimum and/or absolute in Vista Thanks and Regards Luv Walia Hi, I tried to install CR9 on a fresh Windows Vista Ultimate installation (retail version, downloaded from msdn). The main, standalone application works fine, but the report designer component hangs in vb6. I tried everything that came in my mind: reinstalling it a few times, with administrator priviledges on and off, enabling and disabling uac, manually registering dlls, ... No way, when you try to insert a report in vb6, the first dialog is shown, letting you choose as usual between a wizard, a bl ...Show All

• Visual C# How to use DllImport with c++ functions that take a function pointer as an argument?

  I'm trying to understand how dll importing in c# works. I've managed to get it working for function F1 shown below, however I want to extend this to a function of type F2, which takes a function pointer as an argument I've look at the example on MSDN, but it is too dissimilar from what i am trying to do and I don't really understand it. Can someone tell me the c# code that will enable me to import the function F2 into my c# program, or point me to a a more basic tutorial than the MSDN help site, because I really didn't find it useful in helping me solve this particular problem. This is the .cpp file that i compile into a dll which my c# program then uses. I have successfully imported F1, but all attempts to import F2 have failed... extern ...Show All

• SQL Server Joined view does not contain all colums

  The joined view is named "dbo.viewExecView" and is like: SELECT Bank_No, data_center FROM [ALPHA\SQL2000].ev_db.dbo.Bank The new view that joins to the above view is like: SELECT bank.BankID, evBank.data_center AS DataCenterID FROM dbo.Bank AS bank INNER JOIN dbo.viewExecView_Bank AS evBank ON bank.BankID = evBank.BankID WHERE (bank.InactiveDate IS NULL) Note: The data_center column (an int) was recently added to the Bank table in the linked ev_db database and it shows up there. It also shows up in the view "dbo.viewExecView". It does not appear in the new view that joins to "dbo.viewExecView". And when I run the 'new' view, I get an Error Message: Invalid column name 'data ...Show All

• Visual Studio Team System Is Microsoft.Cci.dll redistributable?

  I'm writing a standards-checking program which primarily parses C# source code (using the NRefactory library from SharpDevelop), and I sometimes need to relate the information in the source code to the compiled code in the resulting assembly. I'm currently using regular-old reflection to do this, but I've been poking around with the Microsoft.Cci dll from FxCop 1.35, and it's really nice. I'd like to use it in my app, and I was just wondering whether I'm actually allowed to do that. The license at http://www.gotdotnet.com/team/fxcop/Misc/eula.htm  specifically says the component parts may not be separated for use by more than one user.  I would say no, you can't redistribute. ...Show All

• Windows Forms How to make pie chart clickable using 2005 visual studio.

  Hi, I have a requirment to make pie chart region clickable..If I click on any region it should go to other report with parameter. Can any one please give me an idea Thanks in advance. Thanks, Viru Thanks for your answer. I am using 2005 .NET Vistual Studio report designer. Can we write event handler in this designer I am not using any programming langauge to display report. I am directly publishing this report to reporting server. Thanks in advance. Viru ...Show All

• SQL Server Report Builder error.

  Hi, I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this Hi ! Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns. The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k! I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the ...Show All

• Windows Forms datagrid troubles with stored procedure (vs 2003)

  I have the following code: Dim daGrid1 As New SqlDataAdapter(Me.SqlCommand1) (a stored proc) Dim dsGrid1 As New DataSet dsGrid1.Clear() daGrid1.Fill(dsGrid1, "top") DataGrid1.DataSource = dsGrid1.Tables("top").DefaultView I set the command to a stored proce and fill a dataset, then set the datagrid1 to the dataset table. I can then see the data grid on the form filled out. I need to change the column headings, hide some columns, then click on a row, and get the hidden field and pass it on to another form. I thought I would need a table style for that. But when I try to add one, I get: "The data grid table styles collection already contains a table style with the same mapping name." ...Show All

• SQL Server Interlektual property

  Hello all, How do I protect my Interlektual property for a BI solution ( analysis services) I do not want others to be able to view and change my coding Thanks heaps for any advise. To deny others to see definition of your database, you should only grant Read rights to your users. Others can copy your design if given Admin rights to your database or ReadDefinition rights. Create a role in your database and grant Read permissions to your users. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All