Yahya's Q&A profile

• SQL Server Flat File With Fixed Length Header and No Delimeter

  Hi, I'm trying to extract data from a Flat File which is as fixed length as they come. The file has a header, which simply contains the number of records in the file, followed by the records, with no header delimeter (No CR/LF, nothing). For example a file would look like the following: 00000003Name1Address1Name2Address2Name3Address3 So this has 3 records (indicated by the first 8 characters), each consisting of a Name and Address. I can't see a way to extract the data using a flat file connection, unless we add a delimeter for the header (not possible at this stage). Am I wrong Any suggestions on possible solution would be much appreciated - I'm thinking Ill have to write a script to parse the fil ...Show All

• Visual Studio Team System Looking for tutorials that are helpful

  The tutorials at http://teamsystemrocks.com/tutorials/ may be good for a high level view in certain areas but don't help out when getting started. Is there a tutorial showing how to: 1) Make the Pubs DB a database project using vanilla Visual Studio and then adding it to Team Foundation 2) Same thing but with a vanilla application. Thanks in advance You can find a whole series of walkthroughs on MSDN: http://msdn2.microsoft.com/en-us/library/ms181244(VS.80).aspx . Part of what's covered is adding solutions to VS, though I don't know whether they cover the db project in particular. Buck ...Show All

• Microsoft ISV Community Center Forums wrong count of Records in Access.Form

  Hi, I am having troubles with the count of records in a Form. All my Tables used in my Access database are linked tables to an SqlServer. The Form I use is a wizzard created form and the recordsource is simple like "SELECT * FROM tab1 join tab2 ..". I want to display the number of records in the form, but it seems, that the recordset does not load all records at once. What i did is: Private Sub Form_Current() lblRecordCount.Caption = Recordset.RecordCount End Sub But when I open the form, it displays just "16", if i move to a record below, it changes to "28", when i scroll to the end it finally displays "100" - which is really the right count. I tried this also with a new database, where i created a table with 500 reco ...Show All

• Microsoft ISV Community Center Forums Adding table in Word Doc over writes previous lines

  Please excuse what is probably a simple answer - I am very new at VBA. I am using VBA in Excel and attempting to write to a Word document. The document is to have a few lines of text followed by a 6x6 table. When I do a: Set tableNew = .Tables.Add(.Range, 6, 6) it overwrites the previous lines I wrote. I'm sure there's a way to place this table in the appropriate spot in the document, but I've been unable to find any documentation on this. Can you offer any help with this Thanks, kgkidd This was my first question using this forum.  Doesn't seem to be much assistance here - not a single response.  Unfortunately I still haven't found the answer.  Possibly the question was more dif ...Show All

• Visual Studio Express Editions BreakPoint

  Hi ppl, i got the following code i cannot set a breakpoint in that particular if statement inside the for loop why is that. for(index =1; index < 100; index++) { For ( i = 0; i < 20; i++) { for (j= 0; j < 10; j++) { //do some processing if(index == 10) { //do something ----------->Visula Studio says she can't set a breakpoint bcoz of invalid line. } //end of j for loop }//end of i for loop }// end of index for loop will some of help me what this is. cheers arun Hi, thanks for your reply. i actually properly teminated the for loop and with proper spelling. i am confused about wht u mean by actually statement. In this following code R[indexer ]++; g[Indexer ...Show All

• .NET Development Issues with a timestring and arithmetic in C#

  Hi. A few months ago, someone pointed me in the direction of using ParseExact when processing time formatted strings. I have used it only a couple of times, then today, I hit upon an unusual problem in the C# language and am a bit stumped as to what to do to fix it. This next bit of code contains a segment which adds a Time formatted string as HHmm and subtracts HHmm, returning string Minimum/Maximum (this part works fine): TimeSpan MinTime = DateTime .ParseExact(TimeString, "HHmm" , CultureInfo .CurrentCulture) - DateTime .ParseExact(ConnectionTime, "HHmm" , CultureInfo .CurrentCulture); Minimum = MinTime.Hours.ToString( "00" ) + MinTime.Minutes.ToString( "00" ); TimeSpan MaxTime ...Show All

• .NET Development problem converting PDF to Xml

  Hi all, I am trying to convert the PDF document into xml document while I converting the document some of the characters(fi ,fl ,ff,(,) ,<,>,--> ;) were not properly converted. Is it possible to solve this problem , if we can could any one plz tel me how can I convert to xml same as PDF content. Thanks, ram krishna Joe thanks a lot for your early replay im trying to do this simply open the PDF document and I make it saved into as a .xml format. If the word like “first“ in pdf document ,its displaying like ” rst “. Where ever the fi,ff,ff,<,>, is their that symboles replaced with "box" symbol . here are the some of the examples what i am getting in xml: differen ...Show All

• Smart Device Development ActiveSync DragDrop

  I would like to drag and copy files from my program's implementation of a RAPI-derived explorer to MS's ActiveSync Explorer. I've identified the IDataObject FORMATETCs and data structures though I cannot duplicate them precisely (it seems that the data associated with the cfstr_filegroupdescriptor formatetc is actually "nested" within the HGLOBAL of the "HPCFileGroupDescriptor" - something I do not know how to do). In my COleDragSource-derived class, I've implemented OnRenderFileData, which works when dragging mobdev files to any non-remote locations in Windows Explorer.  ActiveSync Explorer, on the other hand, will reject the IDataObject in its OnDragEnter mechanism.  Oddly though -& ...Show All

• SQL Server Execute Remote Stored Procedure from the receiver's queue

  How can my receiver's queue procedure execute a procedure on another server Everytime it gets to that remote procedure statement, I get DISCONNECTED_INBOUND status. The procedure I want to call is on SQL 2000. The problem was not the security at all. I couldn't execute remote stored procedure when it's in a transaction. For now I have to remove the begin tranaction/commit from the Target's queue procedures.. It's working now. ...Show All

• Windows Forms c# and .mdb or any other database application

  I am working on a project that I will be using Microsoft Access to store data. When I package this software, is there a Microsoft Access Runtime I can include that will allow other users to use my software without having Microsoft Access Installed Hopefully that is clear enough. My software uses Microsoft access but if a user does not have Access or a runtime they will not be able to use my software. Thanks in advance -Mike Are you saying "access runtime" errors are not directly associated with their corresponding .dll's Are you also saying the com objects that are imported are not referencing Access application .dll's If the applica ...Show All

• Windows Forms How to change the selected value

  I need to change the selectedvalue, of the comboBox by passing in the new value in a fucntion but i keep getting object ref not set to instance of an object.....If I change the selected value in the combobox will it change the Display member based on what selected value i pass it...check out my code and see if you can tell me where i am going wrong... public static void DisplayStopDetails( int StopID, string TypeOfStop) { Tracking.UI.MainWindows.StopOrderLegDetailsForm frmStopDetails = new StopOrderLegDetailsForm(); frmStopDetails._StopDetail.StopID = StopID; frmStopDetails.cboStartingPoint.SelectedValue = frmStopDetails._StopDetail.StopID; //frmStopDetails._StopDetail.StopID = ( int )frmStopDetails.cboStarti ...Show All

• Windows Forms String.Format() problem

  Hi Is it possible to fill a remaning area of a string with a specific character For instance: String .Format ("{0,-15}" , "My Text" ) The output is: "My Text " I want the remaning of that string ( " " ), to be "---------" . Is this possible using String .Format() And instead of doing: for ( int i=0; i<10; i++) str += "-" ; Maybe this can be replaced with String .Format() somehow Kind Regards Haven't tried this yet. But you can refer to http://msdn2.microsoft.com/en-us/library/26etazsy.aspx . Hope this helps. ...Show All

• Visual Studio 2008 (Pre-release) LINQ CompareWithBaseline ?

  In LinqToXsdDemo.XsdPrimer.Typed sample code, what does the following line do po.CompareWithBaseline( "XsdPrimer.xml" ); I can not find any documentation or Help on the function CompareWithBaseline anywhere. VSTS 2005 does not seem to be able to find the definition for it. This is not part of LINQ to XSD but an extension method defined in LinqToXsdDemoAssertions. It looks like it's for regression testing. I've used this trick myself :) Joe ...Show All

• Visual Studio VS 2005 critical error, I may need to reinstall windows

  I installed IE7 then .net framework 1.1 SP1 above VS2005 then I detected the problem When I open data sources tab then I click on "Add new data source" it opens a dialog box named "Data Source Configuration Wizard" I click on database option then I click "Next" button I encounter an error msgbox saying: An unexpected error has occured. Error Message: Key not valid for use in specified state I don't understand what does this error means I tried to repair the VS 2005 but no change then I uninstalled vs2005 and reinstalled it but no use I removed framework 1.1 sp1 but didn't make a change ...Show All

• .NET Development difficulty accessing Excel spreadsheet via ODBC

  trying to access a spreadsheet on a network share. ODBC connection string: "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DefaultDir=\\sdi-fs2\Bypass\4ANAMEDONOTDELETE;DBQ=\\\sdi-fs2\Bypass\4ANAMEDONOTDELETE\0e89da37-180c-4214-af37-632cce8dc476.xls" Produces the following error: ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x7b4 Thread 0xabc DBC 0x348274 Excel'. ERROR [HY000] [Microsoft][ ...Show All