lxhvc's Q&A profile

• SQL Server XML DataSource / Designer Dataset definition failure

  hi all, i'm using a webservice as datasource for my report which returns a dataset. i use the following query to get my data: <Query>  <Method Namespace=" http://tempuri.org/ " Name="GetInvoiceData"/>  <SoapAction>http://tempuri.org/GetInvoiceData</SoapAction>  <ElementPath IgnoreNamespaces="true">GetInvoiceDataResponse/GetInvoiceDataResult/diffgram/Invoice/invPosition</ElementPath> </Query> i use the ElementPath element to get the correct datatable of my resultset. and i have a parameter(invID) to get a specific invoice i want. everything works fine when i run this ...Show All

• SQL Server Copy databases

  Hi, Maybe a stupid question, but I'm trying to copy some databases from one server to another. The copy databases wizard says the job is successful and I can see that the job has been done on the remote server. But the copied databases are not there. What do I do Make sure you connected (during the copy) to the right (the same as you have inspected later)instance of SQL Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Pass Report Globals to Default.apsx Through URL

  Hello, Does anyone know how to pass report globals in "Jump to URL" to a .aspx site through URL Thanks for any effort to help out ...Show All

• .NET Development InterOp.Word System.IO.FileNotFoundException

  I am attempting to create a table in Word from VB.Net I have XP SP2, VS.Net 2005, MS Office Pro 2003 SP2 I have the Primary Interop Assembly for Word installed in. WinNT\Assembly\GAC\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Word.dll I have a com reference to Word with Copy Local=False and the Identity= {00020905-0000-0000-C000-000000000046}\8.3\0\Primary I made sure Microsoft.Office.Interop.Word.dll was registered using Regasm I ran a repair on MS Office I tried putting Microsoft.Office.Interop.Word.DLL in my application folder The VS.Net IDE recognizes the Word reference as Intellisense shows Word objec ...Show All

• Windows Forms Masked Edit in TextBox

  I need to control de text that insert the user, but a custom mask, it means that is not a date, or the time or something like that, is a name of a file, an url's adress, and things like, that.  I have fond a component: MaskedEdit. But I can not make my own mask.  Any idea , thank you There is a dotnet version  ...Show All

• Visual C++ How to link to the correct STL library when a third party dll is based on VC6?

  I have a third party dll targeted for VC6 and .net 2003. It worked well with my old MFC application. After it was migrated to VC 2005, it throws an exception of access violation whenever the stl string information in the object is accessed. Accessing other members of the object is OK. I guess it might be linked to the stl.net library instead of the old stl library that the dll is based on. Anyone knows what is the problem  and how it can be solved   Thanks. Thanks. It worked with my test projects. The remaining work is to wrap up the third party dll. ...Show All

• Windows Forms Using Dataset from another form

  Hi all, I am the follow cenario: A form with DataGrid and a Typed DataSet already filled by DataAdapter where I show the data to the user. When I click in the Edit button, I open another form with Textboxes to edit the data. How can I bind the DataSet from the first form to the controls of second form at design time I tried to do the follow: - Create an instance of the Dataset in the second form - Bind the controls to this Dataset - After create de second form as follow: frmLng vFormLng = new vFormLng(); frmLng.dsData = this.dsData; frmLng.BindingContext = this.BindingContext frmLng.Show(); However, the co ...Show All

• Visual Studio Team System (Re)Build bugs with unit tests

  There's an astounding number of cases where the unit testing framework doesn't properly build the units under test. For one of my test projects, it's nearly impossible to get a successful test run from the Test Manager or Test View due to build errors (out of date assemblies copied to test run directory). The only case that seems to always work is setting the unit tests project as the Startup project and hitting Run in the IDE. Are there any hotfixes or other patches available that make unit testing a bit more reliable Anything to look forward to in SP1 Hello Carl I'll be really glad to try to look into your problem, I ju ...Show All

• SQL Server ExecuteSQL task fails and I think it should not

  I setup my ExecuteSQL task to have a "Single Row" resultset.  The query returns no rows.  It fails.  I don't think it should but then maybe this is consistent with the lookup transform piping rows down the error output if there is not a lookup value returned. The error returned is Error: 0xC002F309 at Execute SQL Task, Execute SQL Task: An error occurred while assigning a value to variable "Variable": "Single Row result set is specified, but no rows were returned.". Thanks Allan   highpockets wrote: It took me a while to find this thread that describes my problem. It appears that ...Show All

• Visual Studio Express Editions Won't register...very odd...

  So, I format my computer, re-install everything, VSE included, and then I remember I need a code. I had one, but obviously lost it, so I re-activate my email address to get my code, got the code, put it it, and voila... The reg key you entered is invalid. Make sure you put it in right. Eh The code you got was only valid for the actual installation/user combination and not any other. You will need to register again. Don't worry, it is allowed and free forever. ...Show All

• SQL Server Update errors on a SmallDateTime field

  I am trying to update a table and the DateInactive smalldatetime field is causing errors.  Here are the statements and errors.   UPDATE Categories SET DateInactive = '7/31/2005 15:32', AdminInactivating = 36 WHERE CategoryId = 15 causes ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '7'. UPDATE Categories SET DateInactive = '7/31/2005', AdminInactivating = 36 WHERE CategoryId = 15 causes ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '7'. UPDATE Ca ...Show All

• Visual C# Memory

  Ok. I am using the PerformanceMoniter class to moniter CPU Usage, Memory ect. But in the memory, I only see how to moniter available physical memory. Can someone tell me how to get the total physical memory. Kind of like when you open Windows Task Manager, and look under Performance>Physical Memory(K), and it says total. Can someone tell me how to display that or tell me exactly what that is. Make sure you add the reference to System.Management Project Add Reference .Net Tab System.Management Imports System.Management ------------------------------------- Dim ComputerName as String = " ...Show All

• Visual C++ why does Visual Studio2005 crash on only cleaning a solution?

  Hello, I have a problem to build one dll project. The ide crashes whenever I try to compile it, in fact it crashes before that, it happens when I only  try to clean the project  before rebuild it, Here is the picture of the problem: the Visual Studio Just-in-time debugger popped up again with "An unhandled win32 exception occurred in devenv.exe[1728]". here below is found in the output window before the crash: "------ Rebuild All started: Project: profuisdll, Configuration: ANSI Debug RDE Win32 ------ Deleting intermediate and output files for project ’profuisdll’, configuration ’ANSI Debug RDE|Win32’’  I first reported ...Show All

• Software Development for Windows Vista Page

  How can I set the page size and other PageSetup parameters when creating and printing an XpsDocument PrintTicket pt = printQueue.UserPrintTicket; pt.PageMediaSize.PageMediaSizeName = PageMediaSizeName .ISOA5; seemed like the obvious thing but it is readonly. Thanks Michael penny finally dropped. :) PrintTicket pt = queue.UserPrintTicket; pt.PageMediaSize = new PageMediaSize ( PageMediaSizeName .ISOA5); but the following return nulls:- Double printableWidth = pt.PageMediaSize.Width; Double printableHeight = pt.PageMediaSize.Height; Shoul ...Show All

• SQL Server Full Text "And Not" Fails

  I have set up a simple "ProdTest1" table with 3 columns: ID (int) which is an Identity column and indexed, Name (nvarchar 45), and Description (nvarchar 2000).  I have then entered a single row with the following data: ID: 1 Name: Purple Black Blue Description: Black Blue I have then set up a Full-Text index based on the Name and Description columns. When I execute the following query that row is returned in the query results: select * from ProdTest1 where contains (*,'Black and not purple') I would not expect any returned rows.  Am I missing something I am using Microsoft SQL Server 2000 - 8.00.2039 (Enterprise Edition) Thank ...Show All