Auris's Q&A profile

• SQL Server Calling user-defined functions in OLE DB Command transformation

  Hi We have a user-defined function that can be called directly via SQL (in SQL Server Management Studio) without error. We would like to use this function to populate a column, whist data is being processed within Integration Services. Using an OLE DB Command transformation to achieve this would seem the most appropriate. The following was inserted for the SQLCommand property: EXEC = dbo.GetOrderlineStatus(@dt_required = , @dt_invoice = , @dt_despatch = , @ch_status = , @si_suffix = , @re_quantity = , @vc_invoice_id = , @vc_order_id = ) However, when the Refresh button is pressed we are presented with the error below: Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x8004E14. An OL ...Show All

• Visual Studio Team System Specifying LoadTest Scenarios from Commandline

  Hi, We have several scenarios set up for one of our load tests. In Visual Studio. I just highlight the scenario I would like to run and then execute the test. How do you specify which scenario to run when using mstest to launch the test from the command line Nothing jumped out by looking at the mstest help. Thanks. There is no way to specify to only execute certain scenarios. Even when in the UI, there is no way to specify which scenario. A load test always executes all scenarios, regardless of how you start it. ...Show All

• Visual C++ Combo Box Question

  hi I'm making my first 'simple' application to get me started. its the basic windows Form with just a combo box containg just 3 options ' a or b or c ' ok it works fine but how can i make it remember my last selection i mean when i run the application again it shows nothing and you have to select the option all over again. I got it. You're using VS2003. I can't figure out the old managed C++ syntax to make this work. Maybe somebody else could translate this code back to __gc ...Show All

• SQL Server Report Model Generating Out of Memory Error

  I am creating a report model of a large database with a few hundred tables, the idea being that the users can report on any part of the database and create perspectives for the areas they want users to have access to (In the past the users have moaned about report models in a CA product called Eureka as the models are too small, perspectives seemed a way of allowing one large model but limiting each perspective to a set of users ). Unfortunately presumably due to the size of the model visual studio is giving me an out of memory error when adding new tables. I have a two dual core xeons with 4Gig of ram and I'm running XP Pro 64bit with the developer edition of 2005 with service pack 1 and VS2005 is using around 1/2 a Gb. Is this a known i ...Show All

• Visual Basic VB6 Forms in .NET 3.0 application

  Hi, I've seen a few people talk about how it is possible to extend a VB6 application with .NET forms. However, what I haven't found yet is people talking about hosting VB6 controls and forms in a .NET exe. Is this possible The scenario I have been asked to look at is one where we want to take our existing large VB6 windows app and give it a new shell initially, ultimately convert all to .NET. The application has many many forms as well as quite a few activex business objects. Ideally what I wanted to do was to write a new shell for the application (shell as in main UI, menus and basic naviation) in WPF and then use the existing VB6 forms and contained logic once a menu or command has been selected. I'm not convinced whether thi ...Show All

• Windows Live Developer Forums how to handle error message on geocode?

  i am using the map.FindLocation argument to geocode a bunch of addresses. from time to time, i get an error message that goes like: "the closest match for '***address you entered***' is '***VE's assumed correct address***' If the closest match is incorrect, enter the complete address and try again." i would want to catch this error, and add it as metadeta to the record in the database, so that i know which addresses matched with error. would anybody know how to "catch" the error message sorry if this has been answered before, but i could not find it anywhere. thanks I would read those terms of use closely but also use some common sence. Clearly if you are setting up a bot t ...Show All

• Visual Studio 2008 (Pre-release) Help with styles

  I seem to be missing something fundamental with styles. In the code below, see the Hyperlink cell template for the PublishDate column. When I apply the LinkDefault style, it works great for the first row, but after that all the other cells are blank for PublishDate. It does show an active scroll bar there in the cell , so something is happening, but it does not seem to be showing any data in any of the rows in the GridView except the first row. ------------------ <Window xmlns='http://schemas.microsoft.com/winfx/2006/xaml/presentation' xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml' Width="664.8" xmlns:l="clr-namespace:SDKSample" x:Class="SDKSample.Window1"> <Window.Res ...Show All

• SQL Server Problem connecting to external SQL Server

  Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy! Well not for me .. This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight o ...Show All

• Visual Studio 2008 (Pre-release) User controls from external dll in toolbox

  I'm trying to set up a multi-project WPF solution, but can't get user controls to work: I have one WPF exe, with just a form, and a number of dlls which defines the controls I'll be using on the form - but I can't get the user controls to appear in the toolbox (I get "there are no components in..." when I try to add the dlls). What should I do to make them available Thanks Thanks, that got me one step closer - but I'm still having trouble getting it to recognize my user control. Sorry, very basic stuff, but I'm having a hard time finding appropriate reference material. The samples I've found with external control libraries use .cs files, but I'd like to use .xaml user controls. Is th ...Show All

• Windows Forms Two Questions ...

  I am using VB 2005 to develop a simple windows app. Question 1: The program draws a number of rectangles of varying colors on a System.Drawing.Graphics object ... later in the program I want to determine the color of a particular rectangle whose center, say, is at form coordinates X,Y. I am not sure how to do that. Question 2: When I run this program I see the strip across the top of the app's window with my menu items (File, Edit, Help) but the strip is not blue nor does it have the minimize, maximize/minimize or close buttons in the upper right-hand corner (nor can I drag the lower right-hand corner to resize the window). I must have set some property to cause this but I cannot figure out how to fix it. Thanks for any help to either o ...Show All

• Visual Studio Tools for Office Uninstalling or upgrading existing outlook add-in

  Every time we want to install a new version (with changes) of outlook add-in; if it is already installed we have to first uninstall the previous version by going to add/remove programs. Is there anyway to create installer file that will update the existing add-in The following documentation does not provide any information on how to modify the custom action so that it actually uninstalls the previous add-in and installs the new one. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOWindowsInstallerWalkthrough.asp I think you have several options: 1. You can create windows installer patch (.msp file). Your patch will need to install new manifest ...Show All

• Visual Studio 2008 (Pre-release) Loading November CTP for WPF and WCF on production development system

  Generally we have a practice of not loading CTP or Beta software on our production systems we use to write code with every day. However we would really like to have access to the WPF features in this CTP and I notice that the download page does not have the normal, do not load this on a production system caveats. Is there any advice on using the November CTP WPF/WCF tools on a production system Thank you in advance. The EULA you're presented with when you install this CTP was updated to cover this topic. It covers the scenarios where you may or may not use this CTP for production applications. I'd encourage you to read the EULA in detail and let us know if you have anymore questions. antonio ...Show All

• Visual Basic Adding an AD User to local System by using WMI

  Hello, I have a ADSI script that add an AD user to local system group (below), It works fine. I would like to convert to WMI and C# ( I can't find any function in WMI can add user to local system.) anyone knows how to rewrite to WMI or C# please let me know Thanks for your help Danny Dim DomainName Dim UserAccount Set net = WScript.CreateObject("WScript.Network") local = net.ComputerName DomainName = "US" UserAccount = "dan10468" Group="Guests" set group = GetObject("WinNT://"& local &"/"& Group) group.remove "WinNT://"& DomainName &"/"& UserAccount WScript.Echo"DONE" Dan1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MDX2.0 Beta Program

  Hi, I am trying to join the MDX2.0 Beta Program but I can not find it in the available connections page. Is the beta program closed now and how do I find mdx2.0 information then I am currently having problem upgrading my MDX1 audio code to MDX2.0. I cannot construct primary buffer as it throws the following exception: System.InvalidOperationException: Nullable object must have a value. at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) According to some thread in gamedev.net it was related to waveformat handling in buffer code. Does anyone have working example for mdx2.0 how to create primary buffer Any help is appreciated. best regards, Tommi Laukkanen Nobody knows.... the MVPs have been asking the sam ...Show All

• .NET Development ADO.NET + OLEDB + dBase + Records Marked For Deletion Question

  Hi there everyone, I'm using ADO.NET and OLEDB to connect to a dbase file that has records marked for deletion in it. When i opened a datareader using the standard connection string found at www.connectionstrings.com the datareader has the records marked for deletion. That would be fine if I knew how to step over them and not try and access them. I would rather that it didn't return the items that are marked for deletion. It was my understanding that OLEDB by default skipped records marked for deletion. So my question is, what am I doing wrong And how do I get OLEDB to either not return items marked for deletion or how do I get my data reader to skip them (continue in my while (dr.Read()) Thanks for your help! ...Show All