Mike New's Q&A profile

• SQL Server cannot start or verify that SQL 2005 is running

  Hi, I am new to sql 2005. I have installed a trial version of 2005 enterprise edition. After installing I went to Management Studio. I noticed that the server name dropdown menu was blank so I tried to browse. No server names appear under local or network servers. I then went to configuration manager and noticed that although client protocols are listed under SQL client native config, SQL server 2005 services and sql server 2005 network config are both blank. Is SQL installed correctly I hope this is enough info to illicit a helpful response. Thank You. Problem solved. I went to a ...Show All

• Visual C# .net 2.0 problems

  Whenever I try to use anything from the 2.0 framework I get an error in VS2005. If I have "using System.Windows.Forms.VisualStyles;" The compiler tells me "VisualStyles" is not part of the System.Windows.Forms namespace. I've tried reinstalling VS2005 and .net 2.0, but no luck on either case. Things like AutoScaleMode don't work either. Anything pre-2.0 seems to be working fine. I'm just wondering if there is some weird way to choose which version of .net it uses (a la Eclipse for Java), and I somehow rolled it back to 1.1. Stupid, I know. But I can't seem to figure this out. Thanks in advance. Post a screenshot of ...Show All

• Visual C++ Repedative Syntax error : missing '=' and ')' and ';'

  I wrote this section of code here today and everything went bad and i dont have a flipin clue why! More than likely i am simply missing a very minuet error probably from staring at the same lines of code for the past 7 hours. these are the error messages i get ONLY in the section that i just wrote: in_camera.cpp(453) : error C2143: syntax error : missing ';' before ')' in_camera.cpp(454) : error C2143: syntax error : missing ';' before '{' in_camera.cpp(454) : error C2059: syntax error : '=' in_camera.cpp(454) : error C2143: syntax error : missing ')' before ';' in_camera.cpp(454) : error C2143: syntax error : missing ...Show All

• SQL Server Dynamic Scripting for USE [DB]

  Greetings, I am having a difficult time figuring out a way to get this to work.  The scripting executes without error, but does nothing.  What I want it to do is change the connection to the database retrieved by the cursor. DECLARE @PAR1 VARCHAR ( 256 ); DECLARE DB_PAR CURSOR FOR SELECT NAME FROM SYS.DATABASES WHERE NAME LIKE '%HRN%TEST' ; OPEN DB_PAR FETCH DB_PAR INTO @PAR1 BEGIN EXECUTE ( 'USE ' + @PAR1 + ';' ) PRINT @PAR1 /*Show what the par value is */ END ; CLOSE DB_PAR ; DEALLOCATE DB_PAR ; Anyone have any ideas Something else I thought of.  Oracle provides the ability to change the da ...Show All

• .NET Development Webservice connection problem

  I'm quite new to .net programming and I have written a project using .net 2.0 framework (written in vb.net 2005) in which I've add a webservice reference. If the referenced webservice is called more than once the connection drops out. I have researched the problem and have seen the likely problem is the first connection is kept alive by default and so subsequent connections fail. The fixes that I can find seem to only relate to .net 1.1 with following code snippet being entered into the webservice-->Reference.map-->Reference.vb file of the project: Protected Overrides Function GetWebRequest(ByVal uri As Uri) As System.Net.WebRequ ...Show All

• SQL Server Access DB2 on AS/400 using IBM OLE DB Provider

  Hi, I am using the IBM OLE DB Provider (IBMDASQL) provided with Client Access (IBM) to access a DB2 database on an AS/400 (iSeries). Using an OLE DB Source in the data flow and Access Mode set to "OpenRowset" this works fine (even though I think it is quite slow). However, when I change the Access Mode to "SQL Command" my data flow fails at the OLE DB Source component - not giving me any meaningful error description (only the mysterious "... the error is specific to the component..."). Using and SQL Command to access the data is important to me, since I need to put a WHERE-statement on the rows returned from the source. /Michael PS: I am no ...Show All

• Visual Studio Team System Reporting Services Error when clicking Issues List on project home page

  Hi. I'm running Team Foundation Server RC (upgraded successfuly from Beta3 Refresh). I can successfully create new projects, but when I click the Issues List link from the project's home web page I receive the following error: Reporting Services Error This report requires a default or user-defined value for the report parameter 'StateParam'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet) Thanks. The Work Items report has default parameters to show only those work items that are either "Active" or "Resolved". ...Show All

• .NET Development how to show string of data in text box using parmeter query

  I am tryin to input an ID number and retrieve all the information from that particualr ID Private Sub btnSubmit_Click(Byval sender As System.Object By val e As System.EventArgs)Handles Button1.Click connClass.Open() Dim cmdStudents As New OleDb.Command Dim sStudents As String = Select Student Name, Information From ClassName Where Student ID = cmdStudents.CommandText = sStudents daStudents.SelectCommand = cmdStudents Dim cbStudents AS New OleDb.CommandBuilder() cbStudents.DataAdapter = daStudents Here is where i run into the problem Dim ol As New olet2() 'This is my other form with a textbox1 If textbox1.Tex ...Show All

• SQL Server Determining the most appropriate conversion for a string

  Hi, Is there some kind of code snippet to determine (a) the precise data type (and precision if appropriate) of a given table.columnname in the database, and (b) the most suitable conversion for a varchar that is being made to hold various types of data. Presumably based on the above one could have some sort of CASE WHEN to cast the data to different types accordingly. Thanks for any help on this. You need to use the system tables. Check out sysobjects: http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_sys-t_2983.asp syscolumns: http://msdn.microsoft.com/library/default.as ...Show All

• Windows Forms Help! Number Pad Negative key not working in DataGrid ...

  Hello.. When using a Windows Forms DataGrid, the Negative key (-) does not register when pressed. All the numbers on the pad work fine "0-9", including the "/" and "*" keys. Am I missing something here  Also, the Negative Key along the top of the keyboard DOES work however. Thanks in advance - B Thanks- However - I do not  ...Show All

• .NET Development Servers, Pages and their controls and HTTPWebRequest.

  Recently I was asked how to push button on a web page control programmatically and I realized I didn’t know. For the last couple of weeks, I’ve been playing with HTTPWebRequest and getting the samples to work. That’s a wonderful class and it looks as if it exposes every possible thing that could be exposed, but I realized after all the code that I still don’t know how the pieces fit together.   I have a single XP node and I’ve set up IIS to run an old ASP page I wrote years ago. I know that there is an exchange of headers between a client and server and a series of GET’s and POST’s. But the simplicity stops there. For example if I ...Show All

• Visual Studio 2008 (Pre-release) DLink and WCF

  Hi, WCF issue with DLink : 1)I can only return concrete 'objects' like "Customers" with all fields ..If I do 'var items = from c in db.Customers select c.City". How I can return only one or two fields without explicit it in return of WCF method 2)How I can return a "Customers" with "Orders" without uses "Lazy loading"...or "Deferred". Thanks, Alexnaldo Santos In regards to your second question, you can prefetch and cache the results using the .ToArray or .ToList extension method. Additionally, you can tell the query to load all orders as it ...Show All

• Visual C# One question about image capture of a specific control's client area

  We are doing some image capture of a specific control's client area (in C#). Following is a part of the code of how we do that private void CaptureImage_BitBlt(Control Ctrl, string FileName) { using (Graphics Graph1 = Ctrl.CreateGraphics()) { using (Bitmap MyImage = new Bitmap(Ctrl.ClientRectangle.Width, Ctrl.ClientRectangle.Height, Graph1)) { Graphics Graph2 = Graphics.FromImage(MyImage); IntPtr dc1 = Graph1.GetHdc(); IntPtr dc2 = Graph2.GetHdc(); // transfer the bits from memDC to clientDC BitBlt(dc2, 0, 0, Ctrl.ClientRectangle.Width, Ctrl.ClientRectangle.Height, dc1, 0, 0, e ...Show All

• Visual Studio Team System Error TF53011 on TFS RTM

  I installed RTM (workgroup) here and now the users are getting this error trying to login: TF53011: domain\user is not a licensed user... I was supposed to have 5 licenses with the workgroup version right Anyway, I can't find any tool to configure licenses in the server. * The team explorer on the client was successfully updated to RTM too. Regards, Max I have just run into the same problem. Take a look at: http://blogs.msdn.com/vstsue/articles/556043.aspx Good luck, Si B... ...Show All

• Smart Device Development what is MMI?

  hi all, I was trying to execute "Receiving SMS inside a managed application" which doing its job on Pocket PC application but when I got from MSDN site that for applying this code to Smartphone2003 we will have to change MMI part. I dont know anything about MMI. Please help me, Hi MMI stands for M an M achine I nterface - that's just the GUI of the application. Michael ...Show All