#DressedMan's Q&A profile

• SQL Server Error after migrating to SQL Server 2005

  I'm trying to migrate MS Access 2003 query into SQL Server 2005 view. I'm getting error for the following query. ERROR: Incorrect syntax near the keyword 'LEFT' MS-Access query: SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, tblP.SocialSecurityNumber, tblP.Comment FROM tbl LEFT JOIN tblP ON tbl.AutoNumber = tblP.RecordNumber WHERE ToBeProcessed='YES' and [Cancel]=0; SQL Server View: CREATE VIEW dbo.[qryReport] AS /* * Generated by SQL Server Migration Assistant for Access. * Contact accssma@microsoft.com or visit http://www.microsoft.com/sql/migration for more information. */ SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, ...Show All

• .NET Development SQLDataAdapter gets a "General Network Error" only on the server

  My application, for the purpose of resolving this problem, is a windows console application. It connects to Oracle and gets data into a OracleDataAdapter and Dataset. It connects to a SQL server and runs simple queries, deletes, and updates ok. However, when I attempt to perform an action like da.Fill(ds,"TableName") I get the General Network Error, even though I am using an existing open connection to the database. The query that returns the data is fairly complex but the error occurs even when only one rrecord should be returned. I am using Integrated Security=SSPI;Persist Security Info=False; etc in the connection string The error occurs even using an admin account. Heres the gotcha, it works fine for me when I run it on my ...Show All

• SQL Server Career Path

  Hi. Sorry if this is a little off topic. I was wondering if someone could provide a little advice please. I currently work in a software development team leader role working in mainly VB.NET and SQL Server 2000 technologies. Recently I’ve become more interested in data analysis and decision support systems etc and am thinking in the future I’d like to specialise in this area. I was wondering if anyone has any advice on courses and accreditations that would help me to get into this field. I don’t have any previous experience of analysis services or similar tools but have several years of SQL experience including writing applications, reports and as an administrator. Many thanks in advance. This ...Show All

• SQL Server Syntax issues with UPDATE in SQL2005 Table-valued functions

  I am trying to make a simple mod to a table based on a select and keep getting a syntax error - problem is I can;t see it!! I think I may be going Mad...........Code is: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo] . [fncunprinted] ( @Start datetime ) RETURNS TABLE AS return SELECT dbo . frclients . [Name] , dbo . frclients . Title , dbo . frclients . Inits , dbo . frclients . Addr1 , dbo . frclients . County , dbo . frclients . Pcode , dbo . orders . Printed , dbo . orders . Orddate FROM dbo . frclients INNER JOIN dbo . orders ON dbo . frclients . Account = dbo . orders . Account UPDATE dbo . orders SET printed = 'Y' WHERE ( dbo . ord ...Show All

• Windows Networking Development Vista RTM can't open new socket.

  Started here . Due to (stupid) limitation in TCP/IP driver (10 half-open connection) sometimes Vista loosing ability to access an internet (open new socket for communication). It happens when user uses P2P applications (BitTorrent, eMule). But in could be caused even by too busy IIS. BUT all existing internet-connected programs (WLM, Skype) are running. PC even is accessible via RDP. No any entries in EventLog relating to any problem with sockets. "Event 4226" appears in absolutely different time, not in time when connection was blocked. Only reboot or (sometimes) "Network Connections" (and ICS) service restart can help to revive network back to live. This problem is accepted by many people (see post on Channel9). Any settings in registry ...Show All

• Visual Studio Sandcastle Help ???...

  Hi, I created chm files using sandcastle(both the command line version(July CTP release) and the GUI version created by Eric Woodruff) but there seems to be a problem. The document doesnt contain all the classes that are part of the dll. The comments related to these classes is showing up in the comments.xml file but are not appearing in the compiled chm file. I have abt 18 classes in the library but the final chm file shows only 14. Any advice regarding this issue would be very helpful. Thanks, Sharath If you are using the help file builder and can reproduce the problem in a small example, you can e-mail it to me and I'll take a look at it. My e-mail address is in the About box and the footer of the pages in t ...Show All

• .NET Development Jagged arrays are not cls compliant

  Hi Guys, While analyzing my code with FxCop 1.32, I get the following "Breaking" - rule: "MyMethod" uses a multidimensional array of 'System.String[, ]'. Replace it with a jagged array if possible. ( Jagged arrays are not CLS Compliant .) " Please, help me with the above issue. Thanks in advance Yogendran (yogi) The links are very useful. Thanks a lot Andreas Johansson. ...Show All

• Visual Studio Team System Database error SQL error 2627 on tf merge /baseless

  What's up with this error on a 'tf merge' We think our IT folks applied a patch this weekend - we think it was a SQL server patch... Should we expect baseless merges to work or not tf merge /recursive /baseless . C:\destDir A database error occurred (SQL error 2627) ---> Violation of PRIMARY KEY constraint 'PK_tbl_Lock'. Cannot insert duplicate key in object 'dbo.tbl_Lock'. I just got this also. I did a baseless merge and all the files that were really different merged fine but I was left with 900+ Conflicts. of those about 100 were in binary files which I expected. The remaining 800 or so were all in *.cs source files, all of which where identical in both branches. You appear to indicate t ...Show All

• SQL Server What happened to the ADO.NET 3.0 May CTP?

  It was announced here http://bloggingabout.net/blogs/erwyn/archive/2006/05/11/12167.aspx and then within a few days, the documentation was so completely removed from MSDN ...it was like it never existed. Why was all of the documentation for ADO.NET 3.0 removed from MSDN More importantly, today's announcement of the EDM Designer CTP: http://blogs.msdn.com/adonet/default.aspx . ...Show All

• Windows Forms cannot find table 0

  Hi all, I had the following piece of code. System.Web.UI.WebControls. DataGrid EOWDataGrid = new System.Web.UI.WebControls. DataGrid (); conn = new NpgsqlConnection ( "Server=" + PGIPAddress + ";Port=" + PGPort + ";User Id=" + PGUserName + ";Password=" + PGPassword + ";Database=" + PGDatabase + ";" ); this .Controls.Add(EOWDataGrid); NpgsqlDataAdapter pgDataAdapter = new NpgsqlDataAdapter ( "select \"wid\",\"wstart\", \"EOW\" from \"lwinfo\" where \"wstart\" >='" + tsFromSecs + "' and \"wstart\" <='" + tsToSecs + "'" , conn); conn.Open(); ...Show All

• Visual C# Where is csc.exe in NET 2.0 SDK?

  To all, I have downloaded the .NET Framework Software Development Kit (SDK) version 2.0 and there doesn’t seem to be a csc.exe. I have C# Express installed, but I am just learning the language and it is my experience that to really learn a language it is best learned without the assistance of a fancy GDE. So I just want a cmd prompt. Additionally the book I am using is an older copy of Jesse Liberty’s ‘Programming C#’ (O’Reilly, 2001) and the examples use csc.exe. From what I can tell it should be under ‘C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin’, but it isn’t. Help John Garrett no worries. you need to download the .NET Framework, its included in that. not sure about the SDK however (wouldnt see why it wouldnt be in ...Show All

• Visual C# The "Target" property is reserved, and cannot be modified.

  Can anyone explain this error message. It first appeared when attempting to build a project from a command line. It now appears anytime I attempt to create a new C# Windows application. Peter, Thank you for taking the time to actually read my question. As I said, simply creating a new project causes the error. It turns out that we had an environment variable named "Target" in the system. Removing that cleared up the problem. Frank ...Show All

• Visual Studio Express Editions Can't download from microsoft also

  I ve been having a similar challenge. I can not download from microsoft. I have comcast and have spoke with them they say they are not blocking my modem and that it is a microsoft problem. I have three PC's in my home and none of them can download from microsoft. They all have valid windows XP installed. I am able to get auto updates, and when XP is reinstalled onto my pc its goes through the validation just fine. I get a can not display the webpage every time i try and download something. I am not able to even open the validation link pages to run the validation checker tool. I have XP pro and Explorer 7 which i have made sure that all the active X options are enablesd and that the enable third party extentions in the ad ...Show All

• Visual Studio Express Editions An error has occurred while establishing a connection to the server

  I started a project that contains a SQL database. I had not even started codeing yet i was just building the data base. I saved the project and now when i try to open the database explorer to work with the tables i get this error --------------------------- Microsoft Visual C# 2005 Express Edition --------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) --------------------------- OK --------------------------- I have closed the projec ...Show All

• .NET Development comparing char

  command = new SqlCommand("SELECT AID, UID, isDefault FROM Alert where (UID =" + uid + ") AND (isDefault='"+isdefault+"')", dc.Connection);         reader = command.ExecuteReader();         while (reader.Read())         {             try             {                 if (uid == (int)reader["UID"] && isdefault == (char)reader["isDefault"])                 {   &nb ...Show All