perun's Q&A profile

• SQL Server User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails

  Problem: I am trying to create an asp.net website with integrated windows authentication to access SQL databases. IIS resides on WinXP and SQL Server on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot reside on the same machine and a stand alone web server is ideal as the website needs to access multiple SQL Servers. IIS is set to Integrated Windows Authentication. The machine running IIS & the SQL Server are set to be "trusted for delegation" in active directory. The domain user accounts that will be accessing the databases are not marked as "Account is sensitive and cannot be delegated". The connection string that the web app uses to connect to SQL database is: "Data Source=PWSSQ ...Show All

• SQL Server Pivot Table Connection with OLAP Cubes

  Hello, I am having issue with Performance of the Pivot Table connecting to OLAP Cubes. I am wondering if any of you have links to how to improve Pivot Table performance Basically, I have done the backend optimization on the schema, but there should tricks on the Excel such as Connection Properties that I could use that could relate to MDX or Threshold Level that could speed up the Pivot Table performance. Below is some initial thoughts... Non Empty Threshold=1 Any help is appreciated! -Lawrence I don't think spending a lot of money to upgrade to Excel 2007 just for Pivot Table performance gain is worth it. There are some settings on Pivot Table connection could increase the performance. Thanks ...Show All

• Windows Forms Doubt about Event and Delegate in multithread context

  Hi to all, I'm trying to understand well the paradigm of Event and Delegates, but I've some problem that I can't explain to myself. I've tried to write a little piece of code: in one class (the publisher) I declare a delegate and an public event, so someone can subscribe to it. In another class (the subscriber) I create an instance of the publisher class, and add its method to be executed when the event is raised. If I do this using a Windows Forms, when the event is raised up, I receive the message that I'm using Cross-Threading operation that is not a good think (I know how to disable the message, but is not what I want). Hi Mark Dawson, and thank you for your reply. I know that the problem to textbox is caused by an access from a dif ...Show All

• Visual Studio Team System Different build.exe output when using prefast

  I'm trying out prefast for the first time, trying to get our current driver code to work with it. Compiling our code with "build -cgZ" produces the following output: C:\Prefast\engine_trunk\source\CRC32\src>build -cgZ BUILD: Adding /Y to COPYCMD so xcopy ops won't hang. BUILD: Using 2 child processes BUILD: Object root set to: ==> objfre_wnet_AMD64 BUILD: Compile and Link for AMD64 BUILD: Examining c:\prefast\engine_trunk\source\crc32\src directory for files to compile. BUILD: Compiling c:\prefast\engine_trunk\source\crc32\src directory 1>Compiling - crc32.cpp for AMD64 1>Building Library - c:\prefast\engine_trunk\source\lib.xruk64\amd64\crc32.lib f or AMD64 BUILD: Done 2 files compiled 1 library bui ...Show All

• Visual Studio Team System Random string for UserName.

  I would like to generate a random string for every new registration transaction on the site. After I record the test, I am able to generate code and add a random string function. But, is there a way I can do it with the .webtest file We really like the GUI part of the .webtest file. Unfortunately, you cannot sync up the .webtest with the generated code file. Any help will be appreciated. Thanks in advance. You could use a WebTest Plugin and set the Username in the PreWebTest event there. This way you don't lose the UI for the web test, but you still have code level interaction. Here's an MSDN walk-through on creating a WebTest Plugin: http://msdn2.microsoft.com/en-us/library/ms243191(VS.80).aspx ...Show All

• Visual Studio Context Sensitive Help Isn't

  Hi, I'm using VS 2005 8.0.50727.42 I am editing C/C++ code and highlight any function from the CLR. i.e. "remove" Intellisense correctly identifies the matching function declarations from stdio.h But if I press F1 I get directed to hundreds of pages of C#/Web development/SQL help. I really just want a "man page" for the function. I've tried disabling all the non-C/C++ options on the search page options but all the unrelated help is still shown. Any ideas on how to restrict help to only the CLR help pages Thanks, Steve Hi, Just an update. I wasn't able to find how to do a network install of MSDN, but after the local install with the config you describe above I do find the expec ...Show All

• Visual Basic riddle me this -- memo fields from Access

  I've encountered a problem with Memos from Access...  basically I'm running into Nulls when I shouldn't be. I've isolated the problem with as few number of variables as I can: I have 1 Access 2003 database in the location: c:\vb\sampledb.mdb This database has 1 table, "test" The table "test" has 3 fields,  testAutoNum - Autonumber  testText - text  testMemo - memo The table "test" has two rows, [1] [test] [test] [2] [test] [test] I have 1 VB Application with a reference to "Microsoft ActiveX Data Object 2.9 Library". There is one form, Form1, with one textbox, txtTest, and one command button, Command1.  The following code is used: Dim objRS As ADODB.Recor ...Show All

• SQL Server MSSQLSERVER Service cannot start [SQL 2000]

  Hi All, MSSQLSERVER Service is not started, when I try to start it, it tries to start then it remains not started. What are the possible causes of this issue What are the possible solutions other than reinstalling the SQL software Thank you. Bishoy Check your system and application event log for error messages from sql server. You find event log viewer in Start->Control Panel->Administrative Tools->Event viewer or by starting "eventvwr" from Start->Run... Do you see any messages from MSSQLServer or Service Control Manager -- SvenC ...Show All

• Visual Studio Express Editions resoucres added to my project are not published

  hello i have certain files ( .doc, .dll , .ht) etc which i added to Resources of my project and it shows up in my solution explorer , but when i publish my project these files are not included. I added them to the resources in the project properties, that didnt work either. Also is there a option to create a shortcut on the desktop when my application is installed on the client machine. ok ..i added 4 files barcode.ht Atp143.exe sw.exe test.doc these files are opened from my program, the program works perfectly find when i debug it. But when i publish it ....only Atp 143.exe and sw.exe are included in the package....it does not include barcode.ht and test.doc so my program returns a file not found error...why is this ...Show All

• Visual Studio Remote debugging with VS 2005 when TCP/IP filtering is on

  I have an embedded XP environment where TCP/IP filtering is turned on and only a small number of ports are allowed to be open. With MSVCMON, we knew which ports were needed and we'd open them up to allow DevStudio sessions to remote debug. With VS 2005, MSVSMON "seems" to allow you to select a port (like dbgserver for Windbg), but when I try to connect I still am told that I cannot connect. I did some network sniffing, and saw that VS did an initial handshake on the specified port, but then switched to some other, random port, which is not opened on the server and therefore led to the debug session failing. Can anyone tell me if there is a way to use MSVSMON in this type of environment where I want to know (and control) which por ...Show All

• Visual Studio Team System requirements

  Hi, I am working with MSF CMMI. I have tasks associatd to requirements. Is it possible to have this behaviour: -when all tasks associated to a requirement are "resolved" then the requirement should be "resolved" -when all tasks associated to a requirement are "closed" then the requirement should be "closed" Is there a way to do this Thanks you very much for your help Rod You can also use the TFS object model to subscribe to events. You can write a notification filter that can check for resolved requirements, and on receipt of the SOAP notification event, your web service can (through the WIT object model) open the requirements work i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Please help!!!! - How to create a event.DirectAudioPlayback

  Hello.I have a really BIG problem.I have tried to create a event in my application. I use DirectX.AudioPlayback to play mp3 files but I wan't to now when the file is finished.....to play the next one.But how.I use VC# 2005.Please help me. ps: backmusic = new audio(file); I have tried with: private void backmusic_Ending(object sender,EventHandler e) { MessageBox.Show("The file has finished"); } PS: Sorry for the gramatical mistakes.I don't know very good english.THANKS ...Show All

• Windows Forms TreeView owner draw

  Hi, I'm customizing a TreeView do draw lines lines from one node boundary to another point outside the treeview. Can I continue to draw a line to a point outside the treeview control How I tried to draw a line from the node until the TreeView control boundary.That was ok. Now, how can I get that exact point to start drawing a line to another control boundary (The other control is also a TreeView, I wanna draw lines connecting some of these treeView nodes). Help is really appreciated, D Hi,DevDiver If you want to draw lines between different controls, you must do the paiting work in the Form's OnPaint event ,and t hese twomethods maybe helpful for you if you want to translate the location ...Show All

• SQL Server Output Buffer Remove Row?

  I am using a script component to create the output buffer dynamically. I use the Outputbuffer.AddRow() call. I then set all the fields I want, and its added to the output and later inserted into the database. If a field value fails it causes an error, but the record is partially inserted upto the point where the set field command caused the error. So if I set 10 fields, and it fails on field 5 it inserts data for the 5 fields that worked and nulls into the others. As a result I have a try catch clause, and if it fails I want to cancell the addition of the new row. Is there a command like RemoveRow(), rollback, etc that can be used to not insert the record in error Sample code.. Try PaymentOutputBuffer.AddRow() PaymentOutp ...Show All

• .NET Development How about constructors that are selfaware?

  I ran into a solvable problem that led to the following consideration: why not allow a return null from a constructor There maybe times when the state of a system may not allow the instantiation of an object. I posted the following on the Code Project: http://www.codeproject.com/script/comments/forums.asp msg=1591017&forumid=1650#xx1591017xx What do you think ...and if in your situation the non-creation of an object might not count as an error as such (i.e. it might be something non-exceptional that you expect to be a common occurrence) then the appropriate solution would be a factory function. Factory methods are just static methods ('Shared' in VB.NET) whose job is to create new instances of objects. That makes them ...Show All