Prashweenet's Q&A profile

• SQL Server SSIS Flat File Connection Manager Max Columns

  Hi everyone I’m using the Flat File Connection Manager to access a flat file, tab delimited. The flat file has 200 columns, and when I'm editing the columns, I only preview columns from 0 to 97. Does the flat file connection have a column number limit How could I increase it Thank you for your answer..... Regards, Rafael Salas wrote: Duane Douglas wrote: Kaarthik Sivashanmugam wrote: I created a test file with 240 columns. How did you create this test file Just curious. I just create mine using 'Save as' in excel Ok. But I was wondering if there is an automated way to create and populate the columns. ...Show All

• .NET Development 2146233079 automation error while createobject on interop assembly (only second time)

  Dears, I have the following bizar problem. I've created a .NET assembly (dll) that can be created from COM (vb6 in my case). When I create the object the first time, everything goes fine. But the second time, I get an error on the CreateObject (-2146233079 automation error). I was unable to retrieve any more information from the error object in vb. I registered the .NET assembly using regasm (I tried both with and without the /tlb option). The .NET assembly simply queues the items it receives and spawns another thread that consumes the items. The spawned thread exits gracefully, and all calls to the DrillBackDotNetDispatcher return to vb. The second creation of the object is made after both the last call to addItem has returned and the t ...Show All

• Visual C++ Array Classes

  Hi. I was wondering if Visual C++ 6.0 had support for a 2-D Array class. I've found a 1-D class that I could use, but I think a 2-D class would better suit my application. My problem is I have a connection box I want to model. It had 4 columns and 10 rows. Depending on which setup of connection box, 24 of those 40 possible connections will be active. But the kicker is that if a column is active, all rows in it are active, or if the row is active, all cloumns are active. I think it would be easier if I could address each pin by it's row and column address. All the array will hold would be int values. those values would determine the connection type. not-used, used&good, or used& bad. From those 3 choices a loop would run to "dr ...Show All

• Visual Basic Game, How to make working ground anywhere. GDI

  Hi I'm wondering, you know when you see games like mario where he can jump around and walk on the ground no matter where it is. Well is there anyway to do that in vb.net. Example ___ _ ____/ \ __/ \__/ \______ Sorry that was a really bad drawing, but you get what I mean(I hope) I dont want to make a seperate point for each piece of ground. Instead could I do something like. for I = 0 to AmountOfLines if lines(i).contains( MyChar) then msgbox("My guy is touching the ground) next ...Show All

• Internet Explorer Development ie 7 crashes wont even load "addon hwtxkrm.dll" error

  i click on ie 7 and it starts to load and sometimes it loads but most of the time a pop up comes up and says "internet explorer has encountered a problem with an add-on and needs to close" the following add-on was running when this problem occured: add-on name: hwtxkrm.dll company name: description: hwtxkrm.dll and you click continue and ie 7 closes. i disabled hwtxkrm.dll in the add-on management area but it still does it. how can i delete it what is it for please help..i'm using firefox right now and rather use ie 7..... shawn email: crazycanadian_27@hotmail.com ...Show All

• Visual C# can any body help me in reversing strings

  this fuction help me to convert the arabic words to hexa .. and it doing the job 90% because it convert it in reverse   this means that the true hexa for example is (062F0645) but the function returns it like this (0645062F) and this makes each word come in reverse order   for example ... I love you becomes uoy evol I   how can fix that     public string ArabicHex( byte [] b) { string temp,s="",h=""; int i=0; while ((i <= b.GetUpperBound(0))) { temp= "00"+b .ToString("x2"); h = temp.Substring(temp.Length-2); if (h == "000D") { h = ""; } s = h + s; i += 1; } return s; }   thanks in advance ...Show All

• SQL Server SQL 2005 TDSSNIClient initialization failed with error 0x32, status code 0x1c (Clustered environment)

  I've seen other posts on this topic, but not with error 0x32. I was attempting to change a CLUSTERED instance of SQL 2005 from dynamic port to static port and in the process have somehow messed it up to the point it will no longer start. Version is 9.00.2047.00 The ERRORLOG has the following 2007-01-31 15:02:05.77 spid9s Starting up database 'model'. 2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1. 2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1c. 2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1. 2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1. 2007-01-31 15:02:05.77 Server Error: 17 ...Show All

• Visual C++ _CRT_SECURE_CPP_OVERLOAD_STANDARD_NAMES couldn't work

  I used /D "_CRT_SECURE_CPP_OVERLOAD_STANDARD_NAMES" in the configuration of the project property. It solved secure problem for functions like sprintf. However, fopen, fscanf, sscanf still report something like: c:\mvs2005\bs_module\source\utility.cpp(1639) : warning C4996: 'fscanf' was declared deprecated c:\program files\microsoft visual studio 8\vc\include\stdio.h(249) : see declaration of 'fscanf' Message: 'This function or variable may be unsafe. Consider using fscanf_s instead. To disable deprecation, use _CRT_SECURE_NO_DEPRECATE. See online help for details.' I don't want to use _CRT_SECURE_NO_DEPRECATE, because I want the warning pops up whenever there is a secure problem. I believe the three functions listed ...Show All

• Windows Forms Console Output from a Windows Form

  I have a windows form program which also includes a command line interface to a few of its features. When command line options are pased to the program the GUI is not displayed, and the command line code is properly excuted. However none of the output to the console appears. I was able to get the console output to be displayed by having Visual Studio 2005 compile my program as a console app instead of a windows app, but this causes a console window to be opened when you run just the GUI portion of the program. Is there anyway I can get the console output to appear without having this console window opened with my program when running the GUI part To add on, if you've played with the raw compile option ...Show All

• SQL Server Management Stusio install via SMS

  s there a way to only install sql management studio via SMS I found the article on the unattend install, but I do not want the connectivity tools, etc. I only need the management studio portion installed, nothing elsre. Has anyone accomplished this http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=478384&SiteID=1 ...Show All

• SQL Server Management Studio question

  When opening an .sdf file in SQL Management Studio, there doesn't seem to be a quick way to browse the data in a table unless I open a query and select the data. When connecting to SQL Server, I can right click the table and Open it to browse data. Is this a bug, or is it by design While Alex is right, the team is acutely aware of this issue and should be addressing it in SP1 or soon there-after. This is discussed in my new EBook. See www.hitchhikerguides.net . ...Show All

• SQL Server Dev cube on 32-bit, production on 64?

  Please help me confirm that the following scenario is reasonable. I believe that I can develop an SSAS DB and cube on SQL 2005 "Dev/32 bit" and deploy dev builds locally using BIDS, and then deploy a production version, still using my local BIDS, straight to the "Production/64 bit" server (with same SP). Am I correct that this will work and is a standard approach Are there any obvious gotchas I should know about Thanks very much. Daniel Upton ...Show All

• Visual Studio Team System LoadTestPageDetailData does not contain datas

  I am trying to do some report in the load Test result, I dig into the LoadTest Database and found LoadTestPageDetailData table is empty, but some of the other do have data like "LoadTestRun", The table LoadTestPageDetailData will only have data if the load test run settings have "Timing Details Storage" set to "All Individual Details". By default, it will be set to "None" and individual page response times will not be stored in the database. There is a good description of this load test setting in the following document http://msdn2.microsoft.com/en-us/library/ms404664(VS.80).aspx See the section titled "Including Timing Details to Collect Percentile Data. Thanks, Rick ...Show All

• Windows Forms in a form i have six text boxes for auto fill

  in a windows application i need to autofill six textboxes by parsing a resume can any one help me You need to know how to open the word document from .net C#, you can do it by "COM Interoperability ". This is a simple article http://www.c-sharpcorner.com/Code/2002/Mar/WordFromDotNet.asp The basic idea is the same. The main point is to locate the table, and then retrieve the data. ...Show All

• .NET Development Time scheduling datatype: Schedule, Duration

  Hi, one little question here, i can't find it thru the search, might not be using the correct search keys. What datatype should I use to indicate time I mean I want to store 2:00AM, or 5:00PM, just the time, without the date. So it is something like a schedule, a schedule that will runs for multiple days. Secondly, how should I indicate duration Duration like, 30 minutes, 2 hours Since, the unit of measurement is different, be it hour, or minutes; should I change it into the smallest feasible unit of measurement, or should I create a new data structure to store it Is there any ready made data structure in .net Thanks Eugene Generally, the rule of thumb is, if you wish to express a duration, us ...Show All