Dwatney's Q&A profile

• SQL Server Connect To Oracle 64 Bit using SQL Server 2005 64 Bit

  I'm using SQL Server 2005 64 Bit and having a problem when I try to make a linked server to Oracle 10G 64 Bit (installed on the same server) from management studio. I'm using "Oracle Provider for OLE DB" to connect to Oracle 64 Bit database because it is the only provider but from what I've read in Books Online that the provider doesn't support for Oracle 64 Bit. When I’m using SSAS 2005 and try to connect to Oracle 64 Bit database, an error message appear when I’m using “Microsoft OLE DB Provider for Oracle”: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are ...Show All

• Visual Basic Getting the body of an email

  I am in the process of writting a class that will download email from a pop3 email server and extract various parts of the mail, insert it into a database and do other stuff. The problem I am having it getting the body cleanly out of the mail. I have tried a few things but I keep ending up with parts of the string a really dont want. The main problem I have is removing all the 'NextPart' sections. If anyone has ever done this before maybe they can point me in the right direction. I'm using vb.net in visual studio 2005 Cheers ...Show All

• SQL Server Merge 2 columns from the same table

  Hi *, I have a table with 2 columns A1 and Firm. A1 holds "dirty data" and there are no NULL values. Firm holds "clean data" for some of the rows in A1 but not for all. So there are quite a few NULL values in this column. I want to replace the value in A1 if there is any data in Firm (value <> NULL). Rigth now, I solve this issue with a simple VB.NET script: Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) ' If Row.Firm_IsNull Then Row.Standard = Row.A1 Else Row.Standard = Row.Firm End If ' End Sub End Class Any ideas how to solve this issue without custome code Thanks! It sounds to me like you can use Derived Co ...Show All

• Windows Forms Format columns in the .NET Winforms Datagrid

  Hello, I used a tableStyle to format my columns in my datagrid. DataGridTextBoxColumn dcFinalDate = new DataGridTextBoxColumn(); dcFinalDate.HeaderText = "Final date"; dcFinalDate.MappingName = "UGFNDT"; dcFinalDate.Width=100; dcFinalDate.NullText=""; dcFinalDate.Format="####/##/##"; tableStyle.GridColumnStyles.Add(dcFinalDate); It works good if there is a string entered, fe: 20060202, it will be 2006/02/02. But when there is no string (because the field is not required), then I'll get // .... How can I get rid of that Greets, Dirk Perhaps a usefull remark. The data resides on a AS/400 where the data is stored as : 20061008 (decimal value) ...Show All

• Visual Basic Exit & Clise VB.NET 2003

  Hi dear I have a form as parents with some menue my menue form names form1 as parent and my child form names form2. 1. How can I activate the "CLOSE item" when I click on to close the child form1 and when I click on EXIT it close all the application. thanks for your help to close the application: Application.Exit() this will correctly close and exit your application. In regards to your first question, I don't quite follow. Are you saying that you wish to close a form that you have opened from the menu ...Show All

• Software Development for Windows Vista Access Denied when Vista wakes up from Stand By

  I am having the following problem consistently: - running Windows Vista Ultimate (final version) on Dell new XPS-M1210 Laptop - Vista connects successfully to shared folders on a different computer running Windows XP SP2 - when Vista goes to stand by or hibernate which makes it loose it's wifi connection for a while, and after if wakes up from stand by, Vista cannot connect the the same shares on the Windows XP computers. I get the message ACCESS DENIED. I have to reboot Windows XP or manually terminate the session of Windows Vista in order for Vista to be able to connect again. Any idea what the problem is and if there is a fix to download to resolve this problem. alexmo@exmsft.com This forum is geared for soft ...Show All

• Visual C++ crt_time.cpp(27) : error C3861: 'exit': identifier not found

  Hi All: The story so far: This is the third time I've tried to Install C++ 2005 Express. It is Not Very easy to install. Also diffcult to compile. The sample program source is from: http://msdn2.microsoft.com/en-us/library/a442x3ye.aspx Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50727.42 for 80x86 Copyright (C) Microsoft Corporation. All rights reserved. crt_time.cpp crt_time.cpp(27) : error C3861: 'exit': identifier not found crt_time.cpp(40) : error C3861: 'exit': identifier not found F:\PROGRA~1\MID05A~1\VC\bin>snap REM CRT_TIME.CPP 4:01 PM 6/24/2006 // Sample from: http://msdn2.microsoft.com/en-us/library/a442x3ye.aspx // http://lab.msdn.microsoft.com/productfeedback/viewfeedback ...Show All

• SQL Server Copy objects with DTS Import/Export Wizard?

  Has the functionality of copying objects using the DTS Import/Export Wizard been removed in SQL Server 2005 MSDN says this about the wizard: "With the DTS Import/Export Wizard, you can transfer database objects such as indexes, views, roles, stored procedures, and referential integrity constraints. For more information, see Copy SQL Server Objects Task ." But the "for more imformation" link describes adding a task to a DTS package to copy an object, not how to use the wizard to copy objects. It's been awhile since I've used SQL Server 2000, but as I recall it was possible to copy objects as well as data using the DTS Import/Export Wizard. Thanks, Ron I now use MS Database Publishing wizard ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Generate random numbers for every class instance

  I'm trying out some AI techniques but I'm having a problem generating a TRULY random number. I create 20 instances of an ant class that should move and change directions on a random basis. They are doing that, but all in unison instead of each changing directions at different times. Its like synchronized ants. Anyone know how to create a truly random number each time the ants use this method Random r = new Random (); if (r.Next(100) < 5) ant.Speed = new Microsoft.Xna.Framework. Vector3 (-ant.Speed.X, ant.Speed.Y, ant.Speed.Z); if (r.Next(500) < 2) ant.Speed = new Microsoft.Xna.Framework. Vector3 (ant.Speed.X, -ant.Speed.Y, ant.Speed.Z); Just a little minor detail: you co ...Show All

• SQL Server Calling a SSIS package via SQL ServerAgent

  Hi, I was looking at a previos thread in this very queston and the answers given to it, I tried a SSIS package that works fine on its own but on creating a new job and invoke it, the JOB fails ,it says its not able to locate the file specified, I tried copying the package to the server machine wher am creating the job,but again the same error; and when i try to alter the protection level of the SSIS package to Server Storage its throwing an error like '' This protection level cant be applied to this destination,The system can't verify that the destination supports storage capacity. this error occurs when saving to XML." I am using OLE DB Destination in the dataflow task of the SSIS package I ve created. Please guide whr am going w ...Show All

• SQL Server Parameter All Level

  Hello, I'm using SQL Server Reporting Services with an Analysis Services Cube. My current report has a query based parameter. The query returns country codes and the ALL-Level of my country dimension. Is there a way to remove the ALL-Level of the result set of the query How can I realize this Thanks in advance. Christian Hi, I suggest to change the query. I think, your generated query looks like: WITH MEMBER [Measures].[ParameterCaption] AS '[Country].[Country].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Country].[Country].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Country].[Country].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption] ...Show All

• Visual Studio Team System "Add" operations not appearing in VS 2005 when performed from VS.NET 2003

  Our development shop uses VS.NET 2003 with the MSSCCI provider plug-in. One of the big drawbacks of the plug-in is that it breaks up check-in operations into separate changesets, making documenting those changesets more difficult. One of the workarounds I had come up with involved refreshing the VS 2005 Pending Changes window. This would show all pending changes that needed to occur in VS.NET 2003, or so I thought. It turns out that only edit operations are visible from VS 2005 in this case. This means all add and delete operations need to be treated as separate changesets. Is there a workaround for this other than upgrading to VS 2005 I figured out how to get it to show pending changes. I must be ...Show All

• .NET Development Windows Server2003 Web Edition and .NET 2.0

  This may be a dumb question, but I couldn't find the answer with a forums search. I am currently searching for an OS for serving computer. I ran accross Windows Server 2003 Web Edition, which pretty much is exactly what I need it for. The problem is, according to the 'compare server 2003' page, Windows Server 2003 Web Edition has NO support for .NET2.0. Now, does that mean that the OS package I purchase will not have .NET2.0 already with it, but I have the option of installing it from windows update/distributable package OR that I will never be able to install .NET2.0 on windows server 2003 web edition due to whatever reasons. If the former, I'm perfectly content to have install it after the fact but, if it's the latter, well then I'm b ...Show All

• SQL Server Reporting off of a Database Mirror

  All, I have created an asynchronous database mirror and a snapshot of the mirrored database similar to what is described in the following article: http://msdn2.microsoft.com/en-US/library/ms175511.aspx The article says that once you create the mirror that "At this point, new client connections can be programmatically directed to the latest snapshot." My question is, how can you programmatically direct connections to the latest snapshot Does anyone have a suggestion, or know what the article is getting at We will use SQL Server Reporting services to query off of the database snapshot. Thank you, Racer-D And programatically means that you can do one of two things. You can eithe ...Show All

• Visual C# Delete Access Denied!!

  I'm using the codes below trying to delete files and I got an error that say I'm trying to delete a file that still being used by another process. Please help me how to check which files are being use and skip over that and delete everything else. Here is my code so far, thanks in advance. foreach (DirectoryInfo Dinfo in dirInfo.GetDirectories( "*" )) { foreach (FileInfo file in Dinfo.GetFiles( "*.*" )) { try { file.Delete(); } catch (FileNotFoundException e) { Console .Write(e.FileName.ToString()); } } } Thanks Jason ...Show All