Sam Gentile MVP - .NET's Q&A profile

• Visual Studio T-SQL Debugging on VS2005/SQL2005

  Hello, I can't seem to debug an SQL stored procedure using VS .Net's 2005 debugger. When I Step into stored procedure the breakpoint turns to a question mark and  says "The breakpoint will not currently be hit.  Unable to bind SQL breakpoint at this time.  ...Show All

• Visual Studio VSS 6: Append_EOL not working

  Hello, I have been using Vss for more than 8 years now, and have had a specific request from my colleagues who are using a compiler for embedded devices that requires file to end up with a CR/LF. I have seen in Vss documentation that there is a specific option for this which is Append_EOL. I have therefore initialized that variable to yes in the srcsafe.ini of the database, the option is well propagated to each client (the relevant box app ...Show All

• Windows Forms C# question

  What's the equivalent of the below in C#: Private WithEvents MDIControl As MdiClient Thanks Hopefully nobody would write that line of code in .Net...  they'd add a reference to ADODB and use: Dim abc As New ADODB.Recordset or Dim abc As ADODB.Rec ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. System.NullReferenceException was unhandled

  Hi! In my windowed control, whose rendering is done completely in Direct-x, I provide the means for the user to change the font. For this reason, my object includes the function SetupFont(), which is called at least once on startup to set the default font, and then it may be called whenever the user decides to change the font. The mobjFontDirectX and mobjFontGDI objects are defined at class level: private void SetupFont(System.Drawing.Fon ...Show All

• Windows Forms IIS on XP Home - missing module in hacks

  Does anyone know if IIS can be installed on XP Home or not as I'm trying to deploy an ASP script that requires ASP and IIS with its virtual SMTP service can someone provide me with the file to do this hack or would& ...Show All

• Visual Studio Team System Build by Project instead of Solution

  Within the Build Type, is it possible to specify the actual projects within a solution to build Currently there is a section in the build type that looks like: < SolutionToBuild Include = " $(SolutionRoot)\Some\Path\Solution1.sln " /> < SolutionToBuild Include = " $(SolutionRoot)\Another\Path\Solution2.sln " /> Instead of building an entire solution, can we specify which project in the solution to build.  I see example ...Show All

• SQL Server Miltivalue Parameters with Max Pool connections

  I am trying to write a report with many different records needed (way the database was designed). Client will need multivalue parameter and I have reached max pool connections(can anyone please give me the number). Normally I would handle this with a stored procedure to create a temp table with the needed information for each section(one row per section), but this will not work with the multivalued parameters(more than one in this report). ...Show All

• Windows Forms App.Config returning null values in Windows Services but returns right values in Windows Application.

  Hi All, I have created an Windows Service where I am using App.Config for global variables. But, it is always returning null values ( string xyz=ConfigurationSettings.AppSettings["abc"]) for all the variables I have declared in App.Config. (But the same thing if I am doing as a Windows Application then it's returning the right values.) Interestingly, this same Windows Service is working properly in another machine but not ...Show All

• SQL Server Proxy Error

  I a have small bunch of jobs which are scheduled to run under a proxy account. For some reason, each night a random handful of those jobs fail with the following error: Message Unable to start execution of step 1 (reason: Error authenticating proxy LSP\JobUser, system error: Logon failure: unknown user name or bad password.). The step failed. The jobs that fail are always random and if I manually run the job, EVERY one of them works fine. ...Show All

• .NET Development Thread corruption issues with 64 bit framework?

  Anybody else having troubles with multiple threads running in the .NET 2.0 framework in a 64 bit app   I have an application that queries a server, then reads the results back on a seperate thread. Each chunk received is doled out to yet another set of threads before using Control.Invoke to resync to the UI thread. This model works perfectly in the 1.1 framework, and in fact works fine in the 2.0 framework when run as a 32 bit app. But whe ...Show All

• SQL Server performance issue with trans log on tempdb?

  I am running in to a tricky issue, and am hoping someone here has seen something like this before. Here's the basic sequence I am working with. A temp table #A contains some number of rows (in this case, about 45k rows). 1. Create temp table #B and insert a subset of the rows in #A (in this case, the subset happens to be 100% of #A) 2. Perform a few dozen updates to #B, using data from permanent tables. 3. Update the rows in #A with #B, ...Show All

• Visual C++ Simple Simple COM

  Hi! I do all my programing stuff in c#.. but i need some plain C or C++ code sometimes.. and i need to interact classes made from C/C++ to C#. As i heared this is done with COM`s Can anyone show the simpliest COM made in C/C++.. that has a Class named Test and a method int Add(inta, int b); that return the sum of them.. Please make it simplie as possible.. coz i`m not really good at C/C++.. COM things.. If you're starting with C#, then you ...Show All

• Visual Studio Express Editions Memory Leak

  Hello people,         i am a new bie in vc++ programming. My projcet preformance is degraded because of memory leak. It would be a great help if ypu guys help me pur with my school project. th following code give me a memory leak ---------------------------------------------------------------------------------------------------------------------------------- void CMemoryLeakDlg::OnBnClickedOk() { // Me ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX 9 in visual basic 2005

  Hello all,     I am an experinced user of Visual Basic 2005 Express Edition, but am failing terribly when trying to apply DirectX, Direct3D and other techniques.  Does anyone know where I can find directx tutorials that have visual basic code examples   I would really like ot learn.  I have tried literally hundreds of c++ tutorials and they never compile, whether the creater of the source says it works or not.  ...Show All

• SQL Server Is it possible to use T-SQL to create a user in Active Directory?

  Is it possible to use T-SQL to create a user in Active Directory John, Not directly.  T-SQL does not support the collections necessary to correctly populate Active Directory (i.e. Group Memberships, etc).  You could in theory write a CLR Stored Procedure that creates a new user in Active Directory and then call the stored proc from T-SQL. What is the purpose of populating AD from SQL &nbs ...Show All