BD_Elektrona's Q&A profile

• SQL Server SSIS File System Task problems since loading SP1

  I have just loaded SQL Server 2005 SP1 and it is playing havoc with any SSIS packages that use the File System Task. I am using the FST to copy a file to a directory after it has been loaded. This worked fine prior to SQ1 but now I am getting the following error if there are one or more files already in the target directory: [File System Task] Error: An error occurred with the following error message: "The directory is not empty. ". If I remove all files from the directory it works fine. Has anyone come across this problem and got a workaround for this Will it involve me writing a FSO script task Is this 'feature' going to be rectified in SP2 How is your file system task configur ...Show All

• SQL Server Can synonyms be used to replace hundreds of lines?

  Hello I'm looking for a way to store a large chunck of text (200 lines) in a variable which can be called in different objects within the database. For example: I have several stored procedures that create the same temp table which exists of 200 column names over and over again. It would have to look like this Import myScript (I keep thinking of Import like used in .NET) and myScript could exist of: CREATE #MyTable( ...) or even some simple text or a part of a sql statement. I'm familiar with synonyms but you can't use that in this scenario. Then I thought of functions. The scalar function returns a result, not what I want here. Table valued function return tables, not what I want. Many thanks in advance! ...Show All

• Visual Studio Express Editions How can I print image file (*.bmp) to the default printer?

  I have an image file (*.bmp) and I want to print this file to the default printer. and how can I control if the printer will print this file in the left or right of the paper Regards, Yaniv pinhas In the print page event change the X(horizonal), Y(Vertical) co-ordinates and put it where you want. Top left is 0,0 e.Graphics.DrawImage(PictureBox1.Image, New Point(0, 0)) or e.Graphics.DrawImage(Image.FromFile( "c:\test.jpg" ), 0, 0) ...Show All

• Visual Studio Team System Merge error: TF14087 "Not all of the deletion is being undeleted"

  When trying to merge from one line to another, I receive the following error: TF14087: Cannot undelete '$/TFProject/TargetBranch/VSProject/SubFolder/File.aspx.resx' because not all of the deletion is being undeleted. With the Show deleted items in Source Control option on, I've checked for deleted items in both the source and target directory so I don't see what is not being 'undeleted' so I'm not sure what I can do to allow the merge to happen. Any help would be appreciated. Thanks. Marty You're right, the dialog I'm thinking of is only used for rename-rename conflicts. Merge doesn't detect namespace conflicts. What I'd do is rename (or delete) the file & checkin before doing the merge ...Show All

• SQL Server Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid You can buy something like the Delphi native interface to SQL Server from CoreLabs ( http://www.crlab.com/ ) instead of ADO. ...Show All

• Windows Forms inherited form constructor not found warning message

  I've seen one other post about this and it was never replied to, so I'm assuming this problem could be universal. When using a form that's a base class to be inherited by other forms that has a constructor with parameters, I consistently get a warning about the constructor not being found, and I can't use the designer on any of the inherited forms. Granted everything compiles and works just fine, but I always get a warning message, and I can't use the designer for any of the inherited forms. The designer for the base class works fine however. If I add a parameterless constructor on the base class that calls InitalizeComponent(), everything works correctly. But this is an entirely useless constructor that's used only to get the des ...Show All

• Visual Basic week number

  Hi How can we calculate week number in one month. I am bit confused about caliculating this week number in one month for example if we take today date 8/12/2006. Now we are in which week 2nd or first week (in december month) Our  zone is united kingdom.. Any help Thanks Here is the algorithm for determining the week number: 1- Determine which day of the week was the 1st of the month.  Use day as base number, starting with Sunday as 0, Monday as 1, etc. 2- Add base number to current month date number for the combo number. 3- Use a counter in a Do loop to keep subtracting 7 from from the combo number until it is <= 0. 4- The counter is the week number.   For example, if the 1st of t ...Show All

• Visual Studio Express Editions Insert data into dBase File doesnt work

  Hello, i'am a beginner in programing and VB.NET. I try to connect to a dBase file with OLE DB this seems to work. After this i try to insert some data into the file with a SQL insert order. This is my code: Private Sub ToolStripButton1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click Dim oledbConn As New OleDb.OleDbConnection oledbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data;Extended Properties=DBASE IV" oledbConn.Open() Dim oledbCom As New OleDb.OleDbCommand oledbCom .Connection = oledbConn oledbCom .CommandText = "INSERT INTO test (GewP_ID, X, Y, DisP_P1, RP1, DisP_P2, RP2, DisP_P3, RP3) VALUES ('GewP_ID', 'Dis ...Show All

• Visual C# VB.Net to C# hex

  I have some VB.Net apps that need to be converted to C#, component by component. There are some hex values in these applications that I need to move over. i.e. &H80000002, &H20019, &HF003F How do I convert these to the C# "0x0*" format ...Show All

• Visual Basic Allowing Only 1 Decimal "." in Textbox

  I am having trouble making it where if the user types more than one "." decimal they get a error msg or whatever. Mainly having problems coding the Character "." Thanks Nah, FormatNumber ("textbox1, 4) 4 being the amount of zeros need to find out how to code a period into the code but dont know how to refer to period key in Vb2005 ...Show All

• Visual C# BitArray Constructor ?

  Hello, I will try to explain me in English… So, i use BitArray : byte [] Alarm = new byte [1]; Alarm[0] = 0xff; BitArray b = new BitArray (Alarm[0]); => Size of b : 8 bit But if i make this : byte [] Alarm = new byte [1]; Alarm[0] = 0x01; BitArray b = new BitArray (Alarm[0]); => Size of b : 1 bit. I do'nt understant this. Could somebody explain me Thanks. JOOP. this code: byte [] Alarm = new byte [1]; Alarm[0] = 0xff; BitArray b = new BitArray (Alarm[0]); will result in a size of 255. This has to do with the constructor you are using. Your passing a single byte as parameter and the closest c ...Show All

• Smart Device Development TextBox OnClick

  (Compact .Net 1.0) TextBox does not have a OnClick EventHandler to use. So I created my own TextBox class and subclassed TextBox and I override OnClick. This compiles but when clicking on the TextBox the method never gets called. Is there any way to get notified when the TextBox is clicked or selected I tried catching the OnGotFocus event, that works great except if the focus is already on the TextBox and the user click on the box again. I need something to capture this case and OnGotFOcus does not get fired. Anu suggestions Thanks You can hook the underlying WM_LBUTTONDOWN or WM_LBUTTONUP message and do with it what you want. See this article for more information: "Subcla ...Show All

• SQL Server printing reports without previewing in a .NET app

  hi, i need to print reports without having a preview. i.e batch printing. with regards suresh babu Enter a tag in your page such as using which you can diffrentiate in part which is for printing and which is for not printing and the part of page which is for printing make its tag cssclass on and for rest part make cssclass off and than call window.print() and after that just make all class on. it will work as per your requirement. ...Show All

• SQL Server Create DTS Package in SQL server 2005 (Ver:9.0.1116).

  Hi, I am using SQL server 2005 (Ver:9.0.1116). I am unable to find how to create a DTS package from Sql Server Management Studio. It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio. I want to know how to start a Integration services in Yukon. As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package. Thanks! TechFreak Yeah Jamie, Thanx for the concern.. But using "Business Intelligence Development Studio" also it shows an error message as below: "Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified" In the Yukon tutorials there is no ...Show All

• Windows Live Developer Forums how many pushpins can I add?

  OK - I am fairly new to all this - and I have already wasted a couple of days trying to figure out the yahoo maps API to add custom mappoints/pushpins to their service, only to find out that they limit you to 200 points (which of course they disclose nowhere) - I need more like 4000 all over the US. Is this something Virtual Earth can handle, and if so, what would be the way to go about it All locations have a LAT/LON and a site nr. that is it. Thanks On my trusty laptop it actually took 5 sec to render 400pins, you must realise these pins do alot more then you are really after. Cahnge the quatity from 400 at athe bottom if you feel like doing some testing. John. <html> <head> <title></title> ...Show All