KayJHut's Q&A profile

• SQL Server Time Calculations and Calculated Measures

  Hey Guys, I have used the following document to create some time intelligence in the cube as the standard way that is in SSAS didnt fit to what we wanted. http://www.obs3.com/A Different Approach to Time Calculations in SSAS.pdf I have implemented the suggested solution and it works well, although i cannot add in a calculated measure in the scope statement. Everytime i do, i get the following errors: Error 1 A set has been encountered that cannot contain calculated members. 0 0 Error 2 MdxScript(Sales By Market) (51, 1) A set has been encountered that cannot contain calculated members. 0 0 Error 3 The END SCOPE statement does not match the opening SCOPE statement. 0 0 Error 4 MdxScript(Sales By Market) (118, 1) The ...Show All

• .NET Development WSDL contains local server name URL in soap:address location attribute

  I have a Web service which is being accessed by a third party who uses a Java tool to construct SOAP interfaces from the WSDL published automatically by ASP.Net about my service. The location attribute contains the local name of the server, rather than the external domain, eg.: - < wsdl:service name =" MyService " > - < wsdl:port name =" MyService Soap " binding =" tns: MyService Soap " > < soap:address location =" http://localservername/ MyService .asmx " /> </ wsdl:port > - < wsdl:port name =" MyService Soap12 " binding =" tns: MyService Soap12 " > < soap12:address location ...Show All

• .NET Development how to call a javascript function from content page which was declared in master page?

  this is my master page <% @ Master Language ="VB" CodeFile ="MasterPage.master.vb" Inherits ="MasterPage" %> < html xmlns ="http://www.w3.org/1999/xhtml" > < head runat ="server"> < title > calendar </ title > < meta name ="GENERATOR" content ="Microsoft Visual Studio .NET 7.1"> < meta name ="CODE_LANGUAGE" content ="Visual Basic .NET 7.1"> < meta name ="vs_defaultClientScript" content ="JavaScript"> < meta name ="vs_targetSchema" content ="http://schemas.microsoft.com/intellisense/ie5"> < ...Show All

• Microsoft ISV Community Center Forums How do Programmatically insert an ole object into an access database

  I am working on a VBA program in MS outlook in which I am using ADO to update ms access database. It works fine for my text fields, but I am not sure how to update an Embedded Object field. Anyone know how I can do this For example I have a database called C:/Test.mdb with table "My_Table" containing a field called "Email_Message" with data type OLE Object: Function LogEmails() Dim msg As MailItem Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String Dim FilePath As String Set msg = ActiveExplorer.Selection.Item(1) FilePath = "C:\Test.mdb" Set cn = New ADODB.Connection With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString ...Show All

• SQL Server Simple question

  For some reason I cannot think of how to do this. But what I have is one data adapter that is pulling in hundreds to thousands of records based on some criteria. Each record in this dataset has a unique ID. What I need to do is iterate through each of these rows in the dataset's table and see if this unique ID exists in another SQL database table that contains hundreds of thousands of records. I do not want to pull in this other table do I Is there a Find or Search function Or do I want to pull in and cache the secondary table Or should I just do a SELECT statement and if no rows are returned then I know that the primary key would not be found Thanks for the information They are two different tabl ...Show All

• SQL Server jdbc driver

  what is the jdbc driver for sql express is it "sqljdbc" then what is its "complete" name in the class path:"com.microsoft.sqlexpress.sqljdbc" and for the conection url is it "jdbc:microsoft:sqlexpress://localhost/sqlexpress" Everything you need is here http://msdn.microsoft.com/data/learning/jdbc/ How do I use the JDBC driver The JDBC driver is not part of the Java SDK, so you must set the classpath to include the sqljdbc.jar file if you want to use it. If the classpath is missing an entry for sqljdbc.jar, your application will throw the common "Class not found" exception. The sqljdbc.jar file is installed in the following location: <ins ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA GSE and Vista

  So here's a quick question. I'm pretty sure it's been asked before but none of the combinations I can think of give a definitive answer for me. I'll make this one quick and to the point. Are there any known compat issues with GSE and Vista RTM (currently using Vista Business). Let me know I have gotten XNA to work with Vista RTM. That being said I am experiencing some performance issues. My code is "jerkey" ( at least in debug mode ). While I am staunch advocate of Microsoft tools and technologies the axiom "be weary of 1.0 versions of Microsoft Products" definetly holds true for me. Despite the cleanliness of the XNA Framework I am considering switching back to DirectX ( December 2006 ) for performance reas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I protect my code when distributing it?

  Having read the FAQ. I noticed that in order to share your game creations (and lets face it, you can't get recognised without sharing your games), you need to send the other person the entire uncompiled game. This includes sourcecode, graphics, music, sound etc. etc. They then compile the code and download it to their xbox360 account and then only if they too are on the games creation program. My key worry here is that you send them everything you have just worked incredibly hard to create. Presumably they can then send this stuff on to whoever they please and god forbid, even sell it on! It strikes me that there isn't much incentive to distribute things this way. How is Microsoft going to prevent the above scenario Is there going to be a ...Show All

• SQL Server Spurious Errors With Package Execution on Local Machine

  I am having strange errors with a package when running locally that has not been an issue before. The main symtom is that several Data Flow Tasks are either not inserting records on the destination or are only inserting 1 single record before the package errors with the error shown below. Strangely, the debugger will show X # of records from source and destination, but either no records are actually written or, again, in many cases, only 1 single record is written. This is very strange. App, System and Security logs yield no indication of security or other errors. All I have to go on is the above anomolies and the error message provided below. Below is the error message, can someone help me decrypt it Many thanks, Rick ...Show All

• Visual Basic Open form by caption

  I am wanting to create a "My Favorites" Form to store the top 10 forms/reports the users uses the most. I have got 10 fields in each users record that stores the name of the form I made a form with the following;10 command buttons, labels The labels are bound to the users record which shows what the name of the form/report is. How do I take the labels caption and open the form Davids Learning There are a lot of details but as long as all your forms are in one assembly, this might be helpful: Imports System.Reflection Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim frmname As String = "Form1& ...Show All

• SQL Server Custom Code Function for Unix Timestamp conversion

  I have a database that stores date and time in the Unix time format (seconds since 01/01/1970). I need to develop many reports where a DateTime parameter is converted to the Unix timestamp and then when the results are returned from the query, the Unix timestamp will need to be converted back to human readable format (Date Time). I am wondering - is using custom code a good way to handle this I realize that creating a custom assembly might be the best practice but I do not know how to develop an assembly. Also, I need help with how this function is called and placed into the query. I do not have sample code to post, everything I have done has failed in one way or another. It is driving me nuts. Or am I just missing the boat ...Show All

• Visual Studio Express Editions Help with query - im really stuck.

  I have two databases: 1 = Suppliers, 2 = Supplier Locations (I need them to be seperate because the supplierID is a primary key, but some suppliers have more than one location) I have created a form on which I have put the Supplier details on in Details view and under it I have put the Supplier locations in Gridview. How can i do a query so that when a user clicks on a supplier Id number in the listbox in the Supplier Details area, that suppliers locations will appear in the Locations grid below Thanks for any help, Diane When you use a combobox and the IDE's built databindings, you can apply an value member to the combobox. My code assumes that you placed the Primary Key value (typically called ...Show All

• Visual C# Help Converting Encryption Code From Java/JSP to C#/.NET

  Trying to figure this out and it has been killing my brain for quite a bit. Trying to convert this JSP/Java code into C#/.ASP.NET for entering information from a user login page to match it against the database of hashed passwords. java.security.*; public class Encrypt{ String passwd; public String getPass() {return pswd;} public void setPassword(String pswd) { MessageDigest sas = MessageDigest.getInstance("MD5"); byte[] tmp = pswd.getBytes(); sas.update(tmp); passwd = new String(sas.digest()); } } //separate java function which logs into DB for password retrieval which I minused out... public class Login{ public String EncyptPswd(String strPass){ if (strPassword == null) {return null ...Show All

• Visual Studio 2008 (Pre-release) Passing application context information to servies

  Hi, I am got the following situation and would love to hear peoples feedback on whether i am doing this in the correct way for WCF. Currently our application has its own context class similar to HttpContext and is accessed using the Current property. This class contains a number of properties such as ClientName, ApplicationName, Status etc etc. We would like to be able to pass this information over the wire to our remote services hosted in WCF, but we dont want to have to explicitly the information on every method call. My current thinking to have a class that implements the IClientMessageInspector and IDispatchMessageInspector interfaces. In the IClientMessageInspector .B eforeSendRequest i take the current context and then creat ...Show All

• Visual Studio Team System Solution File, file format changed

  It looks like the solution file format has changed from VS 2005 to VS 2005 Team Edition. This is despite that the format version is 9.00 in both versions. This is a rather big problem in our company because we're several developers working on the same solution. The solution file is under source control and changes ought to be merged between branches. This is, however, not feasible with this format change and a solution with 45 projects. Of course the best solution would be to use the same VS version. But what can we do until all have upgraded I contacted someone on our Web Project team and discovered that this is a known issue and should be resolved in the Orcas release of Visual Studio. My contact ...Show All