justin_______'s Q&A profile

• SQL Server datatype casting in derived column

  Here is my expression in a derived component: "Failed insert into PONL_WELL. WELL_NO=" + (DT_WSTR,10)PROP_NO PROP_NO comes from ms sql server , and the derived component datatype for this column is DT_WSTR. The destination will be ms sql server, and i have a data conversion after the derived component to cast from DT_WSTR to DT_STR. However, the derived component failed everytime giving me Error: 0xC0049064 at Load Ponl_Well, Derived Column [1342]: An error occurred while attempting to perform a type cast. Anyone know how i can eliminate the data conversion component and just do my string and column concatenation ...Show All

• Visual C++ Class reference data objects

  Greetings- one more annoying newbie question I've been digging with little success finding an answer.. What am I missing between class defined and local defined reference types An example: ----------------------------------------------------------------- public ref class TestNetwork { private : Socket^ clsSocket; public : TestNetwork(); void ConnectEmUp(); } TestNetwork::TestNetwork() { clsSocket = nullptr; } void TestNetwork::ConnectEmUp( ) { Socket^ tmpS = nullptr; Socket^ localSocket = nullptr; // .... lots of working code ... tmpS = gcnew Socket( endPoint->AddressFamily, SocketType::Stream, ...Show All

• Microsoft ISV Community Center Forums Getting the formatted cell value

  Okay, I need to get the formated cell value from a worksheet. For example: Looking at the worksheet the value of a cell is shown as: 12,000 Of course, if I get Cells(1,1).Value and print it to a text file or whatever, the printed value is: 12000 The issue is that I have to keep the comma so as of now I have to write a sub to put the commas back in. Is thre an easier way This'll do it: cellValue = ActiveCell.Value numFormat = ActiveCell.NumberFormat Debug.Print cellValue, numFormat, Format(cellValue, numFormat) ...Show All

• SQL Server Cannot connect to SQL Server 2005 April CTP from remote computer

  Hi, I am trying to connect to a SQL Server on a Windows2003 w/sp1 Server from a remote computer but always seem to get the infamous "Access is denied or Server Does Not Exist" error.  However, if I try to connect from the machine that is running the server, there is no problem. (Used sql account, server=mixed authentication) The windows 2003 Server is a single server installation with .Net 2005 Beta 2 Team Suite, Team Foundation Server and Sql Server - Installing these items  took me a while, but eventually I managed to install from scatch to end without any installation errors. I have triple checked that both TCP 1433 and UDP 143 ...Show All

• Visual C# Communication Between Froms...

  I currently have a form that I am using to store variables/arrays/etc. I have just created a second form. The form is launched when the user selects a button. I have launched the form by simply instantiating the object, like this: Form2 f = new Form2(); f.Show(); However, there is data that I need to retrieve and display from the first form (Form1). Would anyone know how I could go about doing this Thanks, I'm receiving the following error with that code: 'System.Windows.Forms.Application' does not contain a definition for 'OpenForms' ...Show All

• Visual Basic Magic Number???

  I'm trying to decompress a ZIP file using VB 2005. When calling the Read() method on a GZipStream object I get this error message: "The magic number in GZip header is not correct. Make sure you are passing in a GZip stream." I think I'm doing everything by the book. What is this magic number It sounds like the file is broken (doesn't have a valid GZIP header) http://msdn.microsoft.com/msdnmag/issues/05/10/NETMatters/default.aspx http://en.wikipedia.org/wiki/Gzip Best regards, Johan Stenberg ...Show All

• Visual C# How To Send a Mail Using CDO 1.21 with C#

  Hi I try to write a console application in c# whichs sends a mail using CDO 1.21  (I can't use a smtp server). I found a good description for j++ ( http://support.microsoft.com/kb/216723/en-us ), but don't know how to write the cdo parts in c#. I could logon to my profile, but I wasn't able to create or send a message. I would be very happy for a code example which shows how to send a mail using CDO in C# (just a simple console application would be great). Thanks for any help. Ralph The non-simple part of MAPI is also exposed as C functions and structures, so you should be able to wrap i ...Show All

• Visual Studio Crystal Reports XI Release 2 Merge Modules are Out

  Hello all Well I have been waiting for ever for the merge modules. http://support.businessobjects.com/fix/merge_modules.asp Merge Modules for Crystal Reports XI Release 2 .NET Deployments - This file contains the merge modules required for deploying applications using Crystal Reports XI Release 2 for Visual Studio .NET. Merge Modules for Crystal Reports XI Release 2 RDC Deployments - This file contains the merge modules required for deploying Crystal Reports XI Release 2 applications using the Report Designer Component. These merge modules may be incorporated into MSI-based setup packages to include the appropriate runtime f ...Show All

• Visual Studio Express Editions database saga

  I am at my wits end. I am trying to create a program that will add users to a database. I have read the various posts regarding the output file and have changed the Copy To Output File to Copy Never. I have also tried Copy If Newer. The database still does not retain my changes/additions. The code I have used is shown below. Code Here... Private Sub AddUser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddUser.Click Dim newUserRow As Database1DataSet.Table1Row newUserRow = Me.Database1DataSet.Table1.NewTable1Row newUserRow.Name = nameBox.Text newUserRow.Password = Password.Text Da ...Show All

• SQL Server Could anyone attach the AdventureWorksDW to their SQL Server database engine?

  Hi, all here, I got a problem when trying to attach the AdventureWorksDW sample database to the SQL Server database engine. Error occured as: could not find row in sysindexes for database ID 21, object ID 1, index ID 1, Run DBCC CHECKTABLE on sysindexes . The sample database was downloaded from http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en . So could anyone help me to solve this problem tho thanks a lot for any guidance and help. Hi Hellen, Try isntall from scripts.. look this URL on BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/7de6ceb0-be7a-43 ...Show All

• Visual Studio Team System Web test failing RequestFailed: The value of the date string in the header is invalid.

  All webtests I run from VS2005 RTM are failing with a response of: RequestFailed: The value of the date string in the header is invalid. The request looks like this: GET /Angel63/sidebar.asp HTTP/1.1 User-Agent : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Accept : */* Accept-Language : en-US Host : 600m01 Cookie : ASPSESSIONIDSATDSCQA=LMGPKPGDJNEPFDPPJKBKILEP Accept-Encoding : gzip I can successfully run the same test using the beta 2 release of VS2005.  The only thing I can see that is different is that the request is slightly different. Request from VS2005 beta 2: GET /Angel63/sidebar.asp HTTP/1.1 User-Agent : Mozilla/4.0 (com ...Show All

• Visual Studio Tools for Office document_startup problems?

  Hi I'm having some trouble figuring out what happens in my code. Short summary: I have a Word VSTO project, in which im referencing a dll (c#) with one public static method in. In the startup method i call this method. Besides this I have now tried creating a messagebox, and I make sure the action pane is visible and adds some content to the actionpane. If i build a release, and opens the .dot from the release dir, all is fine. All messagebox shows, the action pane is there, and the static method is executed. BUT... when i publish the solution to another directory on our intranet, nothing happens at startup, besides the action pa ...Show All

• SQL Server Returning a cursor from a stored procedure

  Below I have a procedure that runs a query and returns a cursor. Instead of the query I would like to call another stored procedure that would return a query ( in other words I want to encapsulate the query in an SP). Does anybody know how to accomplish this without having the called query return a cursor alter PROCEDURE dbo.b700_test_cur ( @myCursorCURSOR VARYING OUTPUT) as SET @myCursor= CURSOR LOCAL FORWARD_ONLY STATIC FOR SELECT * from mytable -- (I want this to be an SP) OPEN @myCursor return Hi gwt, if you want to give a resultset (and the procedure is returning a resultset, just ...Show All

• Visual C# Wave Recorder - problems with a splitted/joined audio record

  I've written a small application to record data from an audio device to a wave file ( based on this article ). A further function is saving/splitting a recording in several files. If I play the files later back, it should sound as one continous recording, but it doesn't. There are short breaks/clicks in between. It seems that the recording function doesn't capture the input properly. You can find my application/VS project here (22 KB): download Can anyone see what's wrong Any help appreciated! Yes, here is some background information about the 3 files: I played a Sinus tone, recorded this with my app ...Show All

• Visual Basic defining a stored proc for use with dataset using tableadapter wizard

    things look good till I reach the Bind Commands to Existing Stored procedures page of the wizard and I select my target spproc (rpt_IPR_...) then I  hit the finish button and see the message :    invalid object name '#TmpResults' now the dataset seems to setup correctly but was wondering why we are getting this message and should I be concerned. The same proc in Access had no issues. Here is the proc: ALTER PROCEDURE dbo.rpt_IPR_Enhanced @AssessmentID varchar (50), @RaterID int =0, @LocaleID int =1033 AS /*REVISIONS ASH 001 11/24/03 Created based on rtp_IPR_Results, to which this sproc is i ...Show All