emd7's Q&A profile

• .NET Development file opened exclusively error, re-use datatable when new text files are created

  I am writing an application that watches a folder for new comma-delimited ascii files. Whenever one is created, I read it into a datatable, compute some statistics, write them to a log file and get ready for the next file. My code works great for the first few files, but starts throwing unhandled "file opened exclusively by another user" oledbexception errors after 4-5 files. The error always occurs at the adaptertext.fill(dtModel) line. Any help is much appreciated! My code is as follows: '**** Private Sub newasciifile(ByVal source As Object, ByVal e As System.IO.FileSystemEventArgs) Dim selectfilename As New System.IO.FileInfo(e.FullPath) Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Sour ...Show All

• SQL Server ?'s about Access .mdb's <-> 64-bit SQL 2005

  Here's what I need to make happen: Our web app users need to be able to import/export data from our 64-bit SQL 2005 box to an Access .mdb exclusive to them. Legacy apps dictate we stick with .mdb files. When the [export] package is complete, the site should present the finished exported .mdb for download. This process must be able to run in parallel, since multiple users can execute at the same time. Finally, since we can't afford to buy SQL licenses just to run SSIS packages on the web servers, we have to find a way to accomodate that limitation. I have an SSIS package that handles all the file and data movement, and a web site on a separate server that calls the package. I've gotten as far as checking if the file exists through web ...Show All

• Visual C++ migrating a big vc6.0 project (including dll lib)to vc2005

  I am going to migrating a big vc6.0 project (including dll lib)to vc2005 ,is there any good step to do this migrating. If you can suggest some good website for doing this migrating, that will be great. Thanks Just open the VC6 project with VS2005. It will automatically convert the project. You may have a few issues if you use .lib files and compile errors due to stricter standard compliance. These kind of problems are discussed at length on this forum, use search to find the relevant threads. Good luck. ...Show All

• SharePoint Products and Technologies Can't find Link Data Sources Wizard in SharePoint Designer

  Hello, I'm trying to link data sources in a Sharepoint web page. I found this great article: http://office.microsoft.com/en-us/sharepointdesigner/HA101154041033.aspx However, the instructions don't match what I'm seeing in my trial version of SharePoint Designer. Specifically, there is no "Create a new Linked Source" in the Data Source Library task pane. I was able to create another data library using the "Connect to another library" menu item in the Data Source Library task pane, however, I can't seem to find the "Data Source Properties" for "Configure Linked Source". I'm using a remote service for my SharePoint Services ( http://www.sharepointsite.com ), which I believe is running versi ...Show All

• Windows Forms Cannot get changes from DataGridView

  I am having problems getting the changes from a datagridview. The grid is bound to a dataset. Here are the steps I'm taking: 1. Type text into the first cell 2. Click the save button on the form, which calls: Private Sub SaveChanges() Dim dsChanges As DataSet = dsFlightInfo.GetChanges() ' make sure their are changes to commit. If dsChanges IsNot Nothing Then ' save changes to the database Dim odb As New ABMS.Data.DataSetIO odb.Update(dsChanges, "FlightSchedDetail") odb = Nothing End If dsFlightInfo.AcceptChanges() ' reset the save buttons btnSave.Enabled = False btnCancel.Enabled = False End Sub PROBLEM: dsC ...Show All

• Visual Studio Express Editions so gentle

  I would appreciate any help someone could give me. I have searched this forum endlessly trying to find a way to save 60 or so text boxes on form1 to a file and then later read the information back into the same text boxes. It seems like I have tried every bit of sample code that I can find and nothing works. I have 5 books on VBE and VB5. I am a complete novice at this so please be gentle. Thanks in advance for any ideas/help. Glenn Well... I'll step out. You see, I think your intital approach is not that great and it's going to cause you problems and you will end up building a bi-plane. Why not take it a step at time. Break your problem up into small discrete steps. The first th ...Show All

• SQL Server Dealing with quotes in a quote encapsluated column

  I know this issue has been raised here before, but I have a different angle/question on it. Flat File source, SQL Destination. No column from the source file has a consistent real width, just consistent to be less that the SQL column. Issue: CHAR(12), SMALLINT, CHAR(78), BIGINT "100012",0,"This is the ""Memo"" of the record, it needs to be imported.",12 This row errors out due to the double quotes around the word MEMO. Additionally, the entire package stops processing due to there being a comma in the memo after the quote encapsulation is escaped. Has this issue been addressed in any of the SP's If not, how about this thinking: 1.) Character index the pattern ," and take the ...Show All

• Visual C++ Where do I put my .h and .c files?

  Newbee to Visual C++ 2005. I have some algorithms I wrote for other win32 console applications. I'm pulling out my hair trying to use them in Visual C++. Basically I have a .h file which declares the functions that are in the .c files. These are simple functions, like calculating the area of a triangle and square! VC++ generates a lot of files, not sure where to #include "myfile.h" and #include"myfile.c", or I'd be happy just cutting and pasting the code right into one of the main files directly. I'v tried putting them everywhere, including the Form1.resX underneath this: // stdafx.h : include file for standard system include files, // or project specific include files that are used frequently, but // are ch ...Show All

• Software Development for Windows Vista Composit Activity Problem

  Hiya I have a couple of composite activities with several child activities that build fine with no errors or warnings that won't appear in the toolbox. One of them I have actually used in a workflow (because it used to appear) and the code hasn't been changed. I'm wondering if any automatic updates could be effecting them as they stopped appearing about the time we installed updates. I can get the activities to appear in my own toolbox in the rehosted designer but it wont let me use it. Does anyone have any ideas Hiya Elif Ok, I have tried that and it still doesn't work. Thanks for trying though :) The CodeBefore and Code After are infact in the same namespace and cs file as the LsmParallel class and strangely enough the ...Show All

• .NET Development WebBrowser control in a service

  I know this is an incredibly crappy design, but the only way I could figure to solve my problem. I need to use the webbrowser control in my service to navigate through a set of pages, maintain session, follow redirects, submit forms, all that. For those reasons I can not simply use webrequest. This all works great in a windows app but when I try to port it over to a service then problems start. The major one right now is in my document complete event I am not able to read any of the properties relating to the document, everything throws an invalid cast exception. The control actually will navigate to page but on completion where I would normally parse through the html document, nothing can be done. Does anybody have any ideas on how to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Only 32 primitives drawing correctly.

  I've made a program that draws multiple triangles on the x-z plane. My eventual goal is a hight map but I'm having a problem with the DrawUserPrimitives call. It works fine if I set the number of primitives to draw up to a maximum of 32, but any greater number and I get some very strange random triangles all on top of one another. I looked through the API and found that there was a MaxPrimitiveCount method but that returns 1048575 so I don't think thats a problem. All the values in my array seem fine, if I copy the end triangles to the beginning of the array they display fine (until 33). If I put the loop that fills the array in my draw method and draw one primitive at a time (by just writing to position 0, 1 and 2 of the array) it works ...Show All

• Software Development for Windows Vista Manifest files for Vista

  Hi, For some of the exes of my product, I need administrative privilege. So I embed them in my application with "requireAdministrator". It works fine on Windows Vista and prompts for allow/deny or administrator uname/password as applicable. But the same program has non consistent performance on previous OS versions(XP, 2003 Small business etc). It shows blue screen sometimes for the applications where these manifest files are embedded. One can avoid these blue screens if the embedded manifest file is also present in the same directory as the exe for other OS. I do not want to make my application dependant on the presence of manifest file in the same directory. Is there a way out Is there a tool to find whether an embedde ...Show All

• SQL Server ADO Connection issue

  Hello All, I have made a small application on my system in delphi v7 that uses the ado connetion components and works fine on the remote sql server db. But my client gets a "cannot find server" on his system with the sql server/db local. My connection string this... Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=USER;Initial Catalog=MyDB;Data Source=SERVER01; his connect is... Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=USER;Initial Catalog=MyDB;Data Source=HISSERVER01\APP; I have changed the Data Source to (local) and local, as seen in another post but this had not effect. We have check his MDAC version verse mine and they are the same, save he has sp ...Show All

• SQL Server Tape not available as Backup Device

  I've got a new HP ML370 G4 Server 2003 SP1 with a fresh install of SQL 2005 SP1. I'm trying to create a backup device for the internal HP DAT 40 and tape is greyed out as an option. I have the newest HP software drivers and firmware. The tape drive is seen by Server 2003 device manager and by NTBACKUP. I can backup using that program. Why doesn't SQL 2005 see it I tried a new HP Ultrium tape drive with the same results. Anyone else see this and can recommend a fix TIA Have you tried the steps above to attempt a TSQL backup If so, what were the results Have you looked in Device Manager to make sure that the tape device is working properly ...Show All

• .NET Development Web Service calling another web service - Scope problems

  I have a web service that I wrote and a class library that it uses. A function in it returns a Status object. Now when I call this web service from another web service, I have the Status object from 2 different namespaces. Like the following. Lib.Status and Inventory.Status. These objects are really the same thing, but I cannot assign one to the other and in the inventory one, I don't even have all the member functions that status has in it. Can someone advise on what to do or on a diffent way or doing things so that this doesn't happen. Thanks No... it won't apply in the computers in where the SIE is not registered. The SIE must be registered in the machine.config of client comput ...Show All