CL0CKW0RK's Q&A profile

• SQL Server How can only certain objects (dimensions, cubes) be deployed?

  How can only certain objects (dimensions, cubes) be deployed From Visual Studio I would like to deploy individual items like a dimension or cube without all of the changes in the other objects being deployed. I don’t see any way to do that. Every time one thing gets deployed, all changes get deployed. Visual Studio sends a Message Box Stating that the whole SSAS Database will be overwritten on the server and asks if you want to deploy or not. We have multiple developers working and it has become a problem. We can’t deploy just those changes that are ready without overwriting the whole database. I feel your pain...I have the same issues here (even though I'm the only develo ...Show All

• SQL Server UPDATE Method

  I have a column of values in one table that needs to be updated based on an adjustment factor in another table. The table which contains the adjustment factors is built with the following column names. RangeBeg RangeEnd Factor The factor is determined depending on where the value falls in the range. I have been trying to do an sql script with no luck. Any Help would be appreciated. Thanks Hi, this could be something like (just guessing because we really need the DDL and some sample data to see how your actual design is working): UPDATE SomeTable SET SomeValue = ( SELECT SomeUpdateValue FROM AnotherTable AT WHERE ST.SomeRangeValue BETWEEN AT.RangeStarting AND AR.RangeEnding ) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. My First Project

  Anyone having fun with XNA I have my tetris clone coming along quite nicely.. http://str8dog.shackspace.com/NotmyTetris.png Right now its based on fixed time steps, I am struggling to wrap my head around how to let the game run real time and get the blocks to not fly down the screen. The spacewar example is awesome for picking up how to do various bits like sound, texture management and user input. Hell some of the classes I just swiped outright they were so easy to use. What have you folks been able to do so far Ill do one better and give you the source: http://str8dog.shackspace.com/MyTetris.zip I take no credit for the game logic. This is pretty much a direct port of .NETTrix found in the book Begi ...Show All

• Visual Basic how to search a value ina time interval ?

  i am try to develop an an application that uses start and end time values and i am trying to write a code that could search a specifique value between the start and the end time so i would like to know how to do that thnx guys for trying to help me but i was able to find the propper function  for what i wanted to do  which is to search  a  the range (startdate 2  to  enddate 2) in the range (startdate1 to enddate 1)  and checking if there is any overlaaping    like startdate 1 falling in the range or startdate 2 falling in the range pr both of them falling in the range ) hence the only option the function would retrurn a false va ...Show All

• .NET Development Help with TripleDES and RC2 cryptography.

  I have 2 questions - 1) I get the following Exception when I try to decrypt data using TripleDES. - "An unhandled exception of type 'System.Security.Cryptography.CryptographicException' occurred in mscorlib.dll Additional information: Specified initialization vector (IV) does not match the block size for this algorithm." How do I make things right The code is as follows - /* Provides TripleDES encryption and decryption using classes in the .net Framework 1.1 */ public class TripleDES_Cryptography { public static string Encrypt(string plaintext, string key, string IV) { TripleDES des3 = new TripleDESCryptoServiceProvider(); des3.Mode = CipherMode.CBC; byte[] by_plaintext = Encoding.ASCII.Ge ...Show All

• Windows Forms Refresh Issue with Master Detail

  Hello, I'm doing Master/Detail objects. My problem is that when I do an Update or an Insert from the Detail View the GridView does not re-Select the data from the SQL table. How can I re-Fill the data for the GridView (VB if possible). With the following SQL table. ID INT, ThreadKey INT, ThreadText VARHCAR(8000) My GridView's ds has a SQL select parameter ThreadKey which is provided from the previous page and the Detail View's ds has a SQL select parameter off of the GridView's ID as ObjectKey. Thank you. D. B. ...Show All

• Visual C++ Problem using log4net in my C++ program

  I have a C++ program converted from an ANSI C. Now it is created as a CLR console application. As an Art graduate, I am lost and do not know how to add the log4net statement into my Cpp program. Please help. I promise to grade your answer! Thanks This is the error message during compilation: Error 193 error C3699: '*' : cannot use this indirection on type 'log4net::ILog' e:\myApp.cpp 35 #include "stdafx.h" #include <stdio.h> #include <string.h> #include <time.h> #include <fcntl.h> #include <string> #include <iostream> #include <cstdio> #ifdef WIN32 #include <winsock.h> #include <io.h> #else #def ...Show All

• Visual Studio 2008 (Pre-release) Meta publishing disabled...how do you fix this?

  I just read the following thread... https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=809869&SiteID=1 I'm having the same exact problem and I added the line of code, as suggested, and I'm still getting the error. Here's my config. What could be the problem < services > < service name = " DerivativesCalculatorService.Calculator " behaviorConfiguration = " MyServiceTypeBehaviors " > < endpoint address = " CalculatorService " binding = " basicHttpBinding " contract = " DerivativesCalculatorService.IDerivativesCalculator " /> < endpoint contract = " IMetadataExchange " binding = " mexHttpBinding " a ...Show All

• SQL Server Unable to run a report after deployed in a remote server

  Hi All, I encountered the following error after I deployed a report to a remote server. The deployment process was successful, however, when I try to run the reports from the remote report server, It gives me an error message saying: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors On the other hand, I deployed this report on the local machine and it is running perfect. Do you have any idea how to deal with this problem Thanks! In Report ...Show All

• SQL Server SQL Server 2005 Management Studio Keyboard throws DISP_E_EXCEPTION

  An Exception encountered in SQL Server 2005 Management Studio.Non-Aphabetic keys like Control, Enter, Backspace & Function keys are NOT working only within SQL Server 2005 Management Studio Query Window. When i tried to change the keyboard options (Tools menu ->Options - Environment->Keyboard), An DISP_E_EXCEPTIONis being encounterd Pls help me to resolve this regards Dhandapani Exception error means mismatch of .DLLs with the tools that are installed. You might try the same from antoher client's machine to see it is persistent, may be a problem with the downloaded file used before. ...Show All

• Visual C# DLL Returns object {string[]}

  Greetings, Calling a DLL method that returns an array of strings, but I can't cast to string[]; object o = myMethod(); string[] s = (string[])o;    //generates "Unable to cast object of type 'System.String[\*]' to type 'System.String[]'. (I had to put the \* in, without the \, it treats it as a different [\*] as a different char) The Autos window shows the data properly; [1] "String1" [2] "String2" Hi, It might be problem with the dll function myMethod() return value, it seems. Can u please send me the dll and .h file to 'gopi_ch@googley.com' , so that i can test, if the problem is not solved still. Thanx, Ch.T.Gopi Kumar. ...Show All

• SQL Server Trigger isn't showing in folder!

  Hi, I selected create trigger from the tables pop up menu. I created a trigger for the dbo.sysjobhistory table in the msdb database. When I click the parse icon it comes back with success. When I check the trigger folder under the sysjobhistory table the the trigger is not there. What am I doing wrong FYI, here is the trigger code: CREATE TRIGGER dbo . email_on_job_fail_INSERT ON dbo . sysjobhistory FOR INSERT AS IF EXISTS ( SELECT run_status FROM inserted WHERE run_status = 0 ) BEGIN DECLARE @cmd VARCHAR ( 1200 ) SET @cmd = ( SELECT step_id , step_name , sql_message_id , run_date , run_time , server , message FROM inserted WHERE run_status = 0 ) EXEC master . dbo . xp_ ...Show All

• SQL Server Server: Msg 107 - The column prefix xx does not match with a table name or alias name used in the query

  Can anyone help me with why SQL server returns this error when executing the following query. I have read the online help on this and I am correctly using the alias in the subquery. The error is caused by the reference to the table alias FD in the subquery for fundvalues which gives me reason to believe that the subquery is being parsed or evaluated before the outer query. I don't know how to avoid this behaviour and I do not want to have to rewrite the process completely. The error is returned both when executed through the query analyzer and also when executed through the vb program. ( Note : This is a subsection of a much larger sql statement which is a large number of unions but which basically repeats a similar query so did ...Show All

• .NET Development Could not get information for 'Students.DataSet1'

  Hello again, I am trying to add a new data source on my project which is a simple form that will search a database of students through theyr IDS number and return their name. Visual studio 2005 can "see" the database and table that I need but when I add a new data source, since there is no current data source for my project, I get the following error. An error occured while creating the new data source: Could not get information for 'Students.DataSet1' What could be the problem Thanks in advance, Yiannis. Hi, Check it up, this may help http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=117164&SiteID=1 ...Show All

• SQL Server SQLGetDiagField() crashing with access violation

  After an error trying to connect to a database, I am trying to query the number of status records using SQLGetDiagField() and am getting an access violation I am trying to open a connection to data in an Excel file using the Excel ODBC driver. Any hints ...Show All