Krutika's Q&A profile

• SQL Server Calculated/derived measures

  Hello again. I'm wondering if it's possible to add some form of calculated field to my fact table. Scenario... I have a fact table that records customer account balances a the end of each day. As this is a bank we're talking about, some of the balances are in credit & some overdrawn. Since the AccountBalance field aggregates by default to sum, if for example I wish to view balances by product I get the NET balances (i.e. all debit & credit balances summed). This is OK, however obviously my people will want to be able to split these in to Credit Balances Product a 100 b 100 c 100 Debit Balances Product a -50 b -50 c -50  as opposed to the current situation where I get Balances Pro ...Show All

• SQL Server Connection String Encryption for SQL Server Mobile

  I'm seeking suggestions on how to go about encrypting a database connection string in the compact framework. It's something that I thought would be relatively straight forward as I've accomplished it without much difficulty in the full framework, but I'm stuggling to find a solution. I've been trying to implement a solution using public/private key asymmetric encryption using the RSA provider. I've essentially been trying to encrypt the connection string once on my development machine so that I can include both the encrypted connection string value and public key in either code or an external file. I'd then keep the private key out of harms reach. The problem I've encountered in doing this is that that RSA provider seemingly only allows ...Show All

• SQL Server The process could not connect to Distributor.

  hi friends i am creating the Merge Replication between two server(both SQLServer-2005, on XP). Server names are as 1. HB5B 2. VSNET1 i)    On server HB5B, i had created the Publication with name 'hb_pub'. (publisher & Distributer on HB5B server) ii)   On server VSNET1, i had created the Pull Subscription, for the publication name hb_pub( form the server HB5B), this starts fine. iii)   When i went to Viwe Synchroniztion status, it says       The process could not connect to Distributor 'HB5B'   iv)  i too check the Distributor properties, its seems fine for me. v)  On server VSNET1, if creats the Push Subscription, for the ...Show All

• Visual Studio Property Group being redefined in Target

  Hi. We are using MSBUILD for our build where the version control tool is Surround. I see a MSBUILD target file, where in a Property group is defined <X> with details to configure surround like the login, server, branch details etc. However I see the surround configuration being redefined in a separate Target where each of the properties defined in the earlier Property groups are reused and the output is another property name <X>. Can anyone please help me to understand why is this for. Why cant the earlier Property group be used for this purpose. Why is it needed to be redefined in a separate Target Any help would really be appreciated. Thanks Kumar I am assuming that the ConfigureS targe ...Show All

• Visual Basic SendARP arithmetic overflow operation

  Hi, I'm receving the error "Arithmetic overflow operation" in some computers. They have Ip set by DHCP. This error only happens in 2 or 3 computers (over 100). Dim IpAdd As IPAddress IpAdd = IPAddress.Parse(GetIPAddress) Dim ab(6) As Byte Dim len As Integer = ab.Length ''This Function Used to Get The Physical Address Dim ArpResult As Integer Error when SendArp is called ArpResult = SendARP(CType(IpAdd.Address, Integer), 0, ab, len) mac = BitConverter.ToString(ab, 0, 6)     Check if you get the failure on workstations whose IP address ends with .128 or greater. If that's the case, redeclare SendARP to take a UInt32 rather than an Integer. ...Show All

• SQL Server JavaScript Error in report

  When ever report is blank it gives me javascript error. In IE on bottom left it shows js error icon. Details of error are: Line: 20 Char: 634 error: Object Required Code: 0 URL: http://<servername>/Reports/Reserved.ReportViewerWebControl.axd ReportSession=vzlkcz453qxkilexp4sgutqp&ControlID=ac36d700-2cdd-4325-ade1-95fda484e6db&Culture=1022&UICulture=9&ReportStack=1&OpType=ReportArea&Controller=ClientControllerctl161&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&EnableFindNext=False&LinkTarget=_top If there is any data in report then it does not give any error. For possible solutions I have checked that in IIS mapping for axd extension is already given and checkbox f ...Show All

• Visual Basic WScript is missing/broken

  Hi I have an app I built a while ago under Win2000, but have since "upgraded" to XP.... It appears to compile just fine, but when I run it on another machine, I find this in my log: Public member 'exec' on type 'IWshShell2' not found. Meanwhile, back in my IDE (either VS 2003 or 2005, same thing), the only thing that shows up in the autocompletion for oShell, after creating it like this... is "GetType" oShell = CreateObject("WScript.Shell") obj = oShell.exec(strExec) Note that the .exec remains lower case. It's like I'm missing a reference to whatever the WScript.Shell is in. Any ideas At this point I'm seriously considering chucking this entirely and starting over with java. Thanks ...Show All

• Windows Forms How do I get my Setup1.msi file to autorun when installing from CD?

  How do I get my Setup1.msi file to autorun when installing from CD Try looking at the docs for the autorun.inf file. You can start here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/Shell/programmersguide/shell_basics/shell_basics_extending/autorun/autoplay_cmds.asp ...Show All

• Visual C++ Arrow Position on a ComboBox

  Hi, If the arrow located on the right side of a combobox is desired to move to the left, the only setting I found was to set the RightToLeft property to true. The problem is that this is meant for localization and the languages which start from the right side, not proper for English. What is the best way to move the arrow to the left of the ComboBox . A work around perhaps, to set the properly to true for the combobox, and then to set it false by getting a handle to the listbox part of the control during the runtime Any idea Best Regards, Reza Bemanian This should be done by the use of the HwndHandle for the list box embedded within the control. Though the RightToLeft is a public property, still ...Show All

• Visual Basic Using a declared function in a dir' address.

  Hi Guys, Ill be upfront, i am extremely new to VB and am still learning the ropes, so apologies if i do not make much sense lol! Ok, what i am trying to do is place the current user logged on to the computer into a directory. Eg, ------------------------- ChDir "C:\Documents and Settings\ USERNAMELOGGED IN \Desktop" Workbooks.OpenText Filename:= _ "C:\Documents and Settings\ USERNAMELOGGED IN \Desktop\IMEI.xls", Origin:= _ xlMacintosh, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _ Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(1, 1) ----------------------------- I am wanting to repla ...Show All

• SQL Server Unable to connect to the remote server

  Greetings: We have a copy of SQL2k Report Services running on a Windows 2003 Server. But the database used by the Reports is actually on another box in our network. (This is a option you can use during install.) This setup worked fine for about a year but now neither the reports and ReportManager no longer run. The Reporting services Log error is: System.Net.WebException: The underlying connection was closed: Unable to connect to the remote server. In a browser we get the error: --- " Directory Listing Denied " "This Virtual Directory does not allow contents to be listed." --- Turning on the option to list directory contents in IIS does not resolve the issue. Anyone seen this creep up before I ...Show All

• SQL Server How to do backup in Cluster

  Hi, I have a cluster set up and working fine. I am in a stage where I need to do the backups. I have added 4 disks as dependecies to the sql service for the instance. The backups should not be on these disks. When I do a simple backup I can see only these 4 disks so my question is how do I do the backup to fileshare or other disks that are not partof the cluster. I have 3 virtual servers so what wil be the best thing to do for backup Thanks Thanks It was a firewall issue and could not backup to a fileshare. Like you have mentioned what is the best practices in backing up DB in cluster 1. fileshare 2. add a disk resouce(which I assume will fail evertime SQL will failover) to the SQL group in cluster and a ...Show All

• SQL Server Sorting Data having months

  Dear all, I have a field [Month] in my table AA.having Data like ( January,February,March,April etc.) I need to sort them by starting of month lets say as January February March How i can i do this Have no index and can't define a index on this field Thanks for ur time and Help Regards Mohd Sufian Dear William, Yes ur asnwer will sort the problem but this will make a headache for me for performance. As i have more then 300 users who will use that graph per sec basis. and have more then (500000++) records. Do u still suggest me to implement the query u have posted here. Regards Mohd sufian ...Show All

• Visual Studio Unable to uninstall visual studio 2005

  Hi Everyone I am uninstalling Visul Studio 2005 but its showing me the error when it start unstalling it . " Unable to find the order of installation." Please tell me why this error is coming and how can i uninstall it. I have also tried to maintain it with the disk. but still its showing the same error. Thanks HumaMunir You could try to follow these steps: How to: Uninstall Visual Studio ...Show All

• .NET Development ExecuteScalar() and Primary Key

  I have a sql command that inserts into a Datbase....and i pass it the parameters in my table...It breaks though...When i do a call stack i see the new values being loaded into the memory through the parameters...but i also do a stacktrace and i see it breaks when i try to retrieve the _CustomerID that is also the primary key..... which is line 990.....take a look at the command could it be structerd different...... private void Insert() { string sql = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; using (SqlConnection connect = new SqlConnection(sql)) { using (SqlCommand command = new SqlCommand("Customer_Insert", connect)) { command.Parameters.Add("@CustomerC ...Show All