somecrazyguy's Q&A profile

• Visual C# ORA-12154: TNS:could not resolve service name

  I am trying to connect oracle 9i through c# and I am getting the following error. Please see the code below. I have created a dsn name using Microsoft ODBC for oracle. I am using .net 1.1. My oracle has installed in d:\ my .net is installed in c:\ can anybody help me what is the problem for the error. try { //string myString= "Data Source=test_data;Integrated Security=yes"; OracleConnection connectionObj= new OracleConnection(); connectionObj.ConnectionString = "Data Source=ArunTest;User Id=scott;Password=tiger;"; connectionObj.Open(); connectionObj.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } Check your ORACLE_INSTALL_FOLDER\Network\Admin for a file c ...Show All

• SQL Server Software architecture

  The Sql Server 2005 Architecture is often described on Microsoft homepage and whitepapers and so on, but I didn't find an illustration or figure that describes the components and their dependencies. Has someone a good link for me I read the architecture topics in the online documentation. But you must admit that an illustration says more as 1000 words. And I know, that Microsoft is able to create illustrations Server Architectures, they did it for the SQL Server 2000: http://msdn.microsoft.com/library/default.asp url=/library/en-us/architec/8_ar_00_1lbn.asp why aren't they so customer-friendly and do the same for SQL Server 2005 Is it tactic or politics ...Show All

• Visual Studio Team System Team Build Fails when Passing Types as Parameters

  When our developers build the solution on their workstations the build completes just fine. However, when a build is performed on the build server there are errors. This typically involves places where attributes are added to methods. The type that is being passed as a parameter is part of the same solution and the project has a valid reference. All project references are standard copy local=false and nothing needs to be installed to the GAC. [XmlArrayItem(Type = typeof(TypeSerializer))] public List < Type > JournaledTypes     Debug.txt from Build Server (None of these errors occur on the developer machines) Solution: Sodexho.sln, Project: SetupHelper.csproj, Compilation errors and warnings Setup ...Show All

• SQL Server SSIS DYnamic Temp Tables

  Hi, I have a database with serveral tables, for example 'customer', I want to update this table with a SSIS package. However, to ensure we don't have issues if the update fails then I've put in an intermediate stage Using an Execute SQL Task I create temporary tables, for example 'customer_tmp'. Data is then imported into these tables. When all the data is imported successfully the original tables are dropped and the temporary tables are renamed, removing the '_tmp' This works fine and I'm happy with it. However, if someone adds a column to one of the tables in SQL server it is lost on the next upload. Similarly I have to hard code creating the indexes into the package as well. Does anyone know how I could copy the original ...Show All

• SQL Server Returning "ALL" records in a query

  I'm building a db to collect equip fault data in SQL 2005 and need to modify my query to be able to select/display "ALL" records. I'm currently using a sp to assign a shift to each record and then have a query to select all records by shift. I'd like to add an option to the query to be able to select ALL records, regardless of shift. I've included the sp & query I am currently using. Any help would be appreciated. Thanks ALTER PROCEDURE [dbo].[p_dtu_Store_Line_Fault_Data] -- Add the parameters for the stored procedure here @AssetID int, @Timestamp datetime, @FaultCode int, @State int AS BEGIN SET NOCOUNT ON; IF @State = 3 BEGIN INSERT LineFaultData (FaultCode, AssetID, StartTime, Duration, Shift) VALUE ...Show All

• Visual C++ Mouse detection for buttons

  Is there a way to detect when the mouse is hovering over a button in MFC What is ur os Win2k or WinXP   Update: Hi, check the following link , may help you(Same problem solved in a different way). http://www.codeguru.com/forum/archive/index.php/t-324436.html   ...Show All

• SharePoint Products and Technologies transfer local moss site to WSS .. its possible~????

  Hello I want to know if its possible transfer local Sharepoint Server 2007 sites (with their funcionality's) to WSS server (there is no Sharepoint Server Portal, only WSS) its possible and how using backup and restore thanks My best regards, I wonder if it's now possible in the v3 products. In the v2 products it was only possible from WSS 2.0 to SPS 2003. The reason it was not possible from SPS 2003 to WSS 2.0 was because of the extra functionality available (even if not used) in those SPS 2003 sites. I would have thought the same would apply to v3 too, but maybe if you restrict the question to only those sites that are based on common template types (so not Publishing for instance which WSS 3.0 doesn't know about) it ...Show All

• SQL Server REnder Reports

  Hi, Can multiple parameterised reports be combined(or rendered) into one PDF or MHTML format How is it done (ReportingServices 2005) Note: The reports generated have same structure but the values in the fields as the input parameter changes. Thanks in Advance Regards, Somu ...Show All

• Audio and Video Development Audio-software Development with DirectX 10

  I wish to develop an audio software (like winamp, jet-audio etc) using Direct X 10. Dear experts, what do you suggest about this Should or should not I go with this Please tell in detail regarding your suggestion. Thanks Well, which API you'll want to use probably depends on what exactly your application is going to do. For instance, if you're looking to write an application that does playback of audio files, you could consider using Media Foundation for this. I'll say that this forum is primarily about Media Foundation, which is the new multimedia platform for Windows Vista. So if your application is going to need to run on earlier OSes, you'll probably need to use a legacy platform (like DirectShow), in which case your b ...Show All

• Software Development for Windows Vista I have a problem..

  hi I am working in a project. Acc. to my scenario, a worker fills a form and then manager approve or reject the worker's request but after the worker fills the form, manager cannot reply the request immediately. The workflow should wait the response of the manager. How to do this break without a problem and how to continue the workflow from that point. Please help me. Its worth working through these 10 hands-on labs if you haven't already as they go through this sort of example. You can download the labs here - http://wf.netfx3.com/files/folders/documentation/entry4919.aspx ...Show All

• SQL Server Connection Issue to SQL Express form VB Express

  Anyone know how to fix this error: System.Data.SqlClient.SqlException was unhandled Class=16 ErrorCode=-2146232060 LineNumber=65536 Message="Directory lookup for the file "C:\Documents and Settings\zimmerman_e\My Documents\Visual Studio 2005\Projects\MGM_REPORTS\MGM_REPORTS\ImportFile.mdf" failed with the operating system error 5(Access is denied.). Could not attach file 'C:\Documents and Settings\zimmerman_e\My Documents\Visual Studio 2005\Projects\MGM_REPORTS\MGM_REPORTS\ImportFile.mdf' as database 'dbname'." Number=5133 Procedure="" Server=".\SQLExpress" Source=".Net SqlClient Data Provider" State=1 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExc ...Show All

• Visual Studio Tools for Office Insert contents of a byte[] or stream object into current word document

  Hi, I am currently working with VSTO for Word and SharePoint 2007. I have extended the Actions pane to provide me with functionality to browse a SharePoint document library. Once the user selects the document from the Actions Pane (displayed in a List Box), I want to insert the contents of that document in the current document at the current cursor position. So far I have been able to read the document from Sharepoint document library in a Stream object. Where I am struggling is in inserting the contents of the stream object in the current document. Can anyone lead me in the right direction as to how to insert contents of a document to the current document I have seen examples of inserting plain text in the document, b ...Show All

• Visual Basic Need to update DatagridView date cell when another cell is edited

  Hi, I have a DataGridView with a Prices column, which can be edited by the user. I also have a date column, in which I would like to automatically insert todays date, when the corresponding Price is edited. So far, the following code works fine, and any edited cell has its colour changed as a flag. The update is handled by the DataAdapter and I can't figure how to introduce todays date into the corresponding cell. Private Sub dgvDimensions_CellBeginEdit( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) Handles dgvEditPrices.CellBeginEdit preEditValue = dgvEditPrices.Item(e.ColumnIndex, e.RowIndex).Value.ToString End Sub Private Sub dgvDimensions_CellEnd ...Show All

• SharePoint Products and Technologies WSS 3.0 Application Templates - Release Timeframe?

  Any word from the product team on when the new WSS 3.0 application tempates will be available I'd really like to look at these before migrating from WSS 2.0 to WSS 3.0. Jeff Lynch MVP Windows Server System - Commerce Server http://codebetter.com/blogs/jeff.lynch Lawrence, Thanks for the update and for getting back with me so quickly. I never saw any post or thread stating the Q1CY2007 release date. I'm really looking forward to reviewing these before migrating my site collections. I hope to use these templates to re-architect our site collections and to provide some additional functionality to our CS2007/BTS2006 e-commerce application. Jeff Lynch MVP Windows Server System - Commerce Server http://codebetter.com/blogs/jeff.ly ...Show All

• Software Development for Windows Vista DirectShow with Managed C++

  Hi, I am trying to use DirectShow with Managed C++ and have compile errors. When including <dshow.h> I get the following error C:\Program Files\Microsoft DirectX SDK (February 2006)\Include\strsafe.h(221) : error C3641: 'StringCchCopyA' : invalid calling convention '__stdcall ' for function compiled with /clr:pure or /clr:safe Therefore I have some questions... a) Is it possible to use DirectShow with Managed C++ b) Is there a Managed C++ sample c) Is there a simpler way to just playback video from my app I am using the following... 1) Visual C++ Express Edition 2) Platform SDK " Windows Server 2003 SP1 SDK Release Notes" 3) Sample from "C:\Program Files\Micro ...Show All