Dave-g-o's Q&A profile

• SQL Server LDAP Active Directory Issue

  Hi there... ONe of job which runs every night for accounts update is failing by yesterday.This job uses LDAP Service to update accounts info from Active directory . When i run the query in QA it gives below error "Server: Msg 7399, Level 16, State 1, Line 19 OLE DB provider 'ADsDSOObject' reported an error. The provider indicates that the user did not have the permission to perform the operation. OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare returned 0x80040e09: The provider indicates that the user did not have the permission to perform the operation.]." Nothing is being changes as such. Please Advice. Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Beta2 Fonts

  Has anyone put together a bitmap font class or component for B2 Or even better, did MS build it into the framework somewhere Never put off till tomorrow what you can convert today :) I've been waiting for myself to post a whole slew of tutorials and code that I've been working on, but that doesn't stop me from just making more.. wait that isn't the same thing at all. I think my point is, everyones busy and having fun. You can learn a lot just tweaking the classes to work (and there's not a whole lot of tweaking needed for the font classes) and I'm sure once he gets some time, XNAExtras Beta 2 version will be up lickety split. ...Show All

• Visual C# Unable to copy file during build

  When I try to build my solution I often get this error: Unable to copy file "obj\Debug\MyProjectXXX.dll" to "bin\Debug\MyProjectXXX.dll". The process cannot access the file 'bin\Debug\MyProjectXXX.dll' because it is being used by another process. The project it's trying to build is a class library referenced by a couple of other projects in the solution. The solution builds fine the first one or two times after opening Visual Studio, but after that the only way I can get it to build is to restart Visual Studio. Any ideas what's wrong Thanks This is just a reference problem. That file is holded by some project as a file reference. Even when you don't do that, some tim ...Show All

• SQL Server How to change SQL Server 2005 instance name

  Hi, I have installed SQL Server 2005 Express Edition on my system. The default instance name is set as SQLEXPRESS. I want to change this to something else. Is there anyway I can do that Thanks, pravi Hi Pravi, here is a reference material for renaming a Server / Instance http://msdn.microsoft.com/library/default.asp url=/library/en-us/instsql/in_afterinstall_5r8f.asp HTH Hemantgiri S. Goswami ...Show All

• Windows Live Developer Forums Removing added "Categories", how?

  Hi, Ive added a couple of new categories on my blog, but i now wish to remove them or rename. I created a new post on the blog and created a new category for that post, i then deleted the post and want to remove that category so it does not appear in the category list box. Could anyone enlighten me on how to do this the only thing i can seem to do is add more categories and not remove any custom named ones :( Thanks Jon. GOING THROUGH THE SAME PROBLEM. I ADDED LINK TO DISPLAY ADS ON MY SPACE. AFTER REGISTERING FOR THE ADDS, I LEARNED THAT AN INCOME CAN BE EARNED. FOR REASONS I'M SURE A FEW PEOPLE ARE AWARE OF, I'M NOT ALLOWED TO EARN ANY EXTRA INCOME OR ELSE MY PRIMARY SOURCE OF INCOME ...Show All

• Visual FoxPro Run /N *.msc

  We can't use : RUN /N gpedit.msc (any file *.msc) Please help me to sovle the problem Thanks What's an *.msc file A Microsoft Management Console (mmc.exe) If that is the case you have to make sure the association to mmc.exe is there (go through Explorer and change file types). Have not tried wih *.msc as I never saw the point to run these from VFP but you could try. In any case, it is always better to use ShellExec (Windows API) or even WSH to launch files by directly or by association that shelling to DOS with RUN. Windows API: DECLARE INTEGER ShellExecute ; IN SHELL32.DLL ; INTEGER nWinHandle,; STRING cOperation,; STRING cFileName,; STRING cParameters,; STRING cDirectory,; INTEGER nShowWindow She ...Show All

• Microsoft ISV Community Center Forums Trying to write a VERY VERY simple routine BUT GOT STUCK !! ::) = Brain Ache !!

  Hi, I'm affraid I bit off more than I can chew and It's a while since I programmed. 1/ The routine is set in an open Excel worksheet which has 5 fields/columns per row 2/ The routine reads 1 row at a time, splits 1 field, does some ifs and appends 6 new fields per row 3/ I'm stuck with the Loop 4/ I'm stuck with the IFs especially bracketing 5/ I'm stuck with the output writes I'd really appreciate if you could just wiiiizzz through it and ellimate the mistakes. For you 5 mins for me 5 days. Here it is .... Sub TeamPerformance01() ' TeamPerformance01 ' Name Fields in open worksheet ActiveWorkbook.Names.Add Name:="Date", RefersToR1C1:="=Sheet1!C1" Columns("A:A").Select ActiveWorkbook.Names.Add Name:="T ...Show All

• Visual Studio 2008 (Pre-release) Threadsafe-ObservableCollection

  Hello, I have started playing with WPF. It is very cool. I have a singelton collection object that is derived from ObservableCollection (let’s call it MyCache). I'd like to make sure that it is thread-safe. Seems like I have at least 3 options (I'm not sure if all of them are correct): Option 1: I can go through and make sure the users of MyCache lock the instance before using it. However this is not very appealing. Options 2: So what if I were to override ObservableCollection's virtual methods (InsertItem, RemoveItem, etc.) and lock a common instance every time someone accessed MyCache. Would that solve the problem What would happen to public (non-virtual) methods such as Add and indexOf I have a feelin ...Show All

• Microsoft ISV Community Center Forums OPC and C#

  I am trying to develop an OPC client using C# 2005, should I use the Automation Wrapper provided by the OPC foundation or is there a better way. For the easiest and most reliable OPC connections in C# 2005 applications I suggest our OPC Controls.NET product. The central data communications runs as a Windows Service and the components for your application are all 100% managed. You cannot achieve 100% managed application with direct OPC connections. Visit www.opcsystems.com for more information. Ken Eldridge, Open Automation Software ...Show All

• SQL Server min server memory option and memory paging

  I have problem with sql memery usage. In same case sql paging the data to virtual memory on disk and relese physical memory. And if SQL relese physsical memory, he dont consider min server memory (MB) option (4012MB), after relesing sqlserv physical memory usage is only 500MB. And after sqlserv restart his memory usage is only about 500MB. Perfmon counters: Pages/sec 1450 %Commited Byte in Use 43% %Usage Total Page File 87% Available MBytes Memory 6480 MB My server is: 9.00.2153.00 SP1 Standard Edition (64-bit) Server memory 8GB sp_configure: awe enabled 0 1 0 0 min server memory ( ...Show All

• Visual Studio Team System Team Foundation Server vs SubVersion

  Hi, Did any one has done comprehensive report comparing Team Foundation Server vs SubVersion vs VSS The comparison will be toward business decision. - Cost analysis. How much saving if using TFS compare to others - Efficiency & Productivity - Quality Assurance. - etc Thanks, John Hi John, I'm not aware of a published study comparing the three like you ask. The key difference between TFS and the rest is the highly integrated nature of Source Control with Worth Item tracking and the fact that you have a data warehouse on top of both. In terms of raw source control features, TFS and Subversion compare well. Obvioulsy, TFS has the benefit of talking to SQL Server 2005, meaning that any SQL t ...Show All

• Windows Forms DataView Sorting

  Hi, I have two combo boxes and a DataGridView. The two combo boxes are going to serve as filters for the DataGridView. When the form loads a stored procedure is called to return a number of records to be displayed in the DataGridView. The grid can then be filtered by using either one of the combo boxes. If the selected index changes on either combo box a DataView is created from the DataTable holding the data from the stored procedure and a Row Filter is a applied depending on what the Selected Item Value is. All this works great but the problem I have I need to combine the two filters into one. I.e. if you want to filter the data to show only today’s events and then filter it again to only show a certain type of event. ...Show All

• SQL Server VIEWS With Columns set by NEWID()

  I have a view which at the moment has no unique identifier on each record. When I try adding a column definition to the view such as NEWID() as TransactionId , the view then cannot 1) be selected into a temporary table, or 2) queried on other columns in the table. In either case I end up with an empty result set. I believe I have a way around this for my purpose, which was principally testability. However, can anyone enlighten me as to how and why this happens Andrew Raymond However, you cannot from what I can tell, get anything but an empty result set from: select * from bobPlusUniqueIdentifier where bobId = 2 That is the strangeness. If I select the full view, everything seems fine. ...Show All

• .NET Development DataReader problem (My final straw)

  As a newbie to VB.NET I am rather please with a project that I am completing for my university course. There is one problem that has kept me from completing my project so far, and that is that I can not extract a value from the table of and Access database. To set the scene, I have a form that inserts the values from text boxes into variables and from variables to a database table. This works fine and I have no problems here. (see code below) What I need to do next is retrieve the customerID that is auto generated in the data base, this needs to be stored as a variable in the form and then passed to the next form so that it can be used to make a booking. I have got the code that passes the variable across the ...Show All

• Visual Studio DataGridView wrapper - additional property-combobox fill up

  Hi All, I have made a datagridview wrapper, in wich I add properties to grid for the developer to see at the design time in properties window of the grid . The properties in which developer has to type in a value, those are easy to do. But now I have to make a property as such which appears as a combobox and has 2 values(same as autoscroll property of datagridview -where we have true and false as two default values, and false is default) which are strings and appear in dropdown. I have been able to make a property appear as combobox, but I am nto able to fill up the dropdown list. The code to make property as combobox is here below: ComboBox formManagerMode; public ComboBox FormManagerMode { get { ...Show All