Douglas McClean's Q&A profile

• Visual Studio .root folder

  A copy of my project name except with a .root extension is created in VSS. I am not quite sure why it did that. I started to appear after I was having issues trying to checkout files using VS2003. Any insights Which one should I use - projectA or projectA.root "solutionName.root" is the name SourceSafe provider suggests when you run the Add Solution To SCC wizard. You can type whatever name you want. ...Show All

• SQL Server Security in Linked Server

  I have setup a linked server on the same computer but different instances of sql. When I call the sprocs an error occurs... The message is... The OLE DB provider "SQLNCLI" for linked server LINKEDSQL does not contain the table ""product"."dbo"."AccountTable". The table either does not exist or the current user does not have persmissions on that table. I've checked the table "AccountTable" and it does exist. The database exist also which is "product". I also configure the linked server's RPC to "true" and timeout to "200". The linked server is also configured to use a single username and password which exist on the instance of sql that the linked serv ...Show All

• Internet Explorer Development Capturing Browser events

  Am trying to make a BHO which will compute how fast the page loaded,static components in the page(image,js,css etc),How much time each component took to download.For which i need to capture the browsers events(eg request sent to get a css file from the server ).Can somebody plz tell me how to capture these events I've seen the IBrowser2 interface which has Documentstart,Documentend,Download start and end. Thanks in advance... Hi, To get acurate timings of the requests it is probably necessary to watch the request at the protocol level. A tool such as fiddler http://fiddlertool.com may help in this. Thanks -Dave ...Show All

• SQL Server How to reset all tables ownership programmatically through a sp

  Before in SQL 200 I was using this script to do it, even if the change to Ad hoc updates to system catalog weren't allowed: USE Rouyn_Noranda PRINT 'Section 5: Resetting Objects ownership ...' GO update sysobjects set uid=1 where xtype = 'U' PRINT '***** Section 5 completed *****' PRINT '' GO In SQL 2005 change to the catalog are not permitted, is there a way to reset the ownership of all table from a database. Thanks, Stanley Hi Stanley, ----------------------------------------------------- SQL Server 2000 ---------------------------------------------------- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_changeobjowner]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [db ...Show All

• SQL Server Conditional sorting in order by clause

  Hi, I have a query as select name, age, address from employee order by name Now i want to do sorting as ASC or DESC in order by clause dynamically. I tried something like this :- declare @Order int set @Order = 1 select name, age, address from employee order by name CASE WHEN @Order = 0 THEN ASC WHEN @Order = 1 THEN DESC END But its giving me error, Is it correct or is there any other way to do conditional sorting Use the following query it is a conditional sorting... Declare @Order int Set @Order = 1 Selecct name, age, address from employee Order By CASE WHEN @Order = 0 THEN Name End ASC, CASE WHEN @Order = 1 THEN Name End DESC ...Show All

• Visual Basic Can't connect to Access DB using DSN - Help!

  I'm trying to open an Access database using DSN as shown in the code below. When the code is executed, the Data Source Dialog window appears like I want it too. I select an SQL Server DSN and it appears to be returning the appropriate information. However, I need to open an Access Database. The connection returns "nothing". What do I need to do to open a database connection (Access, SQL, Oracle, etc...) Also, unfortunately we're still using DAO...if ADO is better (I think it is), how do I go about connecting to a DB using DSN Thanks Dim dbNew As DAO.Database Try dbNew = WS.OpenDatabase( "" , , , "" ) Catch ex As Exception dbNew = Nothing End Try ...Show All

• Visual Studio Tools for Office Any reason for difference in speed?

  Hi, I have produced a VSTO solution that loads up in about 10 seconds on my development machine, this is running the built code (not run from visual studio) on a virtual pc. However when I test it on a test environment pc, not under virtual pc, it takes over 20 seconds. The first thing it does in ThisWorkbook_Startup is show a splash screen - this takes 4 seconds to appear under virtual pc and almost 18 seconds in the test client. The rest of the loading process takes about 6-8 seconds on both virtual and test pc's. The only difference is I have Office 2003 SP2 (11.6560.6568), while the test pc has SP1 11.6355.6360. The virtual pc is running with 1GB of RAM (although it does have SQL Server 2005 and IIS running all the time), the test clie ...Show All

• Microsoft ISV Community Center Forums Help with interface?

  Hey Just completed my set of macros that i need to fully automate a process i am responsible for in work.  However, i am a bit lost as to the best way to run them i.e. link them to buttons in excel etc.  Is is possible to design some sort of interface in VBA and have it load with the spreadsheet    Normally i will be recieving a spreadsheet containing reams of data which have to be sorted and updated.  This is what my macros will achieve.  But what is the best/most efficient way of loading or applying those macros to a different set of data each month Any help is much appreciated Cheers  EDIT: I have since managed to design a form in visual basic and have all my sub ...Show All

• SQL Server The top sales person?

  I am quite newbie, really grateful for some help how to create a sql sentence in Reporting Services that would return the best sales person from each shop.. The following returns all the sales persons from each shop So how to select the top sales person from each shop SELECT TOP (10) shop.name, SUM(Cd.Price) AS Sales, Personal.Name AS Salesperson FROM Purchase INNER JOIN Personal ON Purchase.Salesperson_id = Personal.Personal_id RIGHT OUTER JOIN shop ON Personal.work_id = shop.shop_id FULL OUTER JOIN Cd ON Purchase.Cd_id = Cd.Cd_id GROUP BY Shop.Name, Personal.Name ORDER BY Sales DESC Or something like this But how in Rep.Services ...LEFT OUTER JOIN ( SELECT P.work_id, P.Name, SUM(C.Price) AS TotalSale FROM @Personal P INNER ...Show All

• Visual Basic create sql table in vb.net code

  Hi, create a table in vb.net connect with sql server. i know create a sql table in sql server 2000. but i don't know vb.net using runtime create a table. pleasew help me. thanks Hi yes. create a table in an application written in VB.NET but not in a database. but store in sql server 2000 or 2005. ...Show All

• Visual Basic Data Sources Window Is Inactive and Data Sources Disappear

  Can someone please help... I have been working on a project in Visual Studio 2005. After changing some of my data sources in the Data Access Layer, all data sources disappeared in the Windows UI layer. This was all working fine until I changed data sources in the DAL and built the DAL project. This is the third time this has happened. I have rebuilt my laptop from scratch, reinstalled Visual Studio 2005 clean and tried all kinds of other things including scraping my whole project and starting over. Everything seems to work for a while until I start making changes to the schemas in the data layer. I have seen a lot of older blogs and posts on this issues but none recently for the production version of Visual Studio 2005. I am using ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Having a little trouble with XNA Spot tutorial...

  I have been doing the How to Draw a 2D Sprite tutorial from xnaspot.com,and I still have a lot to learn and I got all the info inputed and there is one error that I cannot figure out, and that is in the update funtion, I put what I was supposed to, and even tried pasting it, because I have been typing everything to get it down (I would be way past it if I just copied and pasted) and it seems like there should be a }, yet when I put that down it still says }expected, I tried removing it and 9 more errors popped up, so I need to know, what am I doing wrong I would greatly appreciatte any help you guys can give me. Think of braces as a stack. If you use an open brace, add that to the stack. If there's a closing brace, pop a brace off the ...Show All

• SQL Server file destination?

  Hi everybody, I'm new -- sorry, I couldn't figure out how to reply to this thread, I think because it's locked- so I started a continuation. What I am wondering about is if you indicate "text qualified= true" then why does it still get confused by embedded commas in quote-delimited text; I would think that the "text qualified" parameter would take care of that. Can anyone explain So as a work around I am thinking of running a perl script via "Execute Process Task" and clean up the commas that way, since I have little control over how it is produced.. the app it comes from has no ability to contol output, and it outputs it's tables as comma seperated files, with text fields surrounded by quotes. I was hoping to stay inside SIIS fo ...Show All

• Visual Studio Express Editions visual express C # installation will not install on my computer.

  Hi i try to install visual C# installation on my computer it gives me a message saying that setup is loading installation components this may take a minute or two. and i let it go for 20 minutes and it still had not load. can someone help with this matter. thanx!!!! Hi friendz, A few questions so that we can get a better picture of whats going on: a) What OS are you trying to install C# on b) What is the spec of you computer (cpu, memory, hdd) c) How are you trying to install C#, from a download or from a CD image I expect that you are trying to install from a download, and if so are you still connected to the internet As the download only downloads an installer and you will ...Show All

• Windows Forms multicolumn dropdownlist in a gridview in VB 2005

  I need to create a autocomplete multicolumn dropdownlist/combo in a gridview in VB 2005. How can i accomplish that Alex please refer to this one. http://www.codeproject.com/vb/net/multicolumncombo.asp Here is another possible way, you construct the format of each item by yourself. A combo using as datasource a data view I create an SQl string with field 1 and then as second field the field 2 padded with blanks then the 3rd field You can make 10 blanks or so. strSel = "Select myfield1" + " + REPLICATE(' ',(100 -LEN(" + myfield2 + "))) + " + myField3 + " as " + myfield2 mySqlDA = New SqlClient.SqlDataAdapter(strSql, mySql ...Show All