LokiSD's Q&A profile

• SQL Server sql server 2005 sp1 installation problem

  When i run sql server 2005 sp1 setup, during setup it authenticates everything except Database engine and reporting services. I m running this setup with administrative previliges.....can any one help regards, Mahmood Did you solve the problem HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360: Detect widescreen vs 4:3?

  Right now it looks like our games pretty much dictate their size and whether they're windows or full-screen. But, obviously, once we get to the 360 the choice of windows vs full-screen will be gone. And I get the impression that if we code for 720p that the 360 will automatically downscale if needed. But I still don't know how we're going to detect whether the output is headed for widescreen or 4:3. If we make the choice to program for widescreen only will the 360 letterbox for us, or will it just get squished or truncated What I've inferred from Microsoft posters is that the 360 will scale up or down whatever your native rendering resolution is(while maintaining the aspect ratio), to the appropriate resol ...Show All

• Windows Forms Button Images

  I am trying to make a form that has buttons with images on them, but I dont want the silver button with an image on top, I just want the image. How can I do this Thanks, Tyrael see follow code can redraw the button from a image using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace CS { class mybutton : System.Windows.Forms. Button { protected override void OnPaint(System.Windows.Forms. PaintEventArgs pevent) { Graphics g= pevent.Graphics; Image img = Image .FromFile( "C:\\logo.gif" ...Show All

• Windows Forms some questions about Setup and Deployment Project

  I make a installation by the C# Setup and Deployment project.(I choose the Setup project.) There is a window service application in the installation package. 1. Is it possible to start the service by the installation I have tried, but failed to do that. You know, some service application need to restart computer to start the service. Is there a easy way to start the service during the setup. 2. When user reinstall,(that means user has installed, but user runs the installation package again.) the install package will ask user to repair or remove the installation. Then the user select repair, you can imagin, the system will pop up an error message because it cannot install the service application.(The reason is, the service has been i ...Show All

• Visual C# IList<> or ICollection<> which one is more efficent????

  In my code I use ICollection<> for some reason I decided on ICollection<> after doing some research but I forgot why I am using ICollection<> ;-) Looking at different samples I have come across on the web it seems that most people use IList<> which is better or does it matter Portion of my code using ICollection public static Collection < AvatarImageInfo > GetAvatarImages() { string key = AVATARIMAGE_KEY + "GetAll" ; Collection < AvatarImageInfo > avatarImages = new Collection < AvatarImageInfo >(); if (avatarImageCache.Contains(key)) { //Get an AvatarImageInfo collection from the cache. avatarImages = ( Collection < Avatar ...Show All

• SQL Server pull subscription

  Hello, i have one publisher with one pull subscription. when i make any change in publisher, that change is propegated to subscriber, but when i make any change in subscription, the change is not reflected. i have tried a lot of options but no one worked. please help me. Regards, Dear Greg, i have tried a lot of combinitions and what you noted is one of them. with no one of combinitions i could not succeed. The thing which i need to have a system with syncronized data and the only thing that came in my mind was this model to make data syncronized between nodes. ...Show All

• Visual Basic TROUBLE Inserting dat into access database

  I am having some trouble inserting a date into a access database, I have tried sever different ways but always get something like - cannot change date to an integer. Dim theOleDbCommand As New OleDb.OleDbCommand( "INSERT INTO DATASHEET ([TODATE], ACCESSUSER,DEPTID,TOWN) VALUES ( , , , )" ) theOleDbCommand.Connection = New OleDb.OleDbConnection(connectionString) Dim p0 As New OleDbParameter( "@p0" , Me .TODAYSDATE.ToString) p0.Value = Me .TODAYSDATE.ToString theOleDbCommand.Parameters.Add(p0) Dim p1 As New OleDbParameter( "@p1" , Me .theUserNameOnly) p1.Value = Me .theUserNameOnly theOleDbCommand.Parameters.Add(p1) Dim p2 As New OleDbParameter( " ...Show All

• SQL Server Can't Create cube

  Is there is a way to create cube against database which tables get new records every few seconds I get these errors Thanks in advance Warning -2128674815 : Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Log, Column: InsertDate, Value: 2/23/2007 9:22:32 AM. Thanks in advance You'll need to update the time dimension and your data incrementally and "lock" the database updates while the update is being performed (to maintain consistency). This'll take some careful consideration of your partitioning scheme, to make sure you maintain a reponsive system. How often do you need to update the cube Could you consider doing the following steps: a) materials the dimension informati ...Show All

• SQL Server Package with WinZip hangs

  Dear Folks, I have a package that calls winzip to extract files(command line usage) in an Execute Process task. The package runs fine if I am logged in to the server. It hangs on the winzip task otherwise. The package is stored on the server (as opposed to the file system) & is run under a proxy account using the SQL Server Agent. I tried adding folder and WinZip32.exe permissions for the domain user who the proxy account was created under to no avail. Any Ideas Thanks for your help! I don't have a high enough version for that particular utility, but found you could use the command line for older and standard versions as shown here: http://www.memecode.com/docs/winzip.html I'll be trying this out in my package and will post b ...Show All

• Visual Studio 2008 (Pre-release) Unable to run default XAML in Blend or VS2005

  Scenario A: I open VS2005, Under the Visual C# node I select Net Framework 3.0, and then select Windows Application (WPF) from the templates on the right. The following code is generated: <Window x:Class="WindowsApplication8.Window1" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="WindowsApplication8" Height="300" Width="300" > <Grid> </Grid> </Window> When I try to compile and run the app, I get the following error: Cannot create instance of 'Window1' defined in assembly 'WindowsApplication8, Version=1.0.2613.23423, Culture=neutral, PublicKeyToken=null'. Exception has been thrown by the target of an invocatio ...Show All

• Visual Basic Opening a form

  VB6 is total different than this! Learning a new platform, so please excuse me for my mistakes! I have a form which needs to show one record(thats all that is needed-its a table that carries the end-users info only-so only one record). The form has got the right datasource. I maybe opening it wrong to show the data. I have got a command button on my main form to open the "Company" form, with the following code; Private Sub Button5_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Dim MyForm As New Company MyForm.Show() End Sub The form opens, but with no data, there is data there because it is being used on the main form. Where did I go wron ...Show All

• .NET Development Problems connecting to sybase from serviced component

  Hi, folks: I'm new in this forum. I'm running an application in a Sybase DB. I have the following code: using System; using System.Configuration; using System.Data; using System.Data.OleDb; using System.Reflection; using System.EnterpriseServices; using System.Runtime.InteropServices; using System.Runtime.Serialization; [assembly: ApplicationName ( "DistributedTransaction" ) ] [assembly: ApplicationActivation ( ActivationOption.Library ) ] namespace TestEnterpriseServices { [ Transaction ( TransactionOption.Required ) ] public class DistributedTransactionSybase : ServicedComponent { public DistributedTransactionSybase () { } [ System.EnterpriseServices.AutoComplete() ] public void NewItem () { OleDbConnectio ...Show All

• SQL Server AVG MDX Function

  I have been trying to solve a calculated measure using both the sum/count methods and the avg function, but neither is working for the result that I want. We are trying to come up with an average course score based on an average test score. Example: user takes two tests (test1 twice for 50% and 100% - avg = 75% test2 once for 100%) and the course average would be (75+100)/2 = 87.5%. In our MDX we are getting (50+100+100)/3 = 83.33% instead. We do have a hierarchy set based on course-->test-->test iteration where test iteration is each individual score. The overall average works the way you would typically thing with the sum/count method, but not based on how we want it to calculate AVG(AVG(test1 scores) + AVG(Test2 scorces)). I t ...Show All

• SQL Server Web sync and partitioned snapshot - failed from time to time. Why?

  Hi! Well.. There's operable web sync with parameterized filter. But sometimes the strange errors appear. Below the list of the errors I got from ComErrorCollection property of MergeSynchronizationAgent instance: ERROR: -2147199433 SOURCE: Merge Replication Provider(Web Sync Server) TEXT: The Merge Agent was unable to start the SQL Server Agent job to generate the partitioned snapshot for this subscription. Verify that the SQL Server Agent service is running at the Distributor. ERROR: 22022 SOURCE: HOST3\MAIN TEXT: SQLServerAgent Error: Request to run job dyn_HOST3\MAIN-Customers-Main-2__20061014_14 (from User distributor_admin) refused because the job is already running from a request by User distribut ...Show All

• Visual C# extracting data from comma delimited string

  hi, im using c#, have a comma delimited string and i wish to split it. string example is: john smith, freddy, mark/,jones, john i don't wish to split where a comma is backslashed. any ideas thanks. andreaj your latest code gives me this: TechRepublic.com CNET.com News.com Builder.com john/ smith GameSpot.com Any ideas ...Show All