millie_w's Q&A profile

• Visual Basic Argument 'Start' error

  I'm trying to connect to oracle db from my migrated VB.NET application (VB6 -> VS 2005). At connect command, I get the following error: Argument 'Start' must be greater than zero I'm not able to locate the source of this error. Code like this generate just such an error message: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click On Error GoTo fail Dim s As String s = Mid("Hello world", 0) Exit Sub fail: MsgBox(Err.Description) End Sub ...Show All

• Visual Studio Team System DateTimeControl

  I received a report that the calendar control in the work item edit form is "extremely dysfunctional and is basically unusable" and I must agree. Are there known issues with the winforms DateTimePicker in work item editing When you say Calendar control, do you mean DateTimeControl Can you detail more on why it is dysfunctional I am not aware of any issues with DateTimeControl and if you know of any I would be happy to raise bug on them. ...Show All

• .NET Development Application blocks.

  Hi, I have a query regarding .Net application blocks. I have created one application using logging application block and have to deploy it on the client machine. Do I have to install Enterprise libary on the client machine also or only dlls would be sufficient to run the application on client machine Regards, When you create package of your application, it should take required Application Block's dlls as dependancies. On deployment on client machine, it should work fine. So, only the dlls should help, you do not have to install enterprise lib there. Secondly if you are writing log in database, you might need to create database for that. And if it is in EventLog, you might have to take care of the access rights. Hope thi ...Show All

• Visual Basic Currency issue with bound objects -I think

  Problem: two textBoxes are bound to two fields in a datagrid.When the text in the first textBox is deleted and replaced , and then the second textBox text is deleted it deletes the text in the first text box(or moves its value back to what it was prior to making the change).Note that if I just modify the text it has no affect on the other textBox-only when I have had a prior deletion. Specifics: the mouse click in the text boxes show a month calendar from which a date is selected and shown in the text box. A keydown event is used to pickup if the "delete" key is hit, and if text is selected it removes the text from the text box and from the dataSet as well(could not get it to delete text by just removing from textBox). ...Show All

• SQL Server metadata update

  hi, I try to post a new question about metadata refresh...even if i see other thread that work on a similar problem. I have a ssis package that import an xml huge file (500 mb); These are the main step: 1) generate a XSD file against xml using xsd.exe utility 2) using xml task, make a diff between the old xsd and the new 3) if there are no difference, I start the data flow task that import xml in sql server; otherwise I stop all the task, edit the data flow task, change the xsd reference in advanced editor and then make many "double clik / OK" on every single flow.... The underling idea is that xml file change because some columns are added but these columns are not interesting for my elaboration, so i can ignore t ...Show All

• Visual Studio Express Editions reading a file...

  How to read a powerpoint file in visual basic I don't have office to be installed in my computer. So without crearing the powerpoint object i would like to get the title of each slide in the powerpoint or slide index which uniquely identifies the slide. plz someone help me in this. ...Show All

• Visual Studio Express Editions your sql server installation is eaither corupt or has been tampered with (could not open SQLEVN70.RLL)

  i have tried un installing it and re-installing it over and over and there is no change! please help me! This is what the post says: Hello pchservicesIN, you could try a few things 1. if you go to start->settings->control panel-> add remove programs is there an option to uninstal sql server run it, then reinstall sql server + reinstall SP3A and try again to boot 2. do a system restore to before where the problem began, but maybe think twice because if 3 is correct then you end with the Office installation problem again [think the next one is far off but anyway] 3. this error could also be caused by renaming a PC or server in the network that is running SQL Server 7. - use the SQL Server CD to run setup - you get promp ...Show All

• SQL Server Task Upgrades, Update and CanUpdate methods.. Why?

  I am writing a new version of a task with and additional property, and wish to support upgrades between the versions. I have implemented the CanUpdate and Update methods, and update the Xml for the new property. The problem I then have it LoadFromXml gets called which promptly fails since it is still using the old version of the Xml. Have I misunderstood the point of the Update mechanism It would seem to me that I’d better off ignoring Update and implementing the checks defaulting my new property within LoadXml. The new version of SaveToXml would sort out the upgrade when saved again. I'm trying to implement the Update and CanUpdate methods on a Custom Control Flow Component.  When I attach the debugger to the devenv.exe that ...Show All

• SQL Server waittype NETWORKIO blocking spid on SQLServer 2000

  I have a series of processes being blocked - after running sp_blocker_pss80 I can see that the blocking spid is coming from a batch program that is issuing a 'sp_prepexec' event and has a waittype of NETWORKIO. It looks very like the problem fixed by hotfix: 884554 in SP4. The db is SQLServer 2000 and running the following command: SELECT SERVERPROPERTY('ProductLevel') GO Gives the result SP4 So I guess I have the hotfix but I'm still experiencing this problem. The event that is 'blocking' is a select statement on a large table. Running the same batch process on identical data in a test environment doesn't give the same problem. I'm not certain that other processing on the test environment is identical though so it is ...Show All

• Visual Studio Tools for Office MAPI - Proper use of IMessage SaveChanges() flags?

  I've read the MSDN docs for IMessage SaveChanges() method: http://msdn.microsoft.com/library/default.asp url=/library/en-us/mapi... and it says you use KEEP_OPEN_READWRITE to keep the item open after saving changes, and if that fails with MAPI_E_OBJECT_CHANGED you should retry with FORCE_SAVE. And it appears if you call SaveChanges with KEEP_OPEN_READWRITE followed later by another identical call, then you get the MAPI_E_OBJECT_CHANGED error. But in the real world of coding, if you have some complex logic it's quite likely you'll refactor code into several methods which could be setting properties and custom properties and you cannot necessarily guarantee the order of each method or whether they are called at all. In this ...Show All

• Software Development for Windows Vista Media Player style panel

  Hi, I want to create a panel that has a background like the Windows Media Player 11 toolbar or the Windows Photo Gallery, but I have no idea how to paint this. Just to make this clear the problem is not where or when to paint, I just don't know how I can get this glowing gradient. Any help with this (no matter if for WPF or WinForms) would be great! You can use the Media::Rebar theme class, see AeroStyle.xml in the SDK. You can open the class itself with OpenThemeData(), or send RB_SETWINDOWTHEME with "Media" to a rebar control. ...Show All

• Visual Studio the download En_vs_2005_Pro_90_Trial.img is downloaded is only 1kb in size

  I downloaded Visual Studio 2005 Professional Edition 90-DayTrial from Mircosoft and it was 1 kb big. En_vs_2005_Pro_90_Trial.img this not the 2.8g it is supposed to be i think it is corupt alternate host please I get the same problem with IE - a little window appears, I am prompted to save the file, only to find that it is 548 NUL bytes. No amount of flushing caches solves this problem. My solution was to use firefox (2.0.0.9). Honest. I am not trying to troll given that this is an msdn forum! So the file is not corrupt, but some (common) configuration of OS/IE means a large chunk of users can't download. Come on MS - what's happening ...Show All

• SQL Server How to sort a table with a parameter

  I have a "Sales shipments" report with several colums. I want a parameter for the user so he choose how to sort. I have two colums in my report I want to sort on: ItemNumber and DeliveryDate. I added a Report Parameter UserSort with two labels (and values): Item (ItemNumer) and Date (DeliveryDate). Then I tried to set the sorting There is a good walkthrough for this here: http://www.databasejournal.com/features/mssql/article.php/10894_3492236_6 The key is this statement: "border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 70.2pt;" valign="top" width=& ...Show All

• Visual Studio Team System report of links between work items - does not work properly

  in search of a report that shows me the relations between the work-items i have found the report "related work items". but this report doesnt show me all relations. and sometimes the report don`t show me any relations. i expected that this result will show me all relations that i have defined in a work items "links" column. is this correct or do i have to use another report in the Administration forum i get an answer, that said, that i have to call a webservice which updates all the reports. but i have restarted the server and so i expect that all reports are up to date. Hi Thomas, Updating the Warehouse every 10 minutes shouldn't really be a problem but there are several factors ...Show All

• SQL Server To find out empty tables in a database

  Hi all, I have a database which gets its daily feed from a ftp file. Now is there any way i can figure out the empty tables in the databese which doesnot get any data on the feed. Thanks in advance, the quickest way would be to run SELECT COUNT() against every table. The only limitation of this method is that your tables must be static otherwise you would have to write some dynamic SELECT COUNT() statements using dynamic SQL. I am sure there is a value stored in the system/dynamic tables as well but I dont know of it's location offhand. Derek ...Show All