ku19832001's Q&A profile

• SQL Server EXCEPT not working

  TIA. Here is my situation: I have two tables that I need to find the perform an EXCEPT op on. Table1: ToBeAddedCodes CodeID - varchar(14) Table2: ExistingCodes ExistingCodeID - varchar(14) DateIssued - datetime Active - bit ...&c I perform the following command, to no avail: select CodeID from ToBeAddedCodes intersect select ExistingCodeID from ExistingCodes Specifically, the following error appears: Msg 156, Level 15, State 1, Line 40 Incorrect syntax near the keyword 'intersect'. I don't understand what the issue is... Please help. Thanks. Well, I have no control over the infrastructure or anything in fact... I am just stepping in with the .NET development. Unfortunately, ...Show All

• Windows Forms ClickOnce - prerequisites update/install problem

  Hello We are doing a project where we are using clickonce and it works really well and has given us few problem. There is one problem tho that's very strange and we havent been able to find a solution for yet. as part of our clickonce we added one extra "prerequisites"; "Microsoft visual studio 2005 report viewer" but the problem is the same with all the "prerequisites" beside form the default .net one. when clients try too install the application they just get an empty error box.. there is no text at all.. just the red error symble and a ok button. If we remove all but the default "prerequisites" and redeploy it works fine.. we add it again and redeploy the same error again. We tryed to place the updates ...Show All

• Visual Studio Dates Changing to mm/dd/yyyy

  I've got a report that i've done which has a formula that calculates the last sunday of each month. When i run this report in Crystal Reports XI:R2 the date displays as dd/mm/yyyy But when the report is run from an ASP page only that formula date changes to mm/dd/yyyy   Any Ideas why it does this Checked all that and every thing is set to UK and dd/mm/yyyy It may be down to my script that calculates the Last Sunday of the month as if i put a print date on the report that comes out OK. ...Show All

• Visual Studio Express Editions Combobox and Datagridview

  HI, I apologize if this has been covered. I'm sure there is a quick solution for this. I'm want to be able to take a selection from 2 comboboxes and display this data in a DataGridView. The Comboboxes are filled with data from a Database. Also I only want the GridView window to display data from the selection not everything in the table, so it would remain blank until a selection is made. One last thing, how do I stop duplicate data from being displayed in the comboboxes. Should I setup separate tables and make the tables relational Thanks in advance. Peter Somewhat. Thanks for the help. I'm new at this so, I need to ask a couple of questions. Currently, I have the DataG ...Show All

• SQL Server "No description found" when saving a package

  Hi everyone, Primary platform is Framework 2.0 and Sql25k 64-bit When I try to save my DTSX package from my client to the production server I get this error: "No Description found" Either Windows or Sql authentication. Does anyone have ever faced this drawback Thanks in advance, Any idea Is something related to Visio 2003 http://support.microsoft.com/kb/922546 Thanks again, ...Show All

• SQL Server Invalid Descriptor Index error

  I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered ) Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly. Ah cool ! I looked at the job and thought "what runs this - I should get to the command line" Microsoft SQL Server Distributio ...Show All

• Visual C# is there any source/version controller .....?

  is there any source/version controller which can work with any language builder tool like vs 2005, jbuilder or other java language tool and php tools....... means with every language tool...... i want such source controller which can be manageable from that language tool builder as VSS is for VS i hope u got my point if no then u can ask ......... try SVN. As my knowledge, it can be integerated with the IDE like Eclipse, as well as you can directly work through file system (means you can go for any language), using tool called tortoise. ...Show All

• .NET Development Problem with path to DTD when calling CreateDocumentType in C#

  Dear Community-members. I got a problem while creating the document type of my target xml file. I' ve written a console application. If i start it this way in C:\w2d\w2d.exe /f:filename.doc, the call to create the document type for the output xml file fails. The call is: _doc = new XmlDataDocument(); ... XmlDocumentType doctype = _doc.CreateDocumentType("map", "-//OASIS//DTD DITA Map//EN", "../dtd/map.dtd", null); The code tries to find the map.dtd in C:\dtd\map.dtd, but my dtds are at a completely other place. After creating the xml files, i am going to copy them into the right place. For example: c:\myfiles\xmls, where in c:\myfiles\dtd the dtds are placed. The question is now, how to create the documenttype ...Show All

• SQL Server Problem using Monthname function

  I am trying to have the below formula populate a portion of a textbox The right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 ) is because I am dealing with " YYYYMM " and I only want the "MM" portion. =iif(right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 )=01,Monthname(12),monthname(right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 )) ) When I use this formula it will work for December, however for the rest of the months if a user chose 200603, it will read "March" when I really want it to read "February". =iif(right(Parameters!ToTimeDimensionCloseYYYYMM. label,2 )=01,Monthname(12),monthname(right(Parameters!ToTimeDimensionCloseYYYYMM. label ,2)-1))) However, w ...Show All

• Gadgets How do you change font colors?

  I want to turn the font on my gadget a color. What is the code for this if I'm using a span code for font <span ... style="color:rgb(255,0,0)"> or <span ... style="color:red"> or <span ... style="color:#ff0000"> ...Show All

• .NET Development FTP directory browsing and file download

  Hi, I am having a problem when I log in to the ftp server to download a file. FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://nndata.se/user/test.txt"); request.Method = WebRequestMethods.Ftp.DownloadFile; request.Credentials = new NetworkCredential("user", "pw"); FtpWebResponse response = (FtpWebResponse)request.GetResponse(); I want to download the test file from that specific directory above. However when I use this code in some way the ftp server adds the "user" string to the directory and starts looking for the test.txt file in this directory: nndata.se/user/user/test.txt I get a a file not found exception back. Anyone knows how to solve this, without changing the ...Show All

• Visual Studio Team System Code Analysis - No File

  I have run the code analysis tool on my website in Visual Studio. In the error list the majority of the problems have no file associated with the error so it makes it hard to fix. Why is it Hi Matt, FxCop performs its analysis on binaries and we rely on .pdb files for retrieving the file and line information. The .pdbs contain this information only for executable lines of code. Due to this, fxcop does not report the source and line # for some messages. If you find some some instances where you feel the source information should have been displayed but it is not, please do report it to us. Thanks Ravs ...Show All

• .NET Development How to specify a custom eventlog in app.config

  Hello all, I'm trying to learn about .NET configuration files. I've setup my app.config file to log to the EventLog (apparently to the application log). I'd like to know how I can tell the configuration file to create my own custom event log instead of using the application log. Here is my configuration file. < xml version="1.0" encoding="utf-8" > <configuration> <configSections> </configSections> <connectionStrings> <add name="DBConnectionString" connectionString="TESTSTRING" providerName="System.Data.SqlClient" /> </connectionStrings> <system.diagnostics> <sources> <!-- This section defines the logging configurati ...Show All

• Visual Studio XI and VS 2005

  I recently purchased XI developer. What version of the merge modules should I be using to get things working with VS 2005 - the ones that shipped with XI, Visual Studio 2005 or others I didn't install the VS CR version - just kept my XI developer version. I am having problems exporting files from the webviewer. Method 'ISCREditableRTFExportFormatOptions_reserved5' on type 'CrystalDecisions.ReportAppServer.ReportDefModel.EditableRTFExportFormatOptionsClass' from assembly 'CrystalDecisions.ReportAppServer.ReportDefModel, Version=11.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is overriding a method that has been overridden. Description: An unhandled exception occurred during the execution of the current web request. Plea ...Show All

• Visual C# How do I specify a default connection string in App.config ?

  Hi, I have more than one connectionString in my App.config. I want to use one of them as the default one always unless I specify otherwise. I find no way to do this without having to write some code. Am I right in my understanding This is my App.config entry : <configuration> <configSections> <section name="dataConfiguration" type="System.Configuration.SingleTagSectionHandler"/> </configSections> <dataConfiguration defaultDatabase="DefaultDB" /> <connectionStrings> <add name="DefaultDB" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlC ...Show All