Carl-Otto's Q&A profile

• SQL Server Where to use SQLCLR ? Data access is not recommended?

  Just wondering which scenarios is suitable to use SQLCLR. Any kind of data access is not recommended I guess. Only things that cannot be easily done in TSQL should be done in SQLCLR but why Can't those things be done in app layer itself Scenarios recommended for SQL CLR: - External data access like filesystem, registry etc - Complex calculation - Recursion without data access (this can be implemented with CTE for data access) If data access with SQL CLR is not recommended why should CLR should be even used and logic reside in database layer.. it makes no sense to me. Any thoughts Could you show us some examples of T-SQL and the ..NET code you converted it to   I'd be very inte ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWar demo: .NET Runtime 2.0 Error

  I'm having a bit of trouble getting the SpaceWar demo to run. It compiles fine (I made no changes) but when I try and run it I immediately get a dialog box asking if i want to send a report to Microsoft (I always say 'Yes'). Below is a copy of the Event Log entries generated: Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 8/30/2006 Time: 7:41:21 PM User: N/A Computer: IO Description: Faulting application myspacewar1.exe, version 1.0.0.0, stamp 44f5d7e7, faulting module kernel32.dll, version 5.1.2600.2945, stamp 44ab9a84, debug 0, fault address 0x00012a5b. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data: 0000: 41 00 70 00 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Learning a programming language AND game programming concepts simultaneously a pipe dream?

  I'm tryig to learn C# programming with the aim of creating games, but boy is it a struggle. I think the stumbling block for most people (and I include myself in this group) whose primary interest in programming is games related, is that a large conceptual leap is required between document-based programming and real-time programming - and there simply isn't any sufficient discussion or tutorials explaining the fundamentals of the concept to ease the transition. The basic problem is anyone who starts out learning a language like C# pretty much finds themself with nothing but books teaching the language from the perspective of programming forms, event-handlers, interacting with controls  and basically looking at exer ...Show All

• .NET Development When does a shared class get initalized, and who init's it?

  When does a shared class get initalized, and who init's it   If you are talking about a static class which exposes methods, then never.The method is hooked up to the calling method during the compilation stage and all objects are placed on the stack. When the call returns, then the objects are popped of the stack. The whole idea of the static, is that it is stateless, hence no member variables can be used that are not static on their own. ...Show All

• Software Development for Windows Vista TTF Font Installation in Vista

  Hello all, I'm trying to make my Font Installtion Program Vista compatible. Installation of a TTF file doesn't work anymore as described in http://msdn2.microsoft.com/en-us/library/ms533960.aspx. Copying to the windows\fonts directory ends in a "Access denied" error. Can anybody give me a hint how to install a font permanently in vista. Thanks Michael Not sure if this is related to this post or not, I was attempting to drag and drop ttf fonts from a mapped network drive and receiving the error "The File (path name) is not a valid font file and cannot be installed." for all the fonts. Vista asked me for permission via UAC which I assumed was providing the elevated permissions, but still ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Use of professional 3d Game Engines with XNA - Port

  hi there, I got some questions about the compatibility of the XNA Framework with 3d or game Engines. By now where are a Team of  7 Student of the Games Academy in Berlin producing our game with the trinigy Vision Engine and the Standard Visual Studio 03. -> www.project-barcode.com My main questions is if its possible to combine the trinigy vision engine and the XNA Framework/ studio Our Programmers got experiece with c# but are not used to create games on it. Whats the overall state of campatibility with engines and the XNA Framework Or is there by now just a support for the Torque X Engine the trinigiy Vison 6.0 is a fully Dirext X engine coded in C++. Would it be possible to correct our ...Show All

• Gadgets This is not a valid gadget package!! grr!

  hey, So i finished creating my gadget, i use winzip to zip it up to mygadget.gadget and then double click to install... However it just says: This is not a valid gadget package The gadget works if i move the folder to the windows gadget directory! Does anyone know how to fix this problem Regards i am using winZIP at the moment, any other ideas on other programs to use to make it I tried with 'store' as the compression level in winzip and it still didn't work! I dont think you can turn compression off in winzip! Regards ...Show All

• Visual Studio Express Editions Make my own file type

  Hey I was wondering how can I make my own file type And how can I make the file type work with my programs See Creating a File Association for information including registering a file type. ...Show All

• SQL Server SQL Server Business Intelligence Development Studio Missing

  Hello, I have installed SQL 2005 dev version. All the installations were successful. However, I can't find Sql Server Business Intelligence Development Studio (BIDS) from the VS 2005 IDE. I can see Integration Services Project, Analysis Services Project, Integration Services Project, etc except BIDS. I tried to run sqlexpr_toolkit.exe by itself and it tells me BIDS already installed. Any idea BIDS (Business Intelligence Development Studio) is just another name for VS IDE with BI projects you've found: Integration Services, Analysis Services and Reporting Services. The name originates from start menu shortcut name under SQL Server - it opens the same VS IDE, by the way. Looks like you have everything installed :) ...Show All

• SQL Server optimising a table with lots of boolean fields

  I have an application that reads a monitoring devices that produces 200 digital outputs every second and I would like to store them in a table. This table would get quite big fairly quickly as ultimately I would like to monitor over a hundred of these devices. I would like to construct queries against each of the individual digital channels or combinations of them. M first thought is to set up a table with 200 separate columns (plus others for date stamp, device ID etc) however, I am concerned that a table with 200 boolean (1-bit) fields would be an enormous waste of space if each field takes maybe one to four bytes on the hard disk to store a single bit. However, this would have the advantage of make the SQL queries more natural. The oth ...Show All

• Visual Basic Merge files

  In the old dos days you could combine 2 files as save to a third file: copy file1 + file2 file3 It still works in a dos shell. I did this: Shell("copy " & file1 & " + " & file2 & " " & file3) I got an error that file3 cannot be found. I know it doesn't exist I want to create it. So I created a bat file: copy %1 + %2 %3 and called it as such: Shell("ccopy " & file1 & " " & file2 & " " & file3) I still get the error that file3 cannot be found. First I don't see how it can tell from the shell that file3 is a file. How do I do this otherwise Do I have to create a blank file before calling it It was not finding the ccopy.bat without the full path. Solves the file not found. However, i ...Show All

• SQL Server Report server status 403

  I'm trying to get reports and report server site aveable through user certificate. Web site is under default web site. Under default web site is certificate server web page, it is aveable and configured the same way and it works if I use certificate. If I type https://FQDN/Reports , i get error The request failed with HTTP status 403: Forbidden. But if I type https://FQDN/reportserver i can access. Both sites are aveable if I use only https. But if I but if i use Require client certificate, than I get 403 error. In rsreportserver.config, there is <UrlRoot>https://NETBIOSServerName/reportserver</UrlRoot>, does not help if I use FQDN. If I enable anonymous access, I can ...Show All

• Visual Studio 2008 (Pre-release) MenuItem and KeyBinding question

  I have a MenuItem defined like : <MenuItem Name="menuCheckUpdate" Header="Check for updates" InputGestureText="F5" Click="CheckUpdates" /> What do I write between "<Window.InputBindings>" to simply bind F5 key press to CheckUpdates event Thanks you need to hook up a command. In the menuitem set the command property (like I mentioned in the previous post) here is how you create a command xmlns:custom = " clr-namespace:your namespace " public static RoutedCommand CustomRoutedCommand = new RoutedCommand (); public void ExecutedCustomCommand( object sender, ExecutedRoutedEventArgs e) { ...Show All

• Visual C# I keep getting a hiding error. I'm confused.

  Warning 2 'WindowsApplication3.generalEnemy.onEnterFrame()' hides inherited member 'WindowsApplication3.SceneObjects.onEnterFrame()'. Use the new keyword if hiding was intended. C:\Documents and Settings\Owner\My Documents\Visual Studio 2005\Projects\WindowsApplication3\WindowsApplication3\generalEnemy.cs 24 21 WindowsApplication3 is a warning I'm getting. Basically I have an abstract superclass SceneObjects, and an abstract subclass Characters, which has an abstract subclass generalEnemy. There is a method called onEnterFrame which is defined as public void in all of those classes. I can't define it as abstract in these classes because some of the subclasses are abstract, and therefore I DON'T want them to implement it. I ...Show All

• Visual C# Why C# does not support multiple inheritance?

  Hi Please let me know why c# does not support multiple inheritance. I know it will support multiple interface inheritance. but why in the case of classes Pls let know the reason. Regars sanjay take a look at these links this is explained well there http://blogs.msdn.com/csharpfaq/archive/2004/03/07/85562.aspx http://blogs.msdn.com/nickmalik/archive/2004/12/31/344966.aspx http://www.c-sharpcorner.com/Language/MultipleInheritanceCB.asp hope this helps ...Show All