jerome1234's Q&A profile

• SQL Server Error between string data types

  I reinstalled SQL Server, setup new connetions in my existing project and then pointed the existing controls in my SSIS packege to my new OLE DB Connection manager. When I run my package, now I get: TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task 1 [OLE DB Source 1 [73]]: Column "TransactionDate" cannot convert be ...Show All

• Smart Device Development nativewindow in compact framework available??

  I want to select a date from datetimepicker. If I use eventhandler valuechanged, it goes nuts. So I found to control if the date was changed with the eventhandlers DropDown and closeup but these are not available in Compact framework. for the eventhandlers I found this solution http://blog.opennetcf.org/ayakhnin/PermaLink.aspx guid=4069b90f-f53f-4726-8790-36a9d3830aed e DateTimePicker control in the .NetCF v2 doesn't implement DropDown and Cl ...Show All

• SQL Server re-establishing mirror

  When witness and mirror were down, mirroring was removed at primary. Now when I try to re-establish mirroring I get the following error Msg 1456, Level 16, State 3, Line 1 The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. On the witness server the following sql select * from sys.databas ...Show All

• .NET Development Three Tier Architecture

  Hello Everyone, I am a new developer to .NET, previously I was working on J2SE and J2EE and now I have to work on .NET. I have to come up with a design proposition for a Small Business Solution in Three Tier Architecture. In Java I used Enterprise Java Beans with RMI-IIOP. I was wondering if there is something similar or even better in .NET. I would like suggestions on methodologies and possibly some onlline resources to go along with ...Show All

• .NET Development I Can’t Pasw The Value of a string var to a SQL statement, I already read tutorials but..

  Hello Community, I need some little help, the last time I programmed was 13Years ago, now I try to do it again and I found VWD2005ED v8.0.50727, lovely free app (for now), .NET Framework v2.0.50727 and SQL Server 2005. On my first steps I have created a webpage with some field text, I already have passed variables values from one page to another, great, now I have the following problem: on the page who recieve the variables I d ...Show All

• Windows Forms WinForms vs Normal Windows App

  Hi...I'm kind of new with WinForms on the .net framework I'd just like to know if anyone could tell me about the differences between a windows application as we know it and WinForms .net a WinForm application is a windows application that typically provides a GUI user interface....it is what previously to .Net was a "Windows Application"...Today with .Net you have WinForm app for creating applicati ...Show All

• SQL Server Executing SSIS package from stored procedure

  Hey guys, I've got a problem here. I need to send the query result to a csv file then transfer the file to a website. I thought this is a good candidate for a SSIS package. The package is ready now but I don't know how can I execute it from within a stored procedure. I thought sp_OA family of extended procedure would be helpfull. After following steps: EXEC @hr1 = sp_OACreate 'DTS.Package', @oPKG OUT EXEC @hr1 = sp_OAMethod @oP ...Show All

• SQL Server Error 18452

  Hi, If I connect to SQLServer Express via Windows Authentication it works fine. But if I use SQL Server Authentication it doesn't work with a new created user and sa (with a new password) too. I turned mixed mode on, registry key HKLM\Software\Microsoft\Microsoft Sql Server\MSSQL.1\\MSSQLServer\login has the value 2 and all ports are set to 1433 but there is still error 18452. Any suggestions Did you ...Show All

• .NET Development copying files indicating the status of the copying

  Hello, I'd like to know how can i get the actual status of copying a file using my.computer.filesystem.copyfile(sourcefile, dest.file). I mean i'd like to use a progressbar indicating the status of copying and get the current size of the newly created file during the copying. Could anyone plz tell me I mean something like Explorer's filecopying messagebox with the progressbar on it. thnx in advance; You can use the Explorer dialog using the ...Show All

• Software Development for Windows Vista Ruleset Editor - Method not found

  When I execute the Ruleset Editor example (2005-09-12) I immeadiatly get the below exception. I have installed WinFX and WinSDK, Jan 2006. Do I need to use an older version of WinFX an WinSDK See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.MissingMethodException: Method not found: 'Int32 System.Workflow.Activities.Rules.Rule.get ...Show All

• Visual Studio Team System Web page not found in VSTS

  I have a web test where a page is not being reached (Error 302) When I use VSTS When I copy/paste the URL+query string and paste into IE it works fine. http://creative.gettyimages.com/source/search/ImageDetail.aspx s=ImagesSearchState|3|5|0|0|15|2|1||0|0|0|1|60|2ad3.85c5.03fb.e000.002f.76b0.7ce0.e038.f70b.39ff|1|0|0|%22dolphin%22||1|0|1&pk=5&imageIndex=3&assetIndex=3&licenseModel=2&cdpc = Is there a limit on the size ...Show All

• SQL Server ForEach Loop utilisation

  Hello, ForEach Loop Item allow to make operations row per row. How can i do operations 10 rows per 10 rows or 100 rows per 100 rows Thanks ! Sorry... Those functions looks nice but are not made to my problem... I'm trying to resolve my problem with a transformation script to make a recordset containing rows in the correct format. If you want, i'll send you the script Nico ...Show All

• .NET Development unique nodes from Nodelist msxml dom

  hi I am trying to access unique nodes from NodeList  (MSXML2.IXMLDOMNodeList) This is a part of my xml file in which i have multiple < FamilyCharat > with different ChrCod    value i have loaded it into Nodelist when i am counting No of  < FamilyCharats > it is showing me 3 ,where as ChrCod of 2 element has same ChrCod  and i need only unique ChrCod and its and there value < Fa ...Show All

• .NET Development ApplicationSettingsBase and Default Values

  I want to specify a default value for a property specified in my hand crafted class (based on ApplicationSettingsBase). The property returns a custom type for which the attribute DefaultSettingsValue does not apply. i.e. it is a list of custom objects. Something like: [ ApplicationScopedSetting ()] public IList < CarrierBase > InsuranceCarriers{ get { return ( IList < CarrierBase >) this [ "InsuranceCarrier ...Show All

• SQL Server Managing Hierarchies in Dimension Tables

  I am currently looking at the capabilities in SSIS from the point of view of an ETL developer who has worked with other products eg. Informatica, Cognos DecisionStream and one of things I note is a lack of support for dimensional hierarchies. It appears that MS have assumed that SSIS users will automatically use SSAS. We use Hyperion Essbase. Other sites have Cognos or Business Objects for their OLAP/BI. I would like to be able build mu ...Show All