Jakein2006's Q&A profile

• Visual Studio Tools for Office Weird installing error...

  Hi, a (potential) user of my plugin received a weird error when installing, and the installation hasn't complete so...this is his email: Hi, about the version...the user wrote me this: --- I used to have XP, but upgraded to 2003. Right after that is when I first attempted the RC installation. --- HTH LastHope ...Show All

• Visual Basic Where is the Fill() method?

    I am trying to add new rows to MyDataBase.mdb with the below code. My problem is that it does not identify the columns. It fails with the error message “Name1 does not belong to Customers”. But it does so do Name2. I think it’s locating the database and table as I can retrieve data with the open code using SQL Select.   Can anyone help Please hemo   Dim connection As New OleDbConnection()         Dim myadapter As OleDbDataAdapter         Dim myDataSet As New DataSet          Dim newrow As DataRow         Dim MyTable As DataTable &nb ...Show All

• SQL Server DB index performance

  I'm not an index expert, but I think I need help from one. I have a table with 4.9 million rows. Its PK is a composite key on 2 unique FLOAT columns. The floats are actually long ints; there are no decimals. The 2 fields are a LOW and a HIGH, and together they define a unique numeric range. Given a number input, I need to retrieve THE row where the input number falls within that row's LOW & HIGH range. Here's essentially what I'm doing: SELECT * FROM theTable WHERE @inputNumber BETWEEN RangeLow AND RangeHigh My question is on the best way to do the indexes -- right now I'm getting results, but the query takes a good 15 seconds. Isn't there a way to make such a search faster, even though there are tons of rows ...Show All

• Software Development for Windows Vista Package Load Failure after installing VS Extensions for Workflow

  I saw this problem during the WF betas, but now I have a new machine with a clean install of VS2005. I installed the ".NET Framework 3", "Windows SDK for Vista", and then the "Visual Studio 2005 Extensions for Windows Workflow Foundation" (in that order). After installing these components, I receive the following error when I open Visual Studio: Microsoft Visual Studio Package Load Failure Package 'Microsoft.Workflow.VSDesigner.DesignerPackage, Microsoft.Wirkflow.VSDesigner, Version=3.0.0.0 Culture=neutral, PublicKeyToken=31bf3856ad364e35' has failed to load property. ... Would you like to disable loading this package in the future You may use 'devenv /resetskippkgs' to re-enable package loading. ...Show All

• SQL Server Dynamic transformation to upload flat files into database

  Hi, My scenario: I have 4 different flat files types each having different no. of column, order of columns etc. I want to upload all the 4 types into the same destination table in the SQL database. Before uploading I need to apply transformation to each column in the flat files. The transformations could be like 1) Multipying the source column by 100 2) Put an if condition for 2 source columns and then select one column to be copied into the destination. I have the flat files schema with me and also all the transformations that are required. Question: Can SSIS provide me with a component that can read the flat file schema and the transformations from the database and apply them to the source data and then upload it to ...Show All

• SQL Server Getting SQLDependency to fire the OnChange

  After many problems with permissions I have got got SQL to accept a notification request but the public static void OnChange(object sender, SqlNotificationEventArgs e) is never triggered. The notification registers and de-registers ok. The same connect string successfuly connects to the same database to process queries. I can see the GUID suffixed stored procedure, queue and service being created. Where does SQL2005 store the address/name of the routine it is to trigger (When the notification is cancelled, the guid-siffixed items disappear) I have looked at the generated stored procedure, queue and service, but there is no indication of what is to be called back. I have followed the instructions at http://msdn2.microsoft.com/en-us/library/ ...Show All

• Internet Explorer Development IE7 cookie problem

  Can anyone help with the following. When I log on to a web page, a session is created and saved using in-proc cookies which are saved in the IE7 client browser. When a new window is opened in the same session and then closed, the cookies are deleted and the session is lost, even though the first window is still opened. The session was not closed. This happens only on certain PCs, not always and only with IE7 . This problem is only with IE7, all other browsers are ok. Is this a problem we have to put up with or will it be fixed by the IE developers greetings Please take a capture with Fiddler ( www.fiddlertool.com/fiddler/help/log.asp ) and send it to me (ericlaw @ microsoft). Thanks! Eric Lawrence ...Show All

• Visual Studio Express Editions Another dumb? question from WillGeorge. Displaying a MessageBox from a DLL.

  About throwing a Exception.. I HATE those becaue they never tell me where it came from! Is it bad coding to present a MessageBox from a DLL rather than just throw the exception Not that my message would cover everything to do about it (I guess I could try but probably not smart enough) but at least I could tell the user what file/method/Etc. it came from. Sorry, Just me! Have a great day! Generally: yes, it is bad coding. The exception ought to be handled by the method that called the DLL class method that threw the exception so it can properly respond to the "it didn't work" outcome. You *can* find out where the exception came from. In the IDE, click on View Details and inspect the StackTrace property. I usual ...Show All

• Visual Basic Advanced VBA (with Excel) calculation using the GPU

  Hi. I'm chemichal engineer and I work with VBA on Excel. I need to do a large amount of calculus (obtaining between 500 thousand til 16 million, not counting iterations) so I’m searchin' the way to use GPU as a second processor (I'm not working with gaphics) to accelerate my work. Is this possible Thanx. These forums are intended for VB.Net development and your description describes a solution using Excel. Excel uses a version of Visual basic called VBA (Visual Basic For Applications) which is the internal language within Excel. This is not the same as VB.Net Your question is therefore off topic for these forums. You may find more assistance in following which specifically deals with VBA / MS Office development. The ...Show All

• Audio and Video Development Programmatically setting the default playback device (and recording device)

  Under Vista is there a way to set the default playback device programatically I've searched through the APIs but I'm not seeing it. For example, there is a method IMMDeviceEnumerator::GetDefaultAudioEndpoint(), but there is no corresponding IMMDeviceEnumerator::SetDefaultAudioEndpoint(). Can I do this through the endpoint properties Thanks for the info, Larry. I think we cross-posted because I didn't see your post when I started my last reponse. It's true there wasn't previously an api to change the default device, but the OS did not prevent us from setting our device's audio path (under XP, we can control the recording source by setting the value of a Mux control). Under Vista we can set the input li ...Show All

• Visual Studio Team System Question on merging through the API

  Hi, I have a small application that merges files between two folders. To do that I'm using the merge method of Workspace class This is the way I'm using the method: workspace.Merge(sourceFile,targetFile, VersionSpec.ParseSingleSpec( CSNumber, null), VersionSpec.Latest , LockLevel.None, RecursionType.Full, MergeOptions.ForceMerge); My problem is in cases that I'm trying to merge between two files That the change on them (ChangeType) is: Rename or Delete On these cases the application fails. There is a way to merge this kind of changes through this method – workspace.Merge Thanks in advance, Shmulik. I know you can't merge a delete by passing the deleted i ...Show All

• Windows Forms VB2005 Multiple Columns in combobox

  Hello, How do I get multiple columns in a combobox Thanks in advance... http://www.codeproject.com/vb/net/multicolumncombo.asp ...Show All

• Visual Basic Connect to Access Database

  Please any one can help me to connect to the access database , that is in the web which i want to connect using a windows application. He was looking to connect remotely using ADO.NET. The obsolete MS Remote provider technology is not supported by ADO.NET OLEDB. You can use ASP and ADO as you have indicated. ...Show All

• .NET Development System.IO.FileNotFoundException

  I've recently got my application to a point where I can test, and have tried to deploy to a fresh machine.  The machine has .NET 2.0 installed and all latest service packs but I'm getting this error when I try to run the program. Since I last tried running this on another machine, I've added a reference to a Web Service into the application.  I checked the config file, and it definitely points to my server machine.  I've read on the microsoft support site about making sure the %windir%/temp file has full control to ASPNET user (I'm using IIS running on Xp Pro), but that doesn't make a difference.  Do I need anything else installed on the client PC  The error happens as soon as the application starts, not w ...Show All

• SQL Server cascading parameter help

  I a report that will have two parameters (Year and Account name), I'm having trouble setting up the second parameter to be filtered based on the value of the first parameter. here is the second parameter with a value hard coded.(see bold text) this works fine when I run the report. WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , FILTER ([CUSTOMER JOB] ...Show All