Jolly Jelly Bean's Q&A profile

• SQL Server Help with SQL

  I have a table named "policy_details" having four columns called policy_details(varchar),effectdate(datetime),Historyid(int) and policy_status(varchar). I want to keep only the maximum historyid records in "policy_details" where policy_details and effectdate should be equal and policy_status should be '30240084' . I want to delete the remaining records where policy_details and effectdate should be equal and policy_status should be '30240084'. Cheers Praveen Hello, After some research, I tested out this syntax which works: DELETE c FROM (SELECT * FROM (SELECT RANK() OVER (PARTITION BY policy_details,CONVERT(CHAR(10),effectdate,103) ORDER BY historyid DESC) as num FROM po ...Show All

• SQL Server Localization and BUILTIN groups

  Is there a synonym for the group BUILTIN\Users which can be used for GRANT ... TO and sp_grantlogin/sp_grantdbaccess, but which will work on localized computers I have a number of automated unit tests I wish to run on two different computers. The process involves recreating a database if it does not exist and then granting access and privileges to the BUILTIN\Users group. The problem is that one computer is installed with a Swedish Windows XP Professional (the users group is called BUILTIN\Anvandare) and the other is an English WinXP MCE (the group is called BUILTIN\Users) so I cannot easily script this. An alternative is to be able to retrieve the respective name through a .NET class or the Windows API. Is any of this possible ...Show All

• Windows Forms Execute custom action without installing the assembly.

  Hello all... I'm using Visual Studio 2005 to create an MSI for a legacy VB6 app. The MSI mostly just registers a bunch of COM DLLs. However, the MSI also needs to install a new code group to the machine. I have written a .NET DLL that will install the code group without a problem. I added this DLL to the Setup Project and used it as a 'Custom Action'. Everything works fine. The only problem is that the DLL is installed to the machine. I don't want this to happen because the DLL's only purpose is to create the code group. It does nothing else. I tried setting the 'Exclude' property to True for the DLL, but that doesn't work, either. I even tried setting the 'ExcludeFilter' property to '*.dll' for the assembly. Nothing works. It seems tha ...Show All

• Visual Studio Tools for Office Migrating ISmartDocuments to VSTO 2005

  We have several documents built with an expansion pack implementing ISmartDocuments (via the Vertigo Wrapper). Now we are working on a VSTO 2005 solution with exactly the same XML-Schema. For future documents we made the solution with a word template. How can we use the solution with the old documents After long searches I found _AssemblyName and _AssemblyLocation in custom document properties. Now the VSTO 2005 solution works with the older documents partly, but unfortunately the XML-Nodes are not available as objects. If I use for example an eventhandler for ThisDocument.MyNode.ContextLeave, the old documents will not start with the solution, stating the object MyNode doesn't exists (but the are a lot of MyNode-elements in the d ...Show All

• SQL Server Last GASP on "Insert row in table with Identity field, and get new Identity back " ?

  While I have learned a lot from this thread I am still basically confused about the issues involved. .I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple. To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package. 1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful. 2. ...Show All

• Windows Forms PUBLISH MY PROGRAM

  I have a probleM when i install the program, it doesn't detect my database... it shows me an error saying that the database is not in the directory,.. but i saw the publish settings and i included it in the package... do i have to manually put the database in a folder which one is there a way i install my program and automatically it installs the database too ...Show All

• .NET Development Passing credentials

  Hi! I'm making a webservice that should be called by a webservice client at a customer's location. I use Windows Basic Authentication and SSL to authenticate the client. If the client was written in C# the way credentials are passed is by using NetWorkCredentials on the proxy client, correct But I just wonder what actually happens. How will the credentials be sent to the server In the soapheader to the webservice Or in the https header Can somebody explain this to me, I need to know because the customer do not know how to pass the credentials to our webservice. THey do not use C# or Java. They have their own strange script language which I do not know...so I have to explain what really happens.... Please, any explanations would be appre ...Show All

• Software Development for Windows Vista A problem with Installing VS 2005 Extension for WWF

  I have a problem when trying to install the latest version of visual studio 2005 Extension for windows workflow foundation. I've installed: .Net Famework 2.0 from the following link: http://www.microsoft.com/downloads/details.aspx FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en .Net Framework 3.0 http://www.microsoft.com/downloads/details.aspx FamilyId=10CC340B-F857-4A14-83F5-25634C3BF043&displaylang=en VS extension http://www.microsoft.com/downloads/details.aspx FamilyId=5D61409E-1FA3-48CF-8023-E8F38E709BA6&displaylang=en When I try to open any sequential workflow in visual studio 2005 I couldn't open the design view and the following err ...Show All

• .NET Development Debugging Web Service with database connection saved in Application session state variable

  I'm debugging a web service app that has a database connection stored in an application session state variable. When I finish a debugging session and then start a new one the database connection object still exists in the application variable from the previous debug session. Is there a way I can clean up objects stored in application variables before I start a new debugging session Thanks Mike, First of all, why do you need the connection object to be in a application session variable Then, your assumption may be right.... after using the connection object you can't forget closing it.... remember to use a try, catch, finally block (don't forget the "finally") in order to make sure ...Show All

• .NET Development Calling C# webservice from Visual C++ 6 using SOAP

  Iam trying to call a C# DotNet 2003 webservice from Visual C++ 6 app (used win32 console, mfc, atl_mfc dll) using Soap toolkit 3. The webservice takes a String input parameter and returns a String. The input parameter I pass through C++ is always recieved as NULL in C# webservice while the output is working fine and it is returned back in C++. I have even tried with wsp wizard using atl_mfc dll and vb GUI but input always failed. It didn't give any error either. It will give an error when I output, input parameter as it is without appending to a string, then it will say Invalid pointer error in C++ app. Plz anybody can help in this regard. A bundle of thanks. My C# webservice code is as, it is a simple ASP.NET web service generated thro ...Show All

• Visual Studio Express Editions Why were MFC, ATL and masm not included in VC++ Express?

  First off, while I do have a degree in Geology, my minor in college was Computer Science.   Even though I do not have a job that needs much in then way of computer skills, since college I have been trying to keep up my computer skills.   When I found out that Microsoft was offering VC++ 2005 Express Edition as a free download, I was excited because I thought that I would be able to compile programs that I would find of use to myself.   At any rate, I am a little disappointed with VC++ Express Edition because of its limitations.   My question is what was the reasoning behind not including MFC, ATL and masm in VC++ 2005 Express Edition   I understand that the amount of programming that can be done in VC++ Expr ...Show All

• SQL Server Writing accented characters to Oracle from Query Analyser

  I am trying to insert a record into a table on a linked Oracle server from Query Analyser. Everything works fine until I add an accented character. For example: INSERT INTO CONDOR_SKYE..CONDOR.BW_LANGUAGE_TRANSLATION VALUES ('QRYELT','YCH_L_1038_ZEUSG_M00','EN','20070208',null,'Verkaufsstellenumsatze') works fine. However if I add an accented character: INSERT INTO CONDOR_SKYE..CONDOR.BW_LANGUAGE_TRANSLATION VALUES('QRYELT','YCH_L_1038_ZEUSG_M00','EN','20070208',null,'Verkaufsstellenumsatze') then the insert fails with the following message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. [OLE/DB provider returned message: ORA-01401: inserted value too large for column] OLE DB ...Show All

• SQL Server An attempt to attach an auto-named database for file C:\... failed

  Hi, I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough: http://msdn2.microsoft.com/en-US/library/tw738475.aspx Because I get an error like this (link for complete error below): An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception ...Show All

• Visual C++ not add an .obj file to my project

  Ih, i got this error " LINK : fatal error LNK1104: cannot open file "odbccp32.obj" compiling a code. As you can see in google, there is no solution aparently. In the same way that i delete lib files, how can i not add this file to my project There is no "odbccp32.obj" file. There is only "odbccp32.lib" file and that's you need to add to your project. Right click the project node in solution explorer, go to Linker/Input and in the Additional Dependencies fields add "odbccp32.lib". ...Show All

• Visual C# static methods in a nested class

  If I have a static method, I can access that method without instancing the class, as in int answer = ClassName.StaticMethod(a, b); However, if the class is nested, it seems I must use an instance of the outer class to access the static method as in OuterClass marker = new OuterClass(); int answer = marker.InnerClass.StaticMethod(a, b) The outer class in the case I'm thinking of is not much more than a placeholder, intuitively what I want to write is int answer = OuterClass.InnerClass.StaticMethod(a, b); Is this possible Thanks PhilD thanks murali, I dont have the code in front of me and it may take a couple of days before I'm able to to check it out The outer class is also partial, but t ...Show All