dczraptor's Q&A profile

• SQL Server How to delimit in Derived Column Component

  If there are two columns in a Derived Column Component, Is there a way we can put a delimiter between them say a '||' symbol or so and build an expression. All I was able to do was concatenate them. [Col1]+[Col2] thanks in advance. ...Show All

• Visual Studio Express Editions Deserialization error End of Stream Encountered before...

  Hello, I am hoping I will end my struggle here. I have confidence in you ;) I am serializing a hashtabls in my sql database in a field of type "image" with length 16. The serialization goes fine. later on in the code, I try to retrieve the value in the image field in a byte array as such: //***** code snippet begins object param = row["Parameters"]; // this is the field that has the serialized value. byte[] myBParam = (byte[])param; // cast it to an object. //***** code snippet ends and then I try to deserialize to make sure that I can retrieve my original hashtables, so I do this: //***** code snippet begins Hashtable myOrigHt = (Hashtable)Deserialize(myBParam); // Which goes to this me ...Show All

• Software Development for Windows Vista How do i pass handle between proccesses?

  Hi, I could use CreateProcess and STARTUPINFO to pass a pipe handle in xp. How can I use pipes with Shellexecute under vista Specifically, I tried "CreateProcess" from low privileged process(an activex) and it fails. Thanks in advance. What parameter did you use to pass the pipe handle - I used anonymouse pipe(created with inheritible flag) and used STARTUPINFO hStdInput or output when Creating process When you say low privileged, do you mean Low Rights IE or a standard user application -Low Rights as in protected mode I noticed plain "CreateProcess() without any pipe handle passing" fails when run from Low privileged application such as ActiveX I also tried file mapping with 'Local\\myFil ...Show All

• Visual Studio Tools for Office While Converting Word to Pdf in Office 2007 Getting err

       Hai,       My objective is to Convert the office files to pdf using C# Com Interop and office 2007 .It is a automated one it will covert all the office files from source path to Targetpath. It is working fine but iam getting messages for some documents like password protected, readonly and i suppressed these message using some parameters in Document.open(parameters passed) but Now iam geting a another message "You are attempting to open a file type that is blocked by your registry policy setting. " which i can't able to suppress  so can u pls help me in this regard and mention which parameter should i use for this message .        When i chec ...Show All

• Visual Studio 2008 (Pre-release) Inheritance not supported on callback contracts?

  Hello, When I try to invoke a callback method, I receive the following error: Callback method Renew is not supported, this can happen if the method is not marked with OperationContractAttribute or if its interface type is not the target of the ServiceContractAttribute's CallbackContract. I have a simple interface hierarchy as follows: [ ServiceContract ] public interface IRenewable { [ OperationContract ] void Renew(); } [ ServiceContract ] public interface IMyServiceCallback : IRenewable { [ OperationContract ] void MyCallbackMethod(); } [ ServiceContract (CallbackContract = typeof ( IMyServiceCallback )] public inter ...Show All

• Visual C# Turn off "Are you sure you want to delete all of the bookmarks?"

  This is more of a minor annoyance than a real issue but if anyone has a solution I'd be very appreciative. When you delete all of your bookmarks from a solution in VS2005 (Ctl+B,Ctl+C) you always receive a confirmation dialog asking you if you're sure you would like to do this; does anyone know a way to disable this confirmation I've haven't been able to find anything in the Options (though I may have missed it) and I know that some VS options are really surfaced in the UI but can be controlled by registry keys. Has anyone ever ran across how to turn this off Thanks in advance, Jeremy Unfortunately there is no way to disable this dialog in VS 2005. Anson Horton Visual C# IDE PM ...Show All

• SQL Server CDE IDataReader Question

  We've extended the IDataReader class to allow the ability to select data from multiple datasources as DataTables and then combine the multiple DataTables into one single DataTable. Here's our internal object array that holds the values being returned to SSRS ------------------------------------------------------------------------------------------- internal object[] m_cols; ------------------------------------------------------------------------------------------- Here's our IDataReader.Read() implementation where we attempt to sort our DataTable after the combination takes place. ------------------------------------------------------------------------------------------- bool Microsoft.ReportingServices.DataProcessing ...Show All

• SQL Server Cyclical dependency causes stack overflow exception

  If i have the following objects: create database cycle go use cycle go create view v1 as select 1 one go create view v2 as select 1 one from v1 go alter view v1 as select 1 one from v2 go and run the following smo script to get the dependencies (didn't include full code) I get a stack overflow error. Is there any way to catch this or check for it before it happens DependencyWalker dw = new DependencyWalker(db.Parent); DependencyTree dt = new DependencyTree(dw.DiscoverDependencies(urncUnsorted, true)); ...Show All

• SQL Server bit field---

  HI, while saving in bit field sometimes it is saved as true or false. sometimes it is saved as 0 or 1. how to make it true or false when i needed. if i set default value to 0 will it save 1 or 0 always. with default 0 i need to store truee or false. how it is possible this way. thanks venp--- Hi, no the BIT data type is a INT type with the constraint of holding only 0 or 1. The true or false is a client presentation you are seeing, Excel will for example use this presentation for the boolean type. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget In addition to that IsNumeric is dangerous: http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.html ...Show All

• Visual Studio Express Editions no subject

  can anyone give me an example as to how to connect and control something from a serial port.....something really simple like a light bulb..... hey maybe this..... I have a teddy bear which runs on batteries when you squeeze his foot he snores.... I would love to connect and control him by the pc any ideas...please If you don't have a voltmeter you don't need to buy one. In that case, you just need a little more surgery on the teddy bear. You need to find out how the sensor is connected by following the conductors from the battery. It is probably just a simple switch from one side of the battery to the electronics and the head movement motor, but it can be more complicated. You are lucky that the voltage on the t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Perspective Shadow Mapping

  Hi all, I've read the Stamminger paper over and over again, but I still can't get my head around the concept. I've had no problems implementing simple shadow mapping (in fact the SDK example proved invaluable), but I'm at a loss as to how I'd implement perspective shadow mapping as described by stamminger to help correct some of the aliasing issues I'm getting. Can anyone describe the algorithm in plain english t.i.a Rob Meridy Thanks for the reply, I've come across that article before, and it does do a good job of explaining simple shadow mapping, but it only vaguely mentions the newer (c. 2002) technique of perspective shadow mapping. I understand and have implemented the technique of ge ...Show All

• Software Development for Windows Vista Exception while using Transaction Scope Activity

  Hi, Transaction Scope Activity is giving the following exception when I am trying to run the application from Server where it is executing properly when it is run locally. Please give me the solution. System.Transactions.TransactionException: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) ---> System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.EnterpriseServices.Thunk.ServiceDomainThunk.EnterServiceDomain(ServiceConfigThunk psct) at System.EnterpriseServices.ServiceDomain.Enter(ServiceConfig cf ...Show All

• SharePoint Products and Technologies web part aggregator

  Is there a web part aggregator that enables a tabbed-view of web parts on a page; or has someone done this with code Thanks. ...Show All

• Visual Studio 2008 (Pre-release) Custom Demux and WS.

  I have a WCF application that hosts a service accessible over msmqIntegrationBinding and basicHttpBinding. A client should be able to call the methods msmqMethod1 and msmqMethod2 over MSMQ or wsMethod1 and wsMethod2 through a WS. The msmq- and http-bindings have different contracts but the same service and host. I know how a client can call different methods by setting the Message Label from the Custom Demux example here . It works fine for me. The problem occurs when calling the ws-methods. I get an exception in SelectOperation method in OperationSelector: "A property with the name 'MsmqIntegrationMessageProperty' is not present." Which I understand. But how do I change so that the http-endpoint doesn't undergo the same procedure as the ...Show All