levitymn's Q&A profile

• Visual C# "OUT of Memory" String construtor

  Hi, im getting a "out of memory" exception when I try to pass a large char array in the the string construtor. The array has a length of about 200MB, its XML Data. I need to convert this to a string for the further handling. For smaller data stuff works fine. Any ideas how to convert the data to a string Thanks Dob Hi Guys, thanks for you comments. Like louthy said, I need the whole thing in memory, because the this is not the only way how we receive data, we also get the stuff from a web service and from TCP socket connections. So, we separated the "transportation" from processing. Originally we didn't have so big data packages in mind. The rest of the processing queue relies on the fact to ...Show All

• SQL Server compilation error

  While compiling my ADF I am getting the foll. error: Notification Services could not obtain an identifier needed to construct a Transact-SQL statement I am trying to create an scheduled subscription with a user-defined rule. I followed the instructions on Shyam Pather's book on SQLNS and was able to create the event-trigerred subscription with user-defined logic. But when I tries to extend this to a scheduled subscription I got this error. I have searched the net for this but could find no other info on this error Any idea what this could mean Thanks DK Detailed Error: =================================== An attempt to run a Transact-SQL CREATE PROCEDURE statement failed. In ...Show All

• SQL Server Add linked server at Excel VBA

  I had SQLDMO at reference library. Private Sub test() Dim s As SQLDMO.SQLServer Dim ls As SQLDMO.LinkedServer Set s = New SQLDMO.SQLServer s.Connect "Server1", "ID", "Password" Set ls = New SQLDMO.LinkedServer With ls .Name = "Server2" .ProviderName = "SQLOLEDB" .DataSource = "Server2" ' .ProviderString = "" End With s.LinkedServers.Add ls s.Close 'End Sub I block ProviderString as i don't know what is it. I got an error message when it's running the line "s.LinkedServers.Add ls" that "Run-time error '-2147206257 (80043b8f)': Automation error" My question: 1. What is providerstring what ...Show All

• SQL Server Parent-Child Hierarchy but reversed(!)

  Hi! I have a report that uses a parent-child hierarchy in a table. It is hidden with the toggle set to itself, and that works perfectly. However, instead of having it look like this(simple example): + Profit After the + has been clicked: -Profit +Sales +Cost I would like it to look like this: +Sales +Cost -Profit Is this possible with when using a parent-child hierarchy http://ssasfreak.spaces.live.com/ Yes. That only works when you have the diffrent levels in different fields. Like this: Level1 Level2 Level2 I use the parentgroup property(for the grouping) with a recordset that looks like this: LevelID LevelName ParentLevelID Any ideas ...Show All

• Smart Device Development plaform builder error with deployment

  Hi All, I have used an .rtf file describing how to use the ce device emulator. It was useful, however I am still experiencing some problems. When I attempt to connect to the device emulator, I get a dialog box that displays the errros listed below; The Kernel Debugger is waiting to connect with target. The Kernel Debugger has been disconnected successfully. The Kernel Debugger is waiting to connect with target. Your virtual machine may not have enough RAM allocated. Try increasing the RAM allocation (if you are using Platform Builder open the Configure Remote Services dialog, choose the Emulator Download service, and click the configure button). I don't know how to fix it. After building the OS and the SDK and installing the ...Show All

• Visual C# messagebox showdialog

  Hello, I try to show a message box in my program Messagebox.Show("Hello World".......); However it's not show as a dialog box but just a simple form. so it let me click on the main form instead of preventing it. I did a test on other program with the MessageBox.Show() and it's working as a dialogbox. Have any idea about this weird behavior Hmmm really weird! Try it with passing the reference of the form showing it like MessageBox.Show(this,.............); It shouldn;t make any difference anyhow try it! Best regards, ...Show All

• SQL Server UK date format being switched to US format

  Hi all, I am updating some reports in SSRS 2000 and need to pass a couple of date parameters to the reports. I pass the dates like so: ... params( 1 ) = New ParameterValue params( 1 ).Name = "DateFrom" params( 1 ).Value = dateFrom.ToString( "yyyy-MM-dd" ) params( 2 ) = New ParameterValue params( 2 ).Name = "DateTo" params( 2 ).Value = dateTo.ToString( "yyyy-MM-dd" ) ... I am using the format 'yyyy-MM-dd' to try to avoid any regional format problems, but when the dates are used and displayed in the report, they have magically switched to US format! How do I get around this Regards, Stephen. Try this fella Format(Cdate (Fi ...Show All

• SQL Server How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?

  How to delete/drop all the tables from SQL Server Database without using Enterprise Manager I tried using DROP Tables, Truncate Database, Delete and many more but it is not working. I want to delete all tables using Query Analyzer, i.e. through SQL Query. Please help me out in this concern. Nishith Shah Hay man what you are asking for,if you just check my reply, the answere is there ok, try this, this will delete/truncate all the Data from each table for in the database you connected EXEC sp_MSforeachtable @command1 = "DELETE FROM " EXEC sp_MSforeachtable @command1 = "TRUNCATE TABLE " I too explain it now, as sp_MSforeachtable is Stored Procedure, that will execute for all the tables for database & @command ...Show All

• Windows Search Technologies WDS Died - Now Won't Index

  One of our users that's running WDS has the following issue: WDS had a message that said something like "WDS won't start up, uninstall and reinstall". I uninstalled it, reinstalled it, but it still won't index (it will start to scan through files, but the items indexed counter never increases). I uninstalled it again, reinstalled a newer version (02.06.6000.5414), but the problem still exists. Is there something else I can do It's a pretty important application for the user, and had been working fine for months before this. Platform is W2K. Thanks. David, I reinstalled both ways, as administrator on the box and as the users id with admin. rights. Neither way seemed to work Another user is having ...Show All

• Visual Studio MSBuild file for .Net 1.0, 1.1, 2.0, Compact Framework 1.0 & 2.0 and Mono

  Greetings, Intro: I'm currently working in a library that has to target both .Net 2.0 and .Net Compact Framework 2.0. My initial approach was to have two projects for each assembly. The source code would be all the same, with #if's testing for the compact or the full framework. One of the projects would have all the files, and the other all the files from the first linked. As the number of source files and assemblies growed, this turned into problematic. At some time, I also wanted to test if my code worked in mono, even if it wasn't required. So I thought of using msbuild to customize my build. I started googling, and found msbuild files from Jomo Fisher and Robert McLaws that would target previous versions of .Net. And I also found msbui ...Show All

• Visual C++ "using" in C++

  In C# it is common practice to use the using statement to define a scope outside of which an object or variable will be disposed of. This normally applies to resource intensive objects such as the OleDbConnection I am using in my code. Is there a way to implement this sort of scope-modifying keyword in C++, so that I can release the resources used by the OleDbConnection when I'm done with DB Thanks! Evan C# provides a way to dispose of objects that implements IDisposable and that's just calling Dispose: connection.Dispose(); What using does is to call Dispose inside a finally block, nothing more. A disposed object is not GCed until it goes out of scope. try { // code that uses connect ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Newbie question - spawning new objects

  Hi folks, Apologies for asking a really simple question in the forums, but I'm hoping someone may be able to help me. I'm basically trying to create a very simple 2D XNA game in a week, from a background of not having programmed anything more complex than a VCR since Spectrum basic - it's for a magazine article, hence the need to cut a few corners when it comes to learning... I have a problem which - I'm sure - the solution will provide me with a Eureka moment in understanding how this is done. I've followed the excellent videos on LearnXNA.com and the built-in tutorials and have figured out how to draw sprites on to the screen and move them around. It's not much, but it's a start... How do I then add in new sprites as the game progr ...Show All

• .NET Development Help me plz!!! if i have file containing Hexadecimal in it......

  if i have a file saved as .txt or .bin in my hard disk...through filing i have to read that file ..the file contain hexadecimal in it such as 1a 2a 3c 14 12 4d................. now i have read these hexadecimal from file and to put them in array .of integers......means ......if i take int [] array = new int [10]; then hexa decimal should be like.....array[0] = 1a; .array[1] = 2a; like this every hexa should sit on one postion of array ...thx u plz help me Hi Mayby this help you. FileStream stream = new FileStream ( @"..\..\HexFile.txt" , FileMode .Open); StreamReader reader = new StreamReader (stream); string [] strings = reader.ReadToEnd().Split( new char []{ ' ' }); int [] numbers = new ...Show All

• SQL Server Cannot get SQL 2005 RS up and running

  I am attempting a migration to RS 2005. I restored the ReportServer and tempdb databases over to the new server. The config manager says the ReportService service is running. When I try to view the reports in a browser I get a report server is not responding error. Thanks Richard The report server edition needs to be compatible with the SQL server edition. See this link for a compatibility matrix http://blogs.msdn.com/bimusings/archive/2006/03/03/543088.aspx . ...Show All

• Windows Forms Drag Drop Button

  Is it possible to Drag and Drop a Button from a panel to another panel or to the form Hi I just modify some code some other one and tried it seems can drag button between two forms, Best Regards! using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication2 { public partial class Form4 : Form { public Form4() { InitializeComponent(); } private int OldX , OldY; private string Control_Name= "" ; private void button1_MouseDown( object sender, MouseEventArgs e) { button1.Tag = button1.Bounds; OldX = e.X; OldY = e.Y; } private voi ...Show All