abcynic's Q&A profile

• SQL Server Transform data task (DTS2000) and SSIS

  My first period using SSIS in a real-world application convinced me that there is a lack of support in migration of SQL2000 DTS packages, expecially in a star schema transformation scenario. Most of my actual DTS packages are combinations of SQL Execute Task and Transform Data Task. 90% of Transform Data Task are so composed: - SELECT from Data Source - mapping from source to destination with "copy column" (source and destination columns have the same name) - SQL Fast Load with a defined batch size (1000 or 2000 tipically) and Table Lock - Log to text file of source and destination rows that fail transformation (tipically when I try to put ...Show All

• Visual C# A beautiful language ruined by generics

  I've read all your arguments. I see good points of each side. Thank you for letting me enjoy this article. It seems the question is for C#'s code readability v.s. code reusability. As a solution developer I prefer not to use generic or template because my problem domain resides in a specific classes or types. However if I need to maintain or to develop a library, I probabily look into generic stuff. Hmm... ...Show All

• Visual Basic IT Asset Tracking Database Querying issues using Combo Lists

  I have created the following 3 tables for a test application before I start my IT asset tracking application properly: Make MakeID MakeName 1 HP 2 DELL 3 IBM 4 Fujitsu 5 Brother 6 Sony 7 Toshiba 8 Epson 9 ModelType Table ModelTypeID ModelTypeName 1 Desktop 2 Server 3 Notebook 4 Printer 5 ...Show All

• SQL Server Raiserror in Service Broker internal activation stored procedure

  I use Try ... catch blok in my activation stored procedure. When SQL Server raise error (e.g. Primary key violation) in Try blok, XACT_STATE in Catch blok has value 1 = commitable transaction and I can use rollback transaction to savepoint. But when I use Raiserror() in Try blok, XACT_STATE in Catch blok has value -1 = uncommitable transaction and I can't use rollback transaction to savepoint. When I drop automatic activation for given queue and I run this stored procedure with Raiserror(), XACT_STATE has value 1 = commitable transaction. What a problem may cause this different behavior Best Regards, Pavel ...Show All

• SQL Server Spaces in Column names

  Hi all, Is it a bad practice to create column names with spaces. like [Last Modified On] If yes, y It is certainly not a good practice, but not sure I would elevate it to bad exactly. It is a pain to always have to use the [ ] (or " " with quoted identifiers turned on). If you really want to space out names like this I would use underscores between the name like last_modified_on. ...Show All

• Visual Studio Can't add MSDN library to x64 install

  Hi All, I have an install of VS 2005 CTP July 2005 on my DELL PowerEdge box (dual 64-bit processors).  The install went fine, but I can't install the MSDN library that was on the DVD.  The install says an unhandled excption in msiexec.exe. Can the MSDN library be installed on 64-bit hardware   Or am I missing something else Thanks in Advance! Corey. Don't have a DVD drive.  DELL wanted a fortune for them on the PowerEdge 1850.... :P C. ...Show All

• Smart Device Development Error creating Smart Device app in VS.Net 2005

  When I try to open a Smart Device form in Design mode, I get this error: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. Clicking on each error will take you to the line of code that caused it. Unable to cast COM object of type 'Microsoft.VisualStudio.DeviceConnectivity.Interop.ConManClass' to interface type 'Microsoft.VisualStudio.DeviceConnectivity.Interop.ICcServer'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{EA537AF4-2226-4D26-BBC0-9CF3A8274 ...Show All

• Windows Forms windows forms controls, windows form inheritance, and custom base form properties. And VB.NET

  RE: windows forms controls, windows form inheritance, and custom base form properties. And VB.NET First, I developed a very simple Windows Forms User Control. It inherits from UserControl and all it is, is a banner of several image files....contained in picture boxes. I believe this configuration is called a composite user control, anyway...I compile the app into a D ...Show All

• Visual C# Zooming Area

  Dear All, am using C# windows application, and InkPicture control, which i need to do is zoom in by selecting area, am do the zoom in function and the selecting area, but my problem is how to fucus at the selected area (rectangle) after zooming, please advise......... Dear Chris, am using a windows application using C# that contain an InkPicture control, and also am implement a Zoom In, Zoom Out functionality and it work successfully, but am trying to accomplish the zoom In by Selecting area then do zoom in (like photoshop program), i need a help to doing that, am do the sele ...Show All

• Visual C# Sessions

  Hello0o0o Dears, How to make a session in C# please i want an Example about Sessions When an .net application starts the global file usually kicks off the session. the Session class is naitive to .net and always accessible. So just break a point and look into Session Object. Heres a link: http://www.csharphelp.com/archives/archive185.html hth, mcm ...Show All

• Windows Forms Sending keystrokes...

  I'm trying to emulate sending a "CTRL-N" to a form in a Windows app after checking for a previous instance of the application. Once I determine if the users has the existing application up, I activate the current window, send a keystroke and then close the app that had the previous instance when launched. When the AppActivate runs, I can see& ...Show All

• .NET Development Access Database and x64 OleDB Connect

  Hi, i've written a programm wich access an .mdb Database with OLE-DB. Under Win x32 everything works fine Under x64 no Database is found. Is there no way to access an mdb Database from x64 There is no way to access a .mdb database from 64bit. It has been decided to not port the Microsoft Jet Database engine to 64Bit. Brad Rhodes This message is provided as is.... ...Show All

• .NET Development Working with Web Services in Visual Studio 2005

    H i all,     I'm new to ASP.NET and web services.     I'm able to create a web service successfully.And i tried to add it as a web referrence to another ASP.NET application.The Add Web Referrence dialog window displays my web service,but when i clicked the link to add it,i got this error:     "Server cannot access application directory  'C:\WebSites\MyWebService\'. The directory does not exist or is not accessible because of security settings."    If anyone knows how to solve this ,plz help.   In the WebService you are trying to add to another project, g ...Show All

• Visual C# Check and verify that a smtp-server is up and running?

  Hey there. I have an application in C#, that is depending on the fact that a smtp-server is valid and running. Is there any way of checking if a given smtp-server is "alive" SmtpClient smtpclient = New SmtpClient(<server>); /Kristian You can try to handshake with the Smtp server, it the handshake could be done everything is running normally. Take a look at the Smtp protocol how to implement an handshake or take a look at the following article that demostrates how to then email with C#. It implements all commands and you can just pickout the handshake process: Sending email with c# u ...Show All

• Visual Studio Express Editions Error al activar version

  Hola: Al momento de activar mi version beta 2, el link me envia a una pagina que dice no existir. Saludos. I can load the page without problems.  It redirects to the following site: https://profile.microsoft.com/ProductActivation/ProductActivation.aspx WizId=ea444a93-3d6a-4ef4-b4de-e38c34f07876&lcid=1033&h=12d30263b8e1ca12&bn=050215.44 Try to go to this site directly.  Also, what is your default browser settings ...Show All