John Oliver (UK)MSP, VSIP's Q&A profile

• SQL Server Regarding login in linked server

  We are using linked servers to access another server, we are using windows authentication. but when we use EXEC master . dbo . sp_addlinkedserver @server = 'SERVER' , @srvproduct = N 'SQL Server' EXEC master . dbo . sp_addlinkedsrvlogin @rmtsrvname = 'SERVER', @locallogin = NULL , @useself = N 'False' , @rmtuser = N 'sa' , @rmtpassword = N'sa' When we connect using a SQL login as specified in the above line we are able to connect to the linked server. But when we want to connect using a Windows user it is connecting.(we want to connect using a specific windows user i.e only one windows user will be there in the server and we shall access the server using that windows user) EXEC master . dbo . sp ...Show All

• SharePoint Products and Technologies can we go and change the sharepoint pages code or not allowed

  if we want to modify the code of a sharepoint page. can we do that or not allowed ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content Pipeline code official mesh management

  Hi, I've just browse the code of the Spacewar starter kit and on the SimpleMeshRenderer class, the comment says: /// <summary> /// Workaround class until the content pipeline code handles meshes officially /// </summary> public class SimpleMeshRenderer : IDisposable { ... } What is this related to Thanks http://blogs.msdn.com/xna/archive/2006/08/29/730168.aspx and http://blogs.msdn.com/shawnhar/ have information about the Content Pipeline. It wasn't finished in time to be included in the beta, but will be part of the final product. ...Show All

• SQL Server Dynamic Grouping with Report Designer

  I've got this working -- I allow users to have 2 groups, and choose what they want to group by. I'd like to add one extra bit of functionality -- for the inner grouping, I would like my users to have the option "None" -- i.e. don't have an inner group. I've tried setting the group expression of the second (inner) group to "" when the user chooses the "None" option but the report errors out. Any suggestions as to how to dynamically get rid of the inner group Thx Helen Helen: I had a similar requirement and here's how I solved it. For the "None" entry at each grouping level you'll need to include a value for it in the combobox that's the following functions will recognize. Include the ...Show All

• Visual Studio VS6 F1-Help broke after installing VS2003

  My F1-Help no longer works on VS 6 after installing VS 2003. When I press F1, the MSDN Library - April 2000 window opens, the Topics Found window lists the available topics for the keyword I am searching for. But when I press the Display button I get " The page cannot be displayed". I completely removed VS 2003 and re-installed the MSDN April 2000 DVD and F1-Help still doesn't work. The quickest way I found to get F1-Help to work again was to do a re-install of the OS to a clean HD. It seems that there has to be a simpler way. The MSDN April 2000 DVD is installed from a UNC shared remote DVD drive that I have full read access too. We are having this problem on several machines. 1. Running VS6 on a Desktop running Wind ...Show All

• Visual Basic calling a c++ routine from vb

  hi - i have done basic vb and c++ coding for a while. but have never had routines from one call the other. nor have i done much work integrating libraries and such together. here are some newbie questions along those lines. i will search too and am sure it's out there but any directional answers, handy links, or other info is appreciated in advance: i have some routines written in c. can someone point me to a place where it describes from step 1 how to call these from a vb module looking for the syntax, the way to declare them, examples, how to map the data sructures, and how to "include" or link in the c code what if i want to call a c++ routine that uses stl classes from vb are there ways to map those into vb structures also c ...Show All

• Visual C# bool and objects

  I have an collection of objects(arraylist)...in my list is want to check to see if properties within my arraylist have changed by using a _IsDirty flag...but i get an error saying cannot convert object to bool can anyone help me out here [code languge="C#"] for ( int x = 0; x < ArrayList.Count; x++) { if (Convert.ToBoolean(Arraylist[x]) == this ._IsDirty) { } [/code] how should this be yes that looks ok. A better way would be to use the Generic List<> collection as you don't have to do any casting as you are right now....the Generic List<> will hold a type of an object (Tracking.BusinessObjects.OrderLegDetail in this case) which means you don't need to do any casting and can ac ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. day2night

  I wonder if it is possible to activate the day to night feature and if possible how. In the mission fit file you can implement a daytonighttime; for example: f DayToNightTime = 54000.000000 This value is (as it seems) picked up by camera.cpp result = cameraFile->readIdFloat("DayToNightTime",day2NightTransitionTime); I played around withit but can not see any effect in missions. Any idea what the value needs to be, how it can be activated, if it can be acticvated at all I will try it out; thank you. It seems not to do anything; does the entry for daytonight represent seconds Is there any other (hidden) entry needed   ...Show All

• SQL Server Need ID after OLEDB command (insert)

  Hi, I'm stuck on the following thing: After a slowly changing dimension task I replaced the OLE DB Destination task by an OLE DB Command and created the insert manually. This because I need to work further on the dataset. So I do a union all between the output of the two OLE DB Commands (insert and update). Untill here no problem. But than, because I need an ID further on, I do a lookup in the table in which I just inserted and updated my data for the right ID's. When I run this project I get the error message " row yielded no match during lookup ". I don't understand this beacause I just inserted the data and I've checked, it's there. I could resolve this by splitting up in two control flows (reselect all the needed d ...Show All

• .NET Development Short Cut to my application running in the System tray

  Hi I have an VB.Net application running in the System Tray and I have a function in the appln. I need to invoke the function irrespective of the application which is active by assigning a global shortcut or a hotcut key. How to assign a global shortcut or a hotcut key. Is there any chance that we can print some data onto an application. Consider i want to paste the clipboard content to the notepad when or where the hotkey is pressed. I guess we use Process. But not sure how to write onto a running process. I have the code for finding the processes name running on a local machine. Array arr = new Array [50]; arr = System.Diagnostics. Process .GetProcesses(); int len = arr.Length; label1.Text = arr. ...Show All

• SQL Server Data Base Mirroring in SQL server 2005 Express Edition

  HI, Does SQL server 2005 Express Edition or Does SQL server 2005 Express Edition Sp1 supports Data base Mirroring Here is direct quote from BOL, http://msdn2.microsoft.com/en-us/library/ms188712.aspx Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met: The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads. Note: The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition. So, th ...Show All

• SQL Server Question about configurations

  I've been reading up on package configurations, but I'm not quite sure how to use them correctly. If I am developing a package, I want to connect to a testing server. Then, when it is working correctly, I want to connect to a production server. Are configurations a helpful way of doing this, or would it only be helpful if in the future, I need to make the packages reference a different server Configurations are all about taking the environment specific values out of a package and storing them elsewhere to make your packages portable. The configuration will then provide this information when you load the package. Easy Package Configuration ( http://www.sqlis.com/default.aspx 26 ) Jamie Thomson - SSIS ...Show All

• .NET Development setting HOST using webrequest

  I get the following response Host: 10.10.10.10 Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: " www.somewhere.com/dowhatever " Am using Webrequest class to set the above values. However I know that the Host value cannot be set and uses the implicit value. Is there an easy way to set all of the above values webRequest = ( HttpWebRequest ) WebRequest .Create( www.somewhereinthe world/service.asmx ); webRequest.Headers.Add( "SOAPAction" , " www.somewhere.com/dowhatever " ); webRequest.ContentType = "text/xml; charset=utf-8" ; webRequest.Accept = "text/xml" ; webRequest.Method = "POST" ; Canot set the host. Tha ...Show All

• .NET Development Using a string to supply a list in a "where something in (123, 456, 789)" style query

  Hello, I have been following Scott Mitchells data tuturials on the www.asp.net page.. so I'm a newbie and trying to understand how things work...so please if people could just bear with me.. I know I’m going the wrong way about this.. but dunno what to do… I'm trying to figure out how to execute an sql statement of the form: SELECT * FROM MYTABLE WHERE MYCOLUMN NOT IN (123, 435, 678) I have a table like CountyName(varchar) CountryCodeNum(int) Australia 36 Belgium 56 Ireland 376 And want to do a query like Select * from country table where countrycodenum not in (36, 56) And that will return Ireland when i do it in sql server query manager.. But I need to execute this SQL statement from inside an A ...Show All

• Visual C++ [c++] array related problem (and wrong loop use)

  Hello, I have an mage black and white with 256 values of grey. The image is 256*256 therefore it will have 65 536 greyvalues in total, however its only 256 differents values of grey, so it should be store in one single array, lets say called "holdTheColourGrey [256].... where holdTheColourGrey[0] is the pixel totally black, holdTheColourGrey[1] is the pixel a bit less black... until holdTheColourGrey[255] is the white pixel. THe value inside that holdTheColourGrey[0] is the number of times this pixels exist, example if the image is totally black I should have 65 356 in that case!!! Get it Now im using visual c++ and that code that bugs: int histoArray[256]; int sumpixels; int a,b,i; //just counter va ...Show All