WalangAlam's Q&A profile

• SQL Server Trying to hide/obfuscate TSQL code

  Hi there, we are porting a huge PL/SQL(on Oracle 10g) application to TSQL (SQL2005) right now and we will offer a test drive for download. In Oracle we could "obfuscate" the PL/SQL code with a hash, so nobody can see the PL/SQL statements after the encryption. Is there something like that for SQL Server 2005 as well which can not be overidden by a local admin (like with changing a password for example) We have spent 5 years in writing SQL code (it is huge) and don't really want to spread the source all over the internet. Any help is appreciated. Niko Hi Niko. Is the code encapsulated in stored procedures If so, see the WITH ENCRYPTION option that is part of the CREATE/ALTER PROCEDURE syntax ...Show All

• Smart Device Development Infrared remote capability with .net compact

  Hi, After researching infrared capabilities I can't locate how to accept incoming infrared signals from stnadard tv/dvd remotes to be able to play them back. I have seen and read plenty of articles eg. godotnet but can't seem to find what servicename or endpoint is required to be set in vb.net or c# to work with standard tv/dvd remotes eg. to associate with the client/listener classes. I'm starting to think that the .Net Compact Framework doesn;t support this capability and only embedded c++ will work I would be grateful for any leads.... Thanking you Hi, After researching infrared capabilities I can't locate how to accept incoming infrared signals from standard tv/dvd remotes to be abl ...Show All

• Visual Studio Setting VS 2k5 multiple browser compiling of projects

  I've been searching around on how to set the vs 2k5 project so it can compile for Opera, Firefox and IE. Sorry I jst cant seem to find the setting anywhere. Thanks ahead of time for your help. Yes, I'm working on a asp.net project but the answer I'm looking for is a Visual Studio 2005 Standard feature that I do not have turned on. Like setting a directory for a project, somewhere that is a compiling option to compile for more then 1 browser, not just IE. I saw this demo'd on a web cast, sometime in the last few months. ...Show All

• .NET Development What is the exact effect of GC.SuppressFinalize?

  My question is, does GC.SuppressFinalize prevent the object from entering the finalization queue, (thus causing the object to get garbage collected immediately) or it just prevents the finalizer method from executing If the finalizer method is too trivial, is there real benefit on calling GC.SuppressFinalize I do implement the Dispose pattern. The thing is the finalizer just checks a boolean value to see if a native object needs deletion and I was wondering if it is worth it calling GC.SuppressFinalize at the creation of the .NET object, if it determines that it won't allocate a native object. But calling SuppressFinalize at creation complicates things a bit with the subclasses so, since it doesn't preven ...Show All

• SQL Server App receiving "Options" message from Service Broker

  I have an app receiving messages from SQL Service Broker when data is updated. (Messages are located at http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlnotificationinfo.aspx ) When I run this app against a remote SQL Server, I receive the message "Updated" which I expect. But when I run the same app against the local machine SQL Server, I receive the message "Options". Does anyone know if there are SQL Server options that must be set to certain values I can't seem to find anything that troubleshoots this message... either from a SQLServer- or a .NET standpoint. Agreed, I was using the example to explain this wasn't the app's fault. It still manages to work ag ...Show All

• Windows Forms The DateTimePicker is Ridiculous!

  Why doesn't the DTP allow you to select a Date AND a Time at the same time Instead, (from what I see) you have to create 2 DTP controls: One to select the date and another to select the time of day. Why can't they be on the same popup similar to how MS Access would let you select both Please somebody tell me I'm wrong and just missing something. I've been Googling around to try and find a custom one, but they are few and far between. Aren't there other people with this problem I thought this was basic stuff... If anyone knows of any custom controls that do this, I'd be greatful if you let me know. Thanks! Hello All. Igore99: You can have the DateTimePicker control select both the dat ...Show All

• SQL Server Link to Data

  I have a superbase database i like to link to sql server 2005. MS access is not working. How do i link a ODBC data connection into SQL Server. Hi, make sure that the right driver for the ISAM is installed: http://support.microsoft.com/kb/209805/en-us HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# How to make an Outlook 2003 style navigation pane

  Does anyone know how to build a Outlook 2003 navigation pane in C# without having to buy a third party product I know its very easy using those, but I don't want to be dependent on them for this particular project. Does anyone have any suggestions on how to make it using either C# 2003 or 2005 Any adivce or resources would be helpful! Thanks, ~zero There are many free ones look at http://www.itchin.net/NBMain.html http://www.codeproject.com/useritems/fireballwindowsforms.asp http://www.codeproject.com/useritems/OutlookBar.asp http://www.windowsforms.net/Default.aspx tabindex=4&tabid=49 look at Outlook 2003 Look and Feel ...Show All

• Visual Studio Express Editions Problems in registering the Express product

  Hello all! I have installed the Visual Web Developer Express 2005 edition. Everything went well. Once I started it for the first time, and I tried to register the product (clicking the "Register Now" link from the help menu of the product), the Internet Explorer is opened, and then nothing happens. The status bar does not show anything that the IE is stuck or anything like that. I even tried to update my profile at MS but I get an error page. I am clueless. Please help. Ananth ...Show All

• Windows Forms TabControl problem

  I have a form with a tabcontrol(with 2 tabpages) and I add a new TabControl at runtime using this->Controls->Add(gcnew TabControl()); Its been created at top left corner of windows and not visible fully..how to control its location/size etc how to access it Thanx in advance sorry it's a typo, it should have been: TabControl myTabControl = new TabControl(); you can do as many instantiation of controls at runtime like for(int i = 0; i < MaxCount; i++) { TabControl myTabControl = new TabControl(); myTabControl.Size = new Size(100, 100); this.Controls.Add(myTabControl); } btw: are you sure you need TabControls and not TabPages for yout TabControl ...Show All

• SQL Server Is there anyway to set a partition so that it cannot be re-processed?

  As part of my design, I plan to have partitions holding historical data. Since the underlying data will have been deleted from the underlying DW, I want to ensure that the partition cannot be re-processed. Does anyone know if this can be done and, if so, how Ta Dirc No this cannot be done. Also, please be advised, that your decision to have AS to be a primary data source is not a scenario that AS was designed for. Data Warehouse should be a primary data source. If you absolutely cannot keep data there, you need to have good backup strategy to be able to restore your AS partition data if something happens to it. ...Show All

• SQL Server Flat file source nightmare

  I've been working 4 days non stop on this project, lost a complete weekend on it and I totally had it. Please have a look at this "simple" question: I have a for each loop that checks for csv files in a folder. The path of the file(s) is stored in a variable varFileName. So far so good. But then I start with a data flow task and inside that data flow task I need to access one of those csv files at the time whenever it loops. So my best guess is use a flat file source because that's the only task I see in the list that fits my question. But the thing is, you set up a connection to a....yes right, a flat source connection and there you have to select a flat file. But no, I don't want to select ONE file, I need to access them ...Show All

• .NET Development .net profile - saved twice...

  hi, I'm using a asp.net profile to save user information. E.g: [Serializable] public class UserAddress { public UserAddress() { } #region Property: Street private string street; /// <summary> /// Gets/sets the Street /// </summary> public string Street { [System.Diagnostics.DebuggerStepThrough] get { return this.street; } [System.Diagnostics.DebuggerStepThrough] set { this.street = value; } } #endregion wehenever i update an edited profile using: Profile.UserAddress.Street = "new Street" ... Profile.Save(); then, the ...Show All

• Windows Forms DataGridView Slow Changing Backgroud Color

  Hallo, in my application, I use a DataGridView view around 30 rows and 20 columns. To make editing for the user more comfortable, I want to the background of the entire row and column corresponding to the CURRENT SELECTED CELL to be painted lightgray. All other cell have a white background. I use the following code in C#. It works, however, AWFULLY SLOW. I know that changing the background color of a DataGridViewCell is especially time consuming. Anyway, does anyone have an idea how to enhance perfomance Here the code: private void dataGridViewTabPage_SelectionChanged(object sender, EventArgs e) { DataGridViewCellStyle aux = null; if (_currentselectedcell != null) { for (int i = 0; i < this.dataGridViewTabPage.Co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Skinning in BasicEffect

  The ModelMesh is loaded with verts of the correct format, so if our file uses blend weights then it has the blend indices and weights. How are these blend weights being used in the BasicEffect Is the shader using a Matrix Palette or is it ignoring the skin info Changing the transforms on the models bones seems to do nothing, which leads me to believe it is doing the latter. Also, if we are using our own matrix palette shader and want our ModelMeshParts to be grouped by the number of blend weights per face, how can we use your Model class   The ModelMeshPart collection is immutable :( the animate thing in hlsl put in number of bones,------------------ in your x file look it up (this is curent set ...Show All