ivanchain's Q&A profile

• Visual Studio Team System Data Generation - Unable to bypass circular references

  I'm trying to create a generation plan for my database but keep hitting the problem of "Table <x>: The Data Generation plan contains a circular reference. Population cannot continue". Note that I didn't design this database There are two tables, Survey and Property. Survey is many-to-one related to Property, and so has a foreign key of the PropertyId On Property there is a column called SurveyToUse which is a foreign key to Survey. Apparently there is nothing I can do to avoid the error. In theory, I should be able to deselect generation of the SurveyToUse column in Property (it's nullable), which will avoid the circular reference. Sadly this doesn't work. Is there anything I can do to get around ...Show All

• Visual Studio 2008 (Pre-release) need tips : translating xaml to c#

  Hi guys. are there any good guidance on converting xaml to c# actually, what i wanted is to understand xaml from coding perspective. thanks. yup. that answered it. funny though i miss that. probably it was already in windows vista sdk doc. thank you very much. ...Show All

• Windows Forms datagridview cell focus and reset datagridview

  Hi, How do I do to the "cell focus" don’t pass to the next row when I press <enter> in a unbound datagrindview Insert or edit row I would like that "cell focus" stay on the same row that I Insert or Edit ! and... How I reset the unbound DatagridView I have a "New Button" on my form and I need to clean the datagridview, but I don’t know how do that Thanks ...Show All

• SQL Server Pausing Log Shipping Plans

  We are doing an IP Restructuring on our DR site over the weekend due to some business and management requirements.I actually have 2 questions. I have implemented log shipping plans for our databases. Which means I will have to pause (disable) my log shipping plans while this is being done and resume (re-enable) after everything is comlete. Any insights on what else I need to do apart from these My second question is this. I am generating transaction log backups every 15 minutes and is averaging at 350MB (this much data every 15 minutes - not to mention that I've got around 40+ databases, all configured for log shipping just for this instance alone). My alert threshold is 45 minutes. My log shipping plan for one database starts failing pr ...Show All

• SQL Server Using a XMLA query to generate reports

  hi, I am trying to join a cube that is deployed to XMLA using Deployment Wizard  with  a report template i created using reporting services  2005 but could not figure how to join the XMLA query (SSMS 2005) of a cube and the report template  (SSRS 2005) made. I am hoping the readers could provide some info or some link to where the procedure is explained return xmlns="urn:schemas-microsoft-com:xml-analysis">   <results xmlns=" http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults ">     <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />     <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />   ...Show All

• .NET Development Oracle9i, TransactionScope and .NET 2.0

  Hello, I've got an issue that I've been unable to resolve. I'm using Oracle 9i and .NET 2.0. Here's my problem... When I perform this sequence of code... using ( TransactionScope scope = new TransactionScope ( TransactionScopeOption .Required)) { //Open connection, do db stuff, etc. } I open the connection using the System.Data.Common.DbConnection.Open() method. When that method executes, I get the following error: System.DllNotFoundException: Unable to load DLL 'oramts.dll' I do not have ODP.NET installed at this time. My question is...what version of ODP.NET do I need to install in order get the .dll that .NET 2.0 requires Thanks, James See if the follo ...Show All

• SharePoint Products and Technologies Integration of web app to Sharepoint Portal 2007

  Hi, I am wondering if it is possible to integrate an existing web application into Microsoft Sharepoint Portal. The application could be in the form of an opensource cms or web digital assets management (images/documents/videos) application in J2EE, php running Oracle/MySQL. If yes, what are the factors that have to be considered How can i do it Any links, resources would be great. If not possible, pls explain as well. Thanks a million! Hi, What are the things you need to know about the existing application How would the migration be done Is there some kind of generic template or wizard that facilitates this Wud appreciate if i could be pointed to the right direction in this. Thanks ...Show All

• SQL Server DTEXEC /SET

  Hello, I have a command line as following, with DTEXEC to launch the execution of a package and to set a value (13335) of an user variable called CIB (string type): dtexec /f c:\temp\PackageInsert.dtsx /set \Package\DataFlowTask.Variables[Utilisateur::CIB].Properties[Value];13335 But I have got an error message saying that the object is not known in the package. My variable does exist in the variable window of the dataflow part. Thank you for telling me what to set so that the variable can be set by the command line. Regards, Marie-Therese I suspect the problem is the path in the set statement, check that the variable is scoped to the data flow task and notthe package for example. To help find the correct path, use the configurati ...Show All

• Visual Basic Vb.net, local and remote server

  Hi, I'm a newbie. I created an application using vb 2005 and SQL 2005. In this application I have windows forms that manipulate data on a local sql server. May I use this application to work with a data base that is located on a remote server over the net Thanks One of the sites that I find handy is www.connectionstrings.com . On this site you will find what you are looking for. ...Show All

• Software Development for Windows Vista Setting DesignMode to True

  Hi. Is there a way to set the DesignMode property returned on WorkflowInstance.GetWorkflowDefinition to "true" I'm trying to load that activity on a designer, but it doesn't let me do it because of that property... What I'm trying to achieve is to use the WorkflowMonitor from the my CustomPersistenceService, and not from the TrackingService. Thanks in advance. ...Show All

• SQL Server Access SQL Server Reporting Server WebService using ip address

  Hi, I have a report server and I am trying to access the Reporting Server Web service API from a Web Server. When I call the web service using its IP address I get an access denied error but it works just fine if I call it with the server name. The funny is that, I have been accessing it by the IP address http://ipaddress:port/ReportServer/ReportService.asmx and it just quit working all of a sudden. There hasn’t been any change to the server or to the network so, I can’t figure this out. There are some specific reasons so I need to access it by the IP address. So could someone please help me out Thank you bjmp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SDK won't compile on VS2003 -> Syntax error in D3D10.h

  When I try to compile the code from Tutorial 01 that comes with the October SDK in VS2003 it gives the following errors; i:\Program Files\Microsoft DirectX SDK\Include\D3D10.h(818): error C2061: syntax error : identifier '__out' i:\Program Files\Microsoft DirectX SDK\Include\D3D10.h(822): error C2061: syntax error : identifier '__in' i:\Program Files\Microsoft DirectX SDK\Include\D3D10.h(826): error C2059: syntax error : ')' What do I need to do to resolve this problem Thanks. I haven’t try it with VS 2003 so far but the last windows SDK could help to solve this problem. ...Show All

• SQL Server Subcube in cube calculations

    In AS 2005, can a Create Subcube statement be used to create a subcube that can be used within a Calculated Member in the Calculations tab in the cube editor. The Subcube needs to exist only within the scope of the Calculated Member. (Create member) What are the typical usage scenarios for 'Create Subcube'. Regards     Couple of questions: 1. So, do you really hardcode the conditions on the date dimension inside MDX Script This would make it very inflexible. Or am I missing something 2. I am puzzled why you see differences in performance between two approaches. The execution plans for both of them are very similar, so the performance should've been the same. Do you run with SP2 3. It is p ...Show All

• Visual Studio Tools for Office MenuButton click event not firing

  Hello All,   In VSTO - I had created a Word Template Project, where I had created a new menu and attached an event handler to the menu button's click event. The menu and menu buttons gets created when I try to test this project, but these events are not firing when I click on any of the menu button. In VBA - Then I have tried to create a macro in which shows a simple message box and then I have created a menu button for this macro. And surprisingly this works. Now I want that above created VSTO menu button's click event should fire as just like VBA menu button, anybody has any clue regarding this Please let me know if any workout is there.   Thanks and Regards, Vikram Chudasama   Sorry for n ...Show All

• SQL Server Call a stored procedure from an SSAS action

  Hello, I'm just wondering if anyone has every created an action that called a stored procedure. I've been looking into Proprietary actions of statement actions but I cannot find any documentation of examples. Is this possible One option was to create a dummy ssrs report and then call some custom .Net code. But I want to avoid using a technology just as a work around. Any ideas thanks. Hi, Hi after some further reading I figure out what was going on. When right clicking on the cell the server would resolve all actions and return the resulting string to the client, therefore the result was that the ssas stored procedure was getting executed before the action was returned to the client. Solution: I ch ...Show All