DaftP's Q&A profile

• SQL Server Perform upgrade method

  hi I have two versions of the same dataflow component , i need to use the new version component in the packages created using the old version . How can i do this using the perform upgrade method . Thanks Mani Explanation about PerformUpgrade and a sample code can be found in book online or at: http://msdn2.microsoft.com/ko-kr/library/microsoft.sqlserver.dts.pipeline.pipelinecomponent.performupgrade.aspx Hope this helps, Ovidiu Burlacu ...Show All

• Visual Studio Express Editions Creating a key in the registry under HKEY_LOCAL_MACHINE

  The following key creation code works fine Dim aKey As RegistryKey = Registry.CurrentUser.CreateSubKey("Test9999"). Yet when trying to create a key in HKEY_LOCAL_MACHINE by using the following Dim aKey As RegistryKey = Registry.LocalMachine.CreateSubKey( "Test9999" ) an execption is generated at run time. Why does the first case work, but not the second RabBsl The error message was " System.IO.IOException was unhandled" with the following detail: Message="The specified path is invalid. " Bob ...Show All

• Software Development for Windows Vista how to access custom stateActivity property

  How to access custom StateActivity In response to my previous query: http://forums.microsoft.com/msdn/showpost.aspx postid=498300&SiteID=1 I tried, using: _workflowRuntime.GetWorkflow(m_XOMLWorkflowinstanceGuid).GetWorkflowDefinition.GetActivityByName(" MyStateActivity "). MyProperty Without any luck. I am creating a stateactivity property called authorizedUsers. At the runtime I want to determine whether the current user has the access for nextState. ...Show All

• .NET Development System.Transactions in SQL Server Database

  I'm using the System.Transactions - Transaction Scope block using SQL Server 2005. Everything workings fine on my queries, except when I try to use a Synonym to access a table on the same server, different database. If I make any call using a Synonym I get the error message: "Transaction context in use by another session." If I don't use the synonym and access the database table directly using <dbname>..<tablename> like AdventureWorks..Person instead of trying to use the synonym everything works perfectly. If I don't use the System.Transactions then it all works perfectly. Anyone have any ideas I've done multiple searches and can't find any issues regarding synonyms and transactions. Thanks ...Show All

• SQL Server Global Auto Increment Value

  Hi , In Sybase, there is concept of global autoincrement The range of default values for a particular database is pn + 1 to p(n + 1), where p is the partition size and n is the value of the public option GLOBAL_DATABASE_ID. For example, if the partition size is 1000 and GLOBAL_DATABASE_ID is set to 3, then the range is from 3001 to 4000 If synchornization is done betrween 2 database . then in server , the new record will be created The value of increment value would be max value at server +1 For Example Database id of database(1) is 1 Table A has 3 rows The values are 1000000001 1000000002 1000000003 This database id of this database(2) is 2 The records in table A in this database 2000000001 2000000002 Then ...Show All

• Visual Studio Team System WSS on a different box?

  Hey, A client of mine wants to use their central Sharepoint boxes to host the TFS WSS sites under. I know it is possible to change the urls of the WSS sites through the TFSREG.exe tool, but I was wondering if this is a supported scenario In addition to this question, what security permissions are required on the Sharepoint environment to create TFS sites during the Team Project Wizard It seems from recent documentation updates that you have to be Sharepoint Administrator in order to create sites, while this is not true in basic Sharepoint deployments. Giving away Sharepoint Admin rights to the people that are allowed to create Team Projects on TFS is certainly not an option (the Sharepoint environment is big and administration and ...Show All

• Visual Basic eXcel VBA Commands execution in Background

  Hi there, I'm seeking a help here. I need to execute the whole SUB Module in background - means that no operations should be seen in the eXcel window. There is a lot of them - i made them pretty simple [I'm really a freshman to this]. Is there some command, which would make all the stuff executed in background Or, how to do it Thank you very much raduz These forums are for VB.NET questions. The VB within Excel is Visual Basic for Application. VBA is a very different product from VB.NET and there are some other locations where you will probably get a quicker and better response to your VBA questions. Y ou may find more assistance in following which specifically deals with VBA development. http://forum ...Show All

• Visual C# c# InvalidProgramException

  Hi, I am auto-generating large (but simple) blocks of C# code, compiling to a dll then loading the dll via reflection. This seems to work fine for smallish test cases, but when generating larger programs otherwise similar code decides to throw the InvalidProgramException. The c# compiler version is 8.00.50727.42 from the .net framework sdk v2.0.50727. Is there an updated compiler I can try If not is there an appropriate place to report the bug with an example Cheers. Andy. If you are not using the CodeDOM then how are you generating the code Are you creating C# code that is then compiled through the compiler or are you generating IL directly. If you aren't use Emit or CodeDOM to generate code then is t ...Show All

• SQL Server ssis in sql server express edition

  hi, can anybody tel me how i can install (any component to be instakked) ssis in sql server 2005 express edition it's lok like this edition doesn't support ssis! is' it true Thanks Sandipan Hi Carlin, The security model did not change in SQL Server 2005. We did change the Service Account used by SQL Express from that used by MSDE, but the model is exactly the same. There is a set of DTS Design Components also available on the feature pack page, I've never installed these, but the description indicates they provided design functionality for DTS 2000 packages in SQL 2005. You are correct, you can not generate a canned SSIS package and then run it in Express. You must have the SSIS engine to run SSIS packages, SQL Express ...Show All

• SQL Server Analysis Services 2005: "OLE DB error: OLE DB or ODBC error : Access denied" using an ORACLE source

  Hi, The source DB is in Oracle 9.i . I use the native pilot from Oracle. The connection test is OK. I can also explore the data in the Data Source View whithout any problem. But when I try to process the dimension, I get the error message "OLE DB error: OLE DB or ODBC error : Access denied.." . I tried with the Native pilot from MS for Oracle but got the same result. Could anyone help me Rg. In your datasource try to use Microsoft OLEDB Provider for Oracle or .NET Oracle Client Data Provider. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Windows Forms Form.Load????

  I have a Form that load with some default data that comes from an object....when i change the default code my information does not change even though i have the functionality for changing in the Form.Load method.....Would there be any reason the form.Load would be called if the form is closed and re-opened from a parent form this .cboStartingPoint.SelectedValue = this ._VendorDetail.StartID; this .cboEndingPoint.SelectedValue = this ._VendorDetail.EndID; if i change the value of the selectedvalue on the underlying object my information in this form does not change....it only changes when i open the form for the first time.....can anyone help out with this If you apply Show/ShowDialog on the same instance again ...Show All

• .NET Development Validating XML against XSD with patterns in .NET 2.0

  Hello, Below I give more details, but basically the problem I have is that I have XML data that I want to validate against an XML Schema definition (XSD). The XSD specifies an attribute which has to match a pattern defined by this regular expression: <xsd:pattern value="((\w:) \w(=\w) ){1,}"> Valid values matching this pattern could be, for instance, something like this: " ns1:Inwatera_1m=A, ns2:CoastL_1M=B " However, .NET 2.0 does not seem to agree, since when I validate an XML document containing the value " ns1:Inwatera_1m=A " for an attribute that has to match this pattern I get the following validation error: "The 'typeName' attribute is invalid - The value 'ns1:Inwatera_1m=A' i ...Show All

• Internet Explorer Development IE7 the culprit? outlook express hotmail problem

  I use OE6 to archive my hotmail locally via dial-up until I installed IE7 and then I'm requested to logon when synchronizing my hotmail folders. I have not been able to logon yet and synch my mail. I also have McAfee security running and have disabled it to see if the connection is being firewalled to no avail. I just need to know for sure if hotmail is no longer available to OE users or there is an easy fix to restore what was a very handy facility. Help! Afew minutes after I posted this I found KB907942, an obscure update that Most Magnificent Microsoft has for just this problem. I will repost if it doesn't work. sorry riggs,I wouldn't want to recommend tweaking your registry without some pro guidanc ...Show All

• .NET Development Need help/ideas with asynchronous query(s)

  Is it possible to execute the queries stored within a TableAdapter asynchronously Any articles I could read or suggestions You might to provide a bit more detail as to what you want to accomplish. There are some built-in asynchronous features for the Command object: Performing Asynchronous Operations In addition, you can also create another thread for your application and perform database operations from that thread. This will free up the main thread so that your application can respond to input or perform other database operations. ...Show All

• Visual Basic Help: File Dates With .NET 2.0 Ahead One Hour When Modified In Day Light Savings Time

  I am using VB .NET 2.0 with Visual Studio 2005. I have a VB program which keeps adjusting the file dates when the files are considered to have been created or written during a Day Light Savings period. By this I mean when I read the IsDayLightSavingsTime property of a file date and it returns TRUE. For example, if I read a file that was last modified on 5/6/2006 at 8:00 a.m., my VB program keeps adding one hour to the time so it ends up reading as 5/6/2006 9:00 a.m. How can I stop this I need my file dates to match what is shown in the explorer window when you browse your files. This problem does not happen when the IsDAyLightSavingsTime property reads as FALSE. Below is a snipet of how I am getting the LastWriteTime of the files: ...Show All