Milzit's Q&A profile

• SQL Server Errors using multiple parameters in a SQL Statement

  In an OLE DB Source in an SSIS package, we are having difficulties using multiple parameters in a SQL statement. Using a single ' ' works fine, but I've read that when you want to map more than 1 parameter you should use 'Parameter0, Parameter1, etc'. The problem is that when we use Parameter0 and Parameter1 and then try to map it, it says that the query contains no parameters. Can anyone help with the correct way to use multiple parameters in a SQL query that's part of an OLE DB Source task Thanks, Mike Neither Parameter0 or just 0 is working This is the SQL in an OLE DB Source. At one point, 0 and 1 caused the parameter mapping dialog to appear, but these others are not workin ...Show All

• Visual C# Element 'ProjectProperty' is not a known element.

  I have this problem: Element 'ProjectProperty' is not a known element. This can occur if there is a compilation error in the Web site. Can anybody help me! Thank's! Hi Microsoft Office Sharepoint Server = Moss = Sharepoint 2007 you need to deploy your site to the _layouts directory.... and test it there Hope this helps ...Show All

• SQL Server report viewer and reporting services security

  i have a web application in studio 2005 using the report viewer control. i have my own security model implemented on my web pages for clients [1..n] each of the [1..n] clients should be able to view reports of their order history. i have the report viewer set up in url mode. the question is that when i have drill downs in my final reports, a user with some tech knowledge, would be able to obtain the url to my sql server running reporting services. the sql server will not be given a port 80 acess. how do i go about displaying reports without any savvy user being able to locate the server locations/credentials i donot want to create windows account for each [1..n] clients as this is ever growing ...Show All

• Smart Device Development ActiveSync

  The activesync version I'm using is 3.8, and i'm developing in Visual Studio .NET 2003 in C#. I'm also using the mscomm.ocx for communication to the serial ports. I currently have an application open when I cradle my PocketPC. That works fine. But the point of that Application is to read data. I expect it to be just random characters, I just need to know that it is in fact communicating with the PPC. Any ideas on how I would go about this. I currently have the following as code (InitComPort is a subrouting I created that is initiated in the constructor) private void InitComPort() { com.CommPort = 1; com.RThreshold = 1; com.Settings = "9600,n,8,1"; com.DTREnable = true ; com.InputMode = MSCommLib.InputModeConstan ...Show All

• .NET Development Trying to connect to an Oracle database with Visual Studio 2005 and SQL Server 2005

  I tried to import our Oracle database into SQL Server 2005 and got the following error: "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 part of the ORacle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed." Also, trying to connect to the Oracle Database via Visual Studio 2005 (through a GridView) yielded this error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater." Am I right in assuming (please don't laugh... I'm new to all of this) that I need to install s ...Show All

• Smart Device Development First time deploying app to device using storage card

  We are using VS2005 and have a custom CE 5.0 PXA255 board. We want to build a Visual Basic app, store it on an SD card and run it on the device. All of the help seems to be oriented to using the emulator or Active Sync. This is not how we need to do it. We have created an SDK from Platform Builder and can choose it in VS2005 as the target. But we may not even be doing that right! Is there a tutorial available for this method Any and all help is most appreciated. Thanks in advance! Michael P.S. We have tried for a few days without success, so that's why we are asking here. Thank you for the quick reply! I am not trying to debug it, simply run it and have a menu/window pop up on the CE desktop of the device. Again, I apologize for the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texturing problem

  Hello, I'm writing my own content importer for my maps. At the moment, I'm able to load all triangles and draw the map but i have a problem with textures. In my importer i load texture like this (it's just a test) : BasicMaterialContent material = new BasicMaterialContent(); String texturePath = Path.GetDirectoryName(filename) + "\\Textures\\wall.jpg"; if (!System.IO.File.Exists(texturePath)) throw new Exception("Texture not found !"); material.Texture = new ExternalReference<TextureContent>(texturePath); Then I apply my texture to a mesh : builder.SetMaterial(material); When I deploy it on xbox360 or run it on my pc, my mesh have a color similar to my texture but it's just a color! I ca ...Show All

• Visual Studio Express Editions error LNK2001: unresolved external symbol

  Hi all, I am new to Visual C++ 2005 express. Moving from last release, Visual Studio .NET to new one, trying to use library(*.lib) which was working pretty fine with VS .NET I am getting following erros with VC++ 2005, error LNK2001: unresolved external symbol "struct std::_DebugHeapTag_t const std::_DebugHeapTag" ( _DebugHeapTag@std@@3U_DebugHeapTag_t@1@B) error LNK2019: unresolved external symbol "public: virtual __thiscall std::istrstream::~istrstream(void)" ( 1istrstream@std@@UAE@XZ) referenced in function "public: void __thiscall std::istrstream::`vbase destructor'(void)" ( _Distrstream@std@@QAEXXZ) error LNK2019: unresolved external symbol "public: void __thiscall std::_String_base::_Xran(void)con ...Show All

• Visual Studio 2008 (Pre-release) Dynamic WPF window generated from runtime XML. How can I do that?

  I have previously from a few years back created my own XML syntax with UI element tags and logic tags. By rendering the XML through a xml parser checking the logic I would get a pure UI elements XML in return. This XML I would present to the user transformed (by code) to a normal Form with controls. Now that I have sniffed at XAML a bit, I am wondering if it is possible for me to utilize this. I was thinking on using normal XAML and then infuse it with my XML logic tags which would be parsed through my xml parser. In return I would then have a pure XAML to present. So far the XAML in the test applications I have created are very much DesignTime only (and .net generates some codebehind for that in the \obj folder). How would ...Show All

• SQL Server How to group values in a pie chart? Very urgent! Please somebody say something!

  Assume I have a pie chart whose Value: is Internet Sales Amount and Category group: is Product Subcategroy . Suppose I have 5 segments(slices) with the value 200,150,80,50,and 40. Now, here is the question; I want to aggregate those values that are less than 100 (in this case the last three values: 80+50+40 = 170) and put the sum(170) in one segment, so that in the new pie chart we will have only 3 segments with the value 200,250, and 170. Any idea is appreciated. This can be done through MDX as shown in your related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=638700&SiteID=1&mode=1 -- Robert ...Show All

• Visual Studio Register Guidance Package fails

  I recently upgraded GAX/GAT to install the Web Service Software Factory.  Working with the software factory package had no errors.  I tried creating a simple Guidance Package and encountered the following when trying to register the package: Microsoft.Practices.RecipeFramework.ActionExecutionException: An exception occurred during the binding of reference or execution of recipe Register. Error was: Action Register failed to execute: Failed to process package. See the Guidance Package Development output window for more information about the error.. You can remove the reference to this recipe through the Guidance Package Manager. ---> System.Configuration.Install.InstallException: Failed to process package. See the Guidance P ...Show All

• SQL Server can a database be made full after 15 entry's

  Hello guys I was wondering if it would be possible to make a database full after 15 entry's and how would I go about doing that if it is possible Thanks Again Rob I really appriciate your help I was messing around with the code you gave me today but I am confused on where to put it/Implement it I went into the table and tried to add a check constaraint but I couldn't get the exception accepted ;-( Sorry to be a pain in the arse ...Show All

• Visual Studio Express Editions remote database

  Hi People! Please, HELP ME! I use Visaul Basic express edition and I want to connect to remote microsoft access database. 192.168.54.106 with computer about this IP I want to connect Data Source=C:\software\software.mdb strConString = "Provider=MS Remote;" & _ "Remote Server=http://192.168.54.106;" & _ "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\software\software.mdb;Persist Security Info=False" This code doesn't work I' am waiting for answer I will be very grateful nobugz wrote: Hey DMan1: almost missed that one too. Why don't you let the thread start mark answers You ca ...Show All

• Smart Device Development Console Applications Help needed

  hi all, I want to develop a console app and call it from my main application. how to do it If i want to pass any arguments to console application then Is there any mechanisms tht u appln made by me, send msgs plz help needed.How to make the console appln to run in background Yes, you could use any IPC methods available to communicate between applications. No, that won't stop the second application unless you stop it using Process class. Yes, either sleep for specific period if time or (better) use system events (e.g. CeRunAppAtTime()) to start your application, do whatever's needed and terminate. The question here is: do you really need a second application Why can't you simply hide all win ...Show All

• Visual Basic shared members not visible in COM Interop

  I've been doing some experimenting with trying to access some of the System.IO classes (Path, Directory, etc.) to our VB6 app. I had hoped that simply making a reference to mscorlib would provide access to these, but alas it appears not. The next thought I had was to write a simple .Net Interop wrapper, essentially mimicking the interface presented by IO.Path, for example. Using the .Net documentation as a guide, it seemed straightforward enough to write a slew of public shared function GetExtension( ... ) as string I found, though, that the shared functions do NOT appear in the object browser in VB6, even though the wrapper class is decorated with AutoDual (non-shared functions appear just fine.) My question is, why don't th ...Show All