logikel's Q&A profile

• Windows Forms OracleClient with Clickonce Deployment

  I am trying to deploy an application using Clickonce. I previously was using OleDbConnection to connect to an oracle database. However i would like to use the System.Data.OracleClient namespace instead. Upon publishing the application the users get an error when they try to connect to the database. Do i have to install the oracle connectivity files manually on the user's computer Is there a way to distribute the needed files as prerequisites Thanks for your help. In your case I think you just have to install the oracle client software on the client. In the end I used OleDb instead of Oracle to get past my problem. ...Show All

• Visual Studio Team System Migrating Team System Project from one server to another

  hi, How can i migrating a Team System Project (with all the relvant data and configuration) from one server to another Take a look to this article which has links about moving between servers http://blogs.msdn.com/vstsue/archive/2006/03/22/558178.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How can I make this simple tut model viewer get best stuff like AA 720 1080 and so on?

  How can I make this simple tut model viewer get best stuff like AA 720 1080 and so on Heres the code thanks so much could you maybe bold the changes and add to the code im more a person who learns by people adding it in and letting me chance it kind odd I know but im lost with sniplits. Also there no code button (for forums make it work better) #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Content; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framework.Input; using Microsoft.Xna.Framework.Storage; #endregion public class Game1 : Microsoft.Xna.Framework.Game { GraphicsDeviceManager graphics; Conte ...Show All

• Windows Forms Read text file

  I have a vb script in a excel file which will read data from spreadsheet and generate a text file. Then I use vb.net (stream reader.readline) read this text file. The problem is the text file generated by excel script contains some special characters such as " c" , " R ". These special characters are ignored by the vb.net. Does anybody know why and how to work around the problem Further test, if I use streamwriter generated a second text file, and then cut & pasted all the content from the first text file to the second one. Then streamreader can read all text. Thanks Ying Hi, It probably has to do with the encoding of the file. Here's a link to more informati ...Show All

• SQL Server detecting & deleting duplicates in batch vs proc

  I know how to detect & delete dups/or >dups in test with a select clause, this works fine in a small table, but if the table has a million rows say, it sounds like a proc would be faster:  my question is:  How do I display those rows in a proc for detecting what the problem is.  The print stmt. doesn't seem to work and I wondered if I had to go through the process of building an output stream.  The proc creates okay but I'm stuck after that part. thx Kat  -- very rough code below   SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create proc dupcount @count int as set nocount on select categoryID,  CategoryName,  Count(*) As Dups  from Categories group by Categoryid, Cate ...Show All

• Windows Forms Cell Validation, can not leave the cell?!

  I would like to check the value of a cell in my Datagridview, which is binded to a DataView, to make sure it is equal to 1. I have two problems: 1. When I first load the Form and load the DataGridView, and click on a cell and change the value, then leave the cell it does not fire the Cell Validation event. The next cell I click on will fire it. Why will it not fire the first time It fires every time after. 2. If i enter an invalid value, I get the error text, but when I change the value to 1, It still locks me into the cell, and I cant leave it. I debuged and the first bad value that I enter in there, it keeps trying to validate against, even after I have changed it to a correct value. Any help would be greatly appreciated, b ...Show All

• SQL Server Quotes or no quotes for calculated members

  Guys, I am a little confused by the calculated members that shows the MDX between quotes for converted cubes. If I take off the quotes, it looks like it works so what are the quotes for I am talking about the form view of calculated members. Thanks, Philippe ...Show All

• SQL Server How to Change the Transaction Log File size to less than the Intial Setting.

  I have H Drive with 12 GB size. The Transaction log file of my Database is given in H drive. i.e H:\Krishna_log.LDF. My database initial setting for the Krishna_log.LDF is 10 GB. so currently I can see 10 gb file occupied in the H Drive. very soon my database Krishna_log.LDF is going to increase 10%. Even though If do Backup/Shrink, it will reduce to the initial to 10 GB. So all I need is, change the initial size of the Krishna_log.LDF from 10 GB to 5 GB. Pls give your suggetions...(I dont mind to shutdown,Restart the Sql server do these changes to achive this Task). Thanx in advance. Regards, Krishna you can try this: 1. backup you database!!! 2. check to ensure there is open transaction (dbcc opentran) 3. run sp_det ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sprite Doesn't Animate

  Alrighty, here we go again with another problem. I used to use a simple sprite sheet, but in recent days I have found I need to add some more functionality. My previous spritesheet class would load a sheet which had all frames have the same height and width. They were laid out horizontally, and the height and width were hardcoded. It worked, but I wanted to make a sprite sheet loader that could load and animate any sprite sheet, provided there was an XML document to explain where to look on the sheet. Thus, the actual frames can be anywhere on the sheet, in any order, just so long as the XML file is correct. So, I wrote that class. Now, come time to test it, the animation part of it doesn't work. Hard coding a frame to use shows that ...Show All

• Visual Studio VS Host Assembly Resolving and parameter passing problem

  Hi, I need to pass some parameters to my template engine using VS host. I'm able to do it using TextTransform.exe tool, but now I need the same inside Visual Studio to have possibility run transformation from Vs as well as from command line. I check the code of TextTemplatingService.ResolveParameterValue and didn't find any way how link VSProject properties to template parameters. I think this is a valuable feature when you whant to change the behaivor of templates based on Configuration (Debug, Release), for an instance. Probbaly I just failed to find it. And second problem is assembly reference resolving. I'm able to specify the path where looking for my assembly when using TextTransform.exe tool and not able to specify it for VS ...Show All

• SQL Server regular expressions in transact sql

  hi guys, i need some help tp write code in order to search the string ( regular expressions) in t- sql. e.g. when a user enters [A-Z] it means any alphabet from 'A' to 'Z'... similarly [0-9] means any digit. the problem is: when user enters [0-6] and the string received contains digit 5 it should return true but if it contains 7 it should return false. so how do i read the [A-Z] as a range of characters in t-sql   hi, In sql server it is not exactly regular expression, it is called wild card pattern. in other words it is simplified reqular expression, as of now SQL Server Like operator only work with following operators % - Zero or any number of chars _ - Single Char [] - Single Char in given ...Show All

• SQL Server SQL Server 2000 / 2005 :: page allocation after reIndexing

  SQL Server 2000 / 2005 :: After 8 pages are allocated to a table (from mixed extent), next a full extent is allocated ( 8 pages) to the table. e.g. I have a table with 1 million records; with first 8 pages (as usual) will be from mixed extent and remaining pages are from Uniform Extent. Now if I reindex (DBCC DBREINDEX) the table's Clustered Index, does it still allocate first 8 pages from mixed extent OR it allocates all pages from Uniform Extent (now that it knows the table needs more than 8 pages) ...Show All

• SQL Server Installation of Service Pack 4 for SQL 2000

  All, I have a problem with installing SQL 2000 Sevice Pack 4. Please see Part II. Service Pack 4 comes in four parts and each one is to be used to apply to different SQL server components. Part I - Analysis Service Pack - Complete . Part II - MSDE component - Problems . The original problem was that it needed a strong password. I got around that by supplying the sa password. Now it says that the sql server instance name specified is invalid. I spent some time researching this and have tried to add parameters in an ini file to specify the instance to be updated. So far everything I tried has failed. Currently, I am not sure what to try next. Setup will not run from the dos prompt. Here is what my setup.ini file looks l ...Show All

• SQL Server Dataset Data is not the same as Database Data

  Hi, Thanks in advance. I have a problem in my dataset. Today morning we updated some of the descriptions to our parameter tables. But these are not getting updated to our reports. I checked the dataset. Even that shows the same values. How do I go about this Please help. Thank You. Regards, Das. Hi, Thanks for the reply. I tried to find how to disable the cache in report and dataset properties. But I couldn't find any option. Could you please tell me where can I find the option Thanks for your help. Bye. Regards, Das. ...Show All

• Visual Studio VSS 2005 Crashes When Creating History Report

  My VSS 2005 is crashing when I - Open VSS 2005 Explorer - Navigate to subfolder - Right Click - Select View History - Check "Recursive" - Enter a recent date - Click OK - Click Report - Both Include Details and Differences are checked - Clicking either OK or Preview for any of the choices (printer, file, clipboard) causes a "MS VSS Explorer has encoutnered a problem and needs to close". Button choices are Debug, Send Error Report, Dont' Send. If I click debug, VS opens with a green arrow at the bottom of this method. Unforntuantely I dont know C++, so I dont know any other context to provide BOOL CStatusBar::SetPaneText( int nIndex, LPCTSTR lpszNewText, BOOL bUpdate) { ASSERT_ ...Show All