Nayan Paregi's Q&A profile

• SQL Server accessing static methods of a .net dll, but from sql2000?

  Is this somehow possible Thats ugly, you would have to write a com wrapper to call the method via sp_OA*, if you really want to do this, write a console application and consume the output or let the console application manipulate your database (You did not write what you want to achieve) HTH, Jens K. Suessmeyer. ---- http://www.sqlserver2005.de ---- ...Show All

• SQL Server SSAS 2005 Dimension Level Security

  Hi, I have created some dimension level security in my OLAP which restricts the sales channels which are displayed, however it also keeps the overall company position. Can anyone advise me on how to remove the "All" tier from my dimension when the user is a member of this specific role, as we don't want certain people to be able to see the overall position Thanks Ian. Hi Ian, What you might be better off doing is ticking the Visual Totals box at the bottom of the advanced tab of the dimension security tab; this will ensure that the All Member only displays the aggregated values of the members on your Sales Channel attribute which you've allowed your users to see. Take a look at th ...Show All

• Windows Forms Exclude Filters Overwritten on Detected Dependencies when Re-Opening Project

  Hello - We are having trouble creating a setup program using a Visual Studio 2005 installer project: In the setup's "file system" we have in one folder the "Primary output" from another assembly. Let's call this PO.dll. We do not wish for the dll's on which PO.dll is dependent to be copied to the same folder as PO.dll. We therefore selected the project for PO and set the "copy to local" property on each reference to "false". We then opened the setup project and set the "exclude" property for each dll listed in the file system view to "true". This appears to get rid of the dependencies. We can build, AND check the project in without any changes taking place. However, when ...Show All

• SQL Server Trouble Installing SQL Express

  When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem. Is there any fix to this I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it. This is the end of the log file for my SQL Server installation: MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action 20:47:22: Che ...Show All

• Windows Forms .GetChanges Code is Detecting Changes Where There Are None

  The following code in VS2005 SP1 detects changes in my dataSet when there are none so I know something is wrong. I've used the code before without this problem. Is this occurring because the code is in the Form.Leave event USM2.usmDataSet_EstimateProcedure dsChanges = new USM2.usmDataSet_EstimateProcedure(); endCurrentEdit(); dsChanges = ((USM2.usmDataSet_EstimateProcedure)(usmDataSet_EstimateProcedure1.GetChanges())); if ((dsChanges != null)) { DialogResult dr; dr = (MessageBox.Show("Do you want to save your changes ", "Alert!", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)); if (dr == DialogResult.Yes) { saveRecord(); } ...Show All

• Windows Forms Dynamic Property Grid Enum

  Hi everybody, I’m having trouble solving an issue that I’m not even sure is feasible. I have the following scenario: A class library (LIB1) with a class called BaseItem{ int Id; } Another class library that references LIB1 with a class called: DerivedItem : BaseItem{ string Description; } And a Console App that references both. What I need to be able to do is in the console application type: DerivedItem d = new DerivedItem(); Console.WriteLine(Properties.Description); And the output be "Description". What I’m trying to do here is create a dynamic enumeration ("Properties") with all the properties in the class. So in the case of DerivedItem, this enumeration would look like the following: ...Show All

• Visual C# Strange null reference problem within enum?

  Hi All, We've been having a strange problem. Recently we have seen null pointer exception coming out from our code. The exception trace is dead simple: Message: The run has errored with description: Object reference not set to an instance of an object. Object reference not set to an instance of an object. ------------------------- User: Source: mscorlib Server stack trace: at System.Collections.Hashtable.get_Item(Object key) at WGP.Adapter.IntToPrataEnum(String prataCode, String val) at WGP.Adapter.Curve.BuildCurves(Double[] date, Int32[] instrument, String[] currencies) ... Anyway what really strange is that the code in IntToPrataEnum method is dead simple and straight forward. As far as I can see, I couldn't find a single ...Show All

• Visual C++ Using Managed code to execute DOS commands

  How would you execute a DOS commands such as xcopy ./d2/Steam ./d1 /i /e /y in .NET Visual C++. I have heard of a CreateProcess() function but have been unable to find how to use it Could you please tell me how to be able to execute DOS commands, as if in a .bat file I need it because the .NET Framework's System::IO::File:: commands don't include folder delete and folder movement, only single files. All help appreciated. ...Show All

• .NET Development Using Web.config <Credentials> instead of membership for Login

  I have managed to get my Login control and my FormsAuthentication.Authenticate to work properly using membership but for my simple application this is a big unnecessary overhead. Instead I would like to store the credentials in the web.config file (which I read should be possible) and use the Login Control and Authenticate method to use these. I just can't get it to work. Please can anyone help. My Web.Config is simple (AS BELOW) and I am simply using the standard control or the standard Authenticate method. Both these works fine when I use membership. < configuration xmlns = " http://schemas.microsoft.com/.NetConfiguration/v2.0 " > < system.web> < authentication mode = " Forms " > ...Show All

• SQL Server between not betweening inclusive

  In the sql statements below, both BETWEEN and (>= and <=) are giving unexpected results. I am working with monthly data where in one table the time part of [DateTime]=09:31:00 the result is correct but if the time is 16:00:00 (in another table) the statement returns empty. Also if I change either sql statement to use 16:01:00, it returns the second table correctly but that should not be necessary because both statements below are supposed to be inclusive. Anybody know why this is happening and what to do about it select distinct   * from [clean] . [table2] where convert ( varchar , [DateTime] , 126 ) between '2005-11-30' and '2005-12-01' and convert ( varchar , [DateT ...Show All

• SQL Server Command line/utilities to clear cache

  Hi,Does Reporting services expose any command-line or utility tools to clear reports cache explicitly other than the caching configuration at certain interval Thanks,Jet You can find information about scripting here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp You should also look at this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_3249.asp The flush cache method is here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_22i9.asp You script will look something like this (not sure this is 100% correct) Public Sub Main() Dim i ...Show All

• Visual Studio Express Editions Webbrowser control versus I.E. Explorer

  Hello, I have an application running with a webbrowser control. In some webpages I get script errors . When I navigate through these same pages, outside the application , and using I.E.7, I have not these script errors. Is there somme differences between the Webbrowser of V.B. and the I.E. 7 browser No. None at all. You can either use the DLL or the web browser control but there is no equivalent to Office Automation controls. Of course you could consider the webbrowser control just that, but it's not. ...Show All

• Visual Studio Express Editions Help with HttpWebRequest

  From the main form of my project the Timer1_Tick event(set to 2500 milli secs) calls a webrequest to get the current state of a blackjack game in the “blackjackxmlfeed”. The returned XML is then processed and displayed on the forms controls. (Display.RefreshDisplay) Usually the responses arrive back in 203 millisecs and ALL IS FINE. But other can take several seconds to return. How can I deal with that to ensure that the latest game state is displayed on the forms controls During the games “settlement stage” it is impotant that I have the current most imformation, so that the decision to make the next bet is based upon that. Is this the logical way to do it Im trying to read about asynchronous request ...Show All

• Commerce Server WebServices: "The page cannot be found "

  Hi, Strange, I had similar probles wile I  was updating the develompent maschine from CS 2002 to 2007. Now im setting up a new Staging Server with a complete new environment of Windows Server 2003 and SQL Server 2005. I did the installation exactly the same way as the update and I followed through the Online Installation Guide. After I finished everything I tried to Check the Web Services over the Internet explorer but there I get everywhere the same error: "The page cannot be found". I double checked my installation and it looks ok: - Virtual Folders are set to .Net 2.0 - Users and rights are correct - I even tried Aspnet_regiis.exe with users like administrator, CatalogWebSrvc Nothing of that helped so what else can ...Show All

• Visual Studio Express Editions Publish Prerequisite Problem

  My application says it needs the following prerequisites for publishing: .NET Framework 2.0 Windows Installer 3.1 SQL Server 2005 Express edition Microsoft.JSharp.2.0 All fine but the JSharp (Warning triangle on icon and message "prerequisite could not be found for bootstrapping") I've searched the web high and low and can't find any info on this. Any feedback would be welcome. Regards Jan Konijnenberg jankonijnenberg@blueyonder.co.uk Hi Bruno, The project is a basic administration system for a football league. Because the officers who do the admin do this on their home computers and there is no central SQL server. A database exists on every machine and these are being kept in sync using a built ...Show All