ChrisPeers's Q&A profile

• SQL Server CreateProcessAsUser in SQLCLR

  I'll keep trying new threads here... sooner or later, I'm sure an expert Microsoft CLR employee will gladly lend a helping hand! The pieces: 1. SQL 2005, MS Windows Server 2003, Standard Edition, SP 1 2. .NET 2005/C# 3. Instance of SQL 2005 running locally. Trigger on local SQL2005 DB table INSERT calls 2 CLR Functions: 1. Retrieve data from SQL2005 DB table and populate local DBF through OLEDB 2. Call external 16-bit a ...Show All

• Microsoft ISV Community Center Forums Microsoft Access Runtime/Developer (XP) - compatibility issue with XP SP2?

  I have software that I packaged with Microsoft XP Developer SP1 edition which  does not  function on Windows XP SP2 systems but ran fine on all prior operating systems. The wording I am getting when I launch the installer is: "Visual Basic 6.0 Setup Toolkit" "The Application you are installing requires updated system components. To continue, install the Office System Pack. For assistance, contact your applicaton provider" Is there ...Show All

• Visual Studio Team System unit testing web app and httpcontext (lack of)

    We have a web app and would love to use unit tests but we are hitting a wall when we run the tests   for 2 reasons: HttpContext is not available the virtual directory path is null so we cannot access our web.config that contains a custom section   Specifically the following method returns null: MyHandler ourConfigHandler = ( MyHandler ) ConfigurationManager .GetSection( MyHandler .MVP_CO ...Show All

• Visual C# How to display Chinese Characters in a C# Application?

  I want to display Chinese Characters on the controls (e.g., buttons, lables, etc.) in C# .Net, but always failed with garbaged characters displayed (I have adopted NJStar to input Chinese Characters). How can I configure the Visual Studio .Net environment to implement the display of Chinese Characters in my Application Moonriver (1) To enable IME, do the following: a. Goto Control Panel->Regional and Langu ...Show All

• Windows Forms Using the .NET 1.1 com interop in .NET 2.0?

  Hi there, I am having some real major issues with getting an activex COM library to fire events in VS2005 but its ok in VS2003 SO I was searching around and i wonder if its possible to Use the .NET 1.1 com interop in .NET 2.0 My idea is really ... that if it worked in VS 2003 then to make it work in VS 2005 then if i could use the interop com from NET 1.1 (vs2003) then i may have a chance Thanks in advance Ian ...Show All

• SQL Server SQL Express user permissions?

  I'm trying to build a web application using SQL2005 Express and Visual Studio Express.  It all works OK on the local machine, but gives an error "Login failed for user xxxx\ASPNET" when used remotely.  I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please Thanks John Remote connections are disabled by default. You can use the Surface Area Configuration t ...Show All

• SQL Server PIVOT question

  I have a basic table consisting of several thousand records. Im trying to generate a pivot query for a report. the table consists of records, each of which has a recieved date ( small date time ) and a tranactioncount ( int ) . Im looking to generate a PIVOT to show the show the month and year counts for the files recieved ie YEAR | JAN FEB MAR APR etc 2004 ! 2 34 67 43 2005 | 12 2 3 1 can anybody ex ...Show All

• Visual Basic Adding a row to a control bound to a datasource

  Hi, I have an application that consists of multiple combo boxes, list boxes, etc.  Most of the combo boxes are bound to a datasource.  What I wanted to do was add one row to each combo box with the value of "_None" so that if the user had selected an entry and then did not want the entry, there was an easy solution - select the "_None" entry.  However, when I tried to add this row to a control having a datasource I get the fo ...Show All

• Windows Forms Making a UserControl behave like a Timer control at design time

  I have a UserControl in C# that I want to behave like the Timer control, and other controls behave.  That is, at design time, when the user places the control on a form, it drops down to the window below the form instead, and jus ...Show All

• SQL Server Integers in SQL Server

  I'm having a problem with the way integers are stored internally and how they are returned with a SELECT statement.  In the project I'm working on, I have to move data from an Excel file to a database so I'm using DTS and a group of stored procs to pull this off.  What happens is: DTS pull data from Excel into temp tables Stored proc pulls from the first temp table into a supertype table IDENTITY column assigns primary ke ...Show All

• Visual Studio fail to install msdn library after vs2005 beta2 installed

  my machine comes with Dual AMD Opteron DP 244, OS is windows server 2003 enterprise x64 edition, evaluation copy. with service pack 1, v.1433., first I installed vs2005 beta1 refresh, both vs and msdn library installed and works very well. then vs2005 beta1 expired and I can not use it, so I installed vs6 to tweak the 64-bit application. after I got the vs2005 beta2(by downloading), I uninstalled vs2005 beta1, and then installed the b ...Show All

• Windows Forms Eventlog problem

  Why do i get this problem when i'm trying to write to the eventlog The description for Event ID ( 0 ) in Source ( MyLog) cannot be found. The local computer may not have the necessary registry information or message DLL files to display&nb ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D game tools

  I want to create a simple flying game using DX and C#, what are some of the tools people here use to place objects into world space(to get the coords), my idea is to use a manager I created to manage my resources then once I find a good tool to use to get world coords I will create a class that will tie into my rendering loop that will grid out my world for rendering. thanks for any help or Ideas Placing objects ...Show All

• SQL Server Get report in Excel

  Hi, I've made C# winform application where the user can enter it's parameters (I did this so I can do some inputcontrol on the users parameters which I can't in reportviewer cause it's Closed Source). Now when the user presses the button Get report in Excel. The application should pass the parameters to the SQL statement and complete this. Then the report should be exported to Excel and Excel should start and show me the report. All this should ...Show All

• SQL Server Help getting mirroring working

  Hello guys and gals, I've having some trouble getting DB mirroring set up in Sql Server 2005. Perhaps someone can help, as I've read everything I can find on the web and Google groups about this but still can't solve it. Here are the steps I have taken: 1. Installed a fresh Windows 2003 on box A (the primary) and a fresh Windows XP on box B (the mirror). 2. Run Windows update on both. 3. Installed Sql Server Enterprise on box A and box B, ...Show All