mepatuhoo's Q&A profile

• SQL Server Error in installing SP1 or sp2

  I have a sql server 2005 developer edition installed on my windows xp system. I apply sql server 2005 sp1 then sp2 all does successfully. Now I have installed same sql server 2005 developer edition on windows 2003 server When I installed sp1 or sp2 i get the following error --------------------------- Invalid Login Information --------------------------- Your account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To proceed further deselect the instances to which connectivity cannot be established. --------------------------- OK --------------------------- I have done every thing.PRovided sql server as wel ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A problem with SpaceWar Starter Kit

  I have installed XNA Game Studio Express to my Visual C# Express, i have started a new project, but I got problem. I successful compiled it, but I don't see a cursor in the game so i can't select choice in menu and keyboard also doesn't work. What's wrong It doesn't help. In readme is How to build it, but that's like press F5 for Debug or F6 for Build. Nothing about the keyboard's setting or the cursor. ...Show All

• SQL Server shared data source

  I experimented a strange behavior using connections for data source inside packages in vss 2005. Suppose we have a tab1 in a develpment source db and in a test source db: tab1 dev db contains 100 records tab 2 test db contains 200 records I start developing a package using an 'ole db data source' task inside a data flow. When I change the data source from dev to test, strange thinks happens. The 'ole db source task' retrieve only 197 records ... but if I open the connection inside the connection manager pane and only after i click on the 'test connection' button tI get 200 records. The source db is a sql 2000 db server and I use ole db provider for sql server. Cosimo cosimog ...Show All

• Windows Forms Multiple Rows/Lines in a single Gridview row?

  Maybe I'm missing something obvious. Using ASP.NET 2.0 I'm trying to create multiple lines of data in a given row of a Gridview. Like so: Select ID# Name Date Phone Job Description............................. I tried using an ItemTemplate on the last field and throwing out a <tr> and some <td>'s but then it didn't pick up the alternaterow styling on the my newly defined second table row. Ideas Thanks This forum this from Window Form Developing, for ASP.NET questions, I recommend you post them on http://forums.asp.net for better responses. ...Show All

• Visual Studio Shadow Folder Problem

  i have a problem with shadow folders. i use source safe to develop a asp.net web site in a team. i want the website to be shadow copied to inetpub to be live just in time when somebody checks in a file in visual studio. but when checking in a file in visual studio the shadow folder file is not updated iis and source safe are installed on the same machine, so i think that the impersonation is not the matter. when i open source safe admin and open shadow folder config then everything is updated, but that's not what shadow folders are for ;) the problem only occurs when checking in via visual studio integrated check in... any suggestions thanks in advance, regards, daniel If VSS Internet plug-in is used VSS Web Ser ...Show All

• SQL Server Want to include a field from a data set in the Header of a report

  I am using reporting services 2000 to report of an OLAP cube, I am using an id value e.g. 1234 as the parameter to the MDX query however the client wants to see the member name e.g. J.Smith so I have created another data set that queries the relational database for the parameter name. select emp_name from emploees where emp_id = '1234' This works fine , except when I try to add the Emp_name to the report header I get the error message : "Fields cannot be used in page headers or footers" I can include this in the report body but is there a better way to do this Thanks Umesh Hello Umesh, Declare a report parameter. Assign this value to the report parameter as said in earlier replies. Pla ...Show All

• SQL Server error:no report server found on the specified machine while setting up reporting services configuraion manager

  Hello, I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace ... the installation is local ... Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server... Can somebody please help me on this... Thanks in advance... Nirupa Hi Jarret, Thanks for your suggestions first, yes I installed IIS and it is running, and I couldn't find any fol ...Show All

• SQL Server missing tables

  I have a database that I have been working on that is on a remote server for a website. I recently had them back up the database so I can work on it locally. After some time I managed to get the backup working, well sorta. Originally the database was a access 2000 database. This soon proved not to be up to the task. The server people converted the database to sql 2000 and everything is working on the site. However my backup has a problem. In the manager I can see all the tables that were there before. But when I go to run a query on the database through CF the only tables that it can see are tables that were created after the access conversion. I have gone in and checked permissions and set every table and every column to public and still ...Show All

• SQL Server Cannot delete users in SQL 2005?

  Hi, Running multiple SQL 2000 servers and on each can easily go under Enterprise Manager>>ServerXYZ>>Security>>Logins>>Delete and delete user regardless users DB membership etc...now installed SQL 2005 (MS SQL Server Management Studio) and trying to do the same (attached to server running SQL 2000) and I cannot do it. Each time I try it, I am getting: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Login 'testdelete'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.3033.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Dro ...Show All

• Visual Studio Express Editions Disappearing Image

  I got the following Code from a book which was devoted to 2005 Express. I put an image in the PictureBox(picPic) and can go on to print it. [In this program I have a PrintPreview so saving the actual print.] However! After printing the image disappears from the Form (And I suspect the actual PictureBox as well!). If I use the event to select a different image, this new one doesn't appear on the Form but it shows on the PrintPreview and prints. Can some kind person please tell me why this is happening. I have obviously tried to work it out, but I am baffled! Please let me have the solution. Thanks in advance. AliBong. Imports System.Drawing Imports System.Drawing.Drawing2D Imports System.Drawing.Imaging Impor ...Show All

• Visual Studio Team System Changing user while Connecting to Team Foundation Server using Visual Studio 2005

  Hi, I connected to Team Foundation Server usin Visual Studio 2005, with a user name and password. Now whenever I connect to Team Foundation Server, the Studio users that user name and password. I wan to connect using a different user name. How can I do so. I have tried cleaning the history from Internet Options, but it doesn't work. Please help. - Rajiv I am connecting to another network using a VPN and now I tried "run as" over the Visual studio icon. I used my credentials in that network and i am prompted with the message -"Logon failure: unknown user name or bad password .". Please help me out. ...Show All

• .NET Development Use...connetion pooling

  Hi, I'm working in a reporting application that use data from several databases that reside in the same sql instance. I'm using lazzy initialization to load data to a memory cache in my application, so the first time a table is accessed my app connects to database, get the data and close the connection. The next time it uses data in memory. But data is in several databases so almost every query is like: "USE database1;SELECT * FROM TableA" "USE database2;SELECT * FROM ViewB" I'd like to know if connection pooling is compatible with "USE" instruction. Thanks! Connection pooling is based upon the connection string, the process and an app pool (if available). The Transac ...Show All

• SQL Server Memory question

  Hello. I have just intstalled 32-bit 2005 Standard Edition on a W2003 SP1 Server. Am I right in assuming that this version will use as much memory as it can grab from the server up to a limit of 4Gb without me having to alter any settings in SQLServer or Windows Thanks What's the w2003 version If it is x86 OS, the max vas sql can use is 2GB according to default sql configration. If it is x64 OS, the max memory of sql is up to 4GB (assume the physical memory is enough) ...Show All

• Visual Studio Team System How to recover a delete revision

  HI I remove from one of my branches a file (version) - how can I roll it back/restore it and bring it back to my project Thanks, Hello, There is an option (located in Tools->Options->Source Control->Visual Studio Team Foundation, checkbox "Show deleted items in the Source Control Explorer") to show all deleted items in Source Control Explorer. Once you see the deleted items, you may perform Undelete (right-click on deleted item - it will be grayed out in Source Control Explorer). As many other operations, the Undelete operation appears in Pending Changes toolwindow and you must checkin the change for undelete to become effective. Yours truly, Eugene ...Show All

• Smart Device Development Unspecified serial port issue.

  hi, currently i'm doing a program for pocket PC connected to RFID reader using Serial Port. I'm very new with the program with window CE. I had done the same program in Window Form and it running well. But, when i transfered the program to Smar t Device Application, the program not running well. I had try 2 ways. First is using timer, and second is using serial_portData_Received. Below is the codes: Using Timer: program stuck on sp.Write( new byte [] { 0xC0, 0x02, 0x01, 0xFF }, 0, 4); =inside timer private SerialPort sp; private void Form1_Load( object sender, EventArgs e) { #region Serial Port Init sp= new SerialPort (); sp = new SerialPort (); sp.PortName = "COM1" ; sp.BaudRate = 11520 ...Show All