Kyb3r's Q&A profile

• SQL Server replication system stored procedures parameter defaults ?

  Hi there This is a pretty straight forward question. When using sp_droparticle or sp_changepublication etc, basically any replication system stored procedure. There are many parameters for these sp's basically all i want to know is if i provide the relavant paramaters,that is publication name, subscriber name , specific parameter i wish to change etc, are all the other paramters defaulted to the current publication/subscriber properties. In other words sometimes i really dont know what to provide for all the parameters i am pretty sure as long as i provide the necessary ones the other ones are defaulted correctly, BOL is not 100% clear on al ...Show All

• SQL Server DateTime Error

  I have a function that is based aounr the input of parameters. The last remaing issue is that I am required to enter the data into the parameter field as mm/dd/yyyy. I want to be able to enter the data as dd/mm/yyyy. I have tried to use WHERE (CONVERT(datetime,src_terrier.datadate,103) = @dt_src_date) AND.......... But this just throws an error "Msg 8114, Level 16, State 1, Procedure spWTRalldatareportsummary, Line 0 Error converting data type nvarchar to datetime." The execution line I am using is USE [DashboardSQL-2K5] GO DECLARE @return_value int EXEC @return_value = [dbo].[spWTRalldatareportsummary] @dt_src_d ...Show All

• Visual C++ Compiling FilmBox SDK Under VC6

  Hi, I am trying to compile Filmbox's SDK using VC6.  I can compile under VC7, but I only have a temp version, and do not want to port over to VC7.  The problem I am getting is on the following section of code: /***********************************************************************  CLASS KStaticArray ************************************************************************/ template< class Type > class KBaseStaticArray {     protected:     kInt  mCount;        Type *mArrayBuf;     public:     inline kInt GetCount() { return ...Show All

• Windows Forms Display of column: Cant get it to wrap in column

  Hi all, Is it possible to bind a datagrid to a table and then allow a column to wrap. At the moment I have some carraige returns in a particular datatable column but for some reason it is all displayed on one line in a column of the datagrid. I am not sure if there is even the capability to do this in the grid or datacolumn of& ...Show All

• .NET Development Problems creating Oracle stored procedure programtically using ado.net

  Hello, I am trying to create an oracle stored procedure programatically using ado. It works fine except when I have single quuote or a double quote as a part of comments inside the stored procedure. I don't get any error messages but it creates the procedure with compilation error. Below is the comment line in the procedure. -- This is comment ' " Can someone please help What do you get if you run SELECT * FROM all_errors WHERE NAME = "Procedure Name" from SQL*PLUS. Also does ALTER PROCEDURE COMPILE compile correclty Lastly which provider are you using Or ...Show All

• Visual Basic Updating a dataset help...

  Allright, well it seems simple enough, but I'm kind of stuck. First of all, I'm using VS 2005. I've run into trouble while trying to use the save on the navigator tool bar that automaticaly appears when you drop a table onto a form. After I delete a row from my table, I want to save the data; thus, I click the save button on the navigator toolbar. Here is the code that is automatically generated when the toolbar is created to handle the save button click event: Private Sub TblTeamInfoBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblTeamInfoBindingNavigatorSaveItem.Click ...Show All

• Software Development for Windows Vista Context menu registration refused for lnkfile

  I have an app that acts as a CMH for shortcuts (not their targets).  I'm using the same procedure as in earlier Windows and register as a context menu handler by adding this key to the registry: HKLM > Software > Classes > lnkfile > shellex > ContextMenuHandlers > GUID Trying to add the key with REGEDIT displays a message that says I have insufficient privileges to add a key under ContextMenuHandlers.  (Something new in Vista, right ) Hm, if you view the Permissions for the key, Administrators have only read-only permission. You probably need to elevate to Trusted Installe ...Show All

• Visual C# how to make form invisible on startup?

  I have an application that minimises to system tray and runs on windows startup. I would like the application to start with the main form invisible when loaded. Everything I've tried so far has failed. Any ideas Yes, that seems to work quite well now. Here's my solution for future reference: I have a boolean stayHidden which gets initialized when the form is created depending on wheather or not the program was started with a command line argument or not. Then in the VisibleChanged event of the formI have: if(stayHidden) this.Visible = false; This sets the form invisible when it loads. I made the applic ...Show All

• SQL Server Stalled restore? SQL 2005 Standard Edition

  Hi we are trying to do complete restore from a SQL 2000 bak file. The file is 95GB. After running restore database statement, which took about 5 hours, the database shows status "Restoring..." And it's been the same for 12 hours so far. I checked perf mon and it shows zero activity in processor, phy. disk tranfer, and SQL restore throughput. If anyone can confirm this is normal please let me know. I may have to call MS support tomorrow morning if this continues. I guess it should complete the restore within 2 hours, as we have restore 100gb database in the same time on a normal compaq DL380 serv ...Show All

• Windows Forms Adding ODBC installer to Deployment Project

  Hello, I have a program that utilizes a MySQL database.  Unless the ODBC 3.51 driver is installed on the machine, the program will fail.  I plan on deploying this throughout our company but am having issues figuring out how to add this into a setup project.   Can someone help me out   Maybe a link to a tutorial or something Thanks! Affy ...Show All

• Visual C# How do you define Generics?

  Hello, i was hoping to get some insight on Generics (just started to use them) But i have these questions: My first idea of Generics was easy Polymorphism, but it seems as tho the reson for using generics are Type Safety and Performance, thus if you define <T> then objects are stored as (int, string, customObject, etc)... Im in the beginning phases of a project and i need to create methods, etc. that can be easily used without knowing the type of object until runtime. The normal way i would do this in 1.1 is to create Interfaces and implement them in newly introduced classes. Is this still the preferred/recommended way in 2.0 What is ...Show All

• Visual Studio 2008 (Pre-release) Vista Beta 2 IIS7 setup

  I've just upgraded to the new Vista Beta 2 build 5384 and am unable to get any of the WCF samples provided with the SDK to run.  I'm pretty sure it's just an IIS7 setup issue. From reading around i've seen a few sites recommending that i add a MIME type mapping for the .svc file... but i cant' work out how to do that.  This ( http://www.iis.net/default.aspx tabid=2&subtabid=25&i=1032) suggests that there should be a MIME Types item in the list of things i can configure for the default web site in inetmgr ... but it's not there Here's what i have done so far. Installed... 1. Vista 2. IIS - added the windows featur ...Show All

• Visual C# Generating XML Documentation for File-Based Web Services using VS 2005

  How do I generate XML Documentation for file-based web services using VS 2005 For a normal class I can right-click on the project file, select Properties, select Build, check XML Documentation File, enter the file path, and it is generated when built. There does not appear to be that option available for web services saved to a file (not IIS/localhost). ...Show All

• .NET Development Moving Chat sample from Http to Ipc channel...

  I'm trying to convert the "Remoted Events (Chat) Sample" ( http://support.microsoft.com/Default.aspx id=312114 ) from Http to Ipc channels in .net V2. Since everything is setup in config files, I have only changed the server and client app.config files (see below). Unfortunately I'm getting a RemotingException in the client with the message: "Failed to connect to an IPC Port: The system cannot find the file specified.". Is anybody able to shed any light on this I've used IpcChannel before, but never set them up from config files. Server: <configuration> <system.runtime.remoting> ...Show All

• Windows Forms Mouse Event Handler

  Hello , I am facing a weird problem. I am using the MouseDown event handler to detect a mouse press on a particular button. This code works on one PC but does not work on the other. Both the PCs work on Windows XP OS. Is there anything I am missing Thank you very much in advance Venksys The sample code is elow: private void startButton_MouseDown( object sender, System.Windows.Forms.MouseEventArgs e) { Cursor.Current = Cursors.WaitCursor; string Channel_Text_Start; bool [] dataArray = new bool [1]; dataArray[0]= true ; try { reset_Indicator_high = new Task("DO_pin_17_high"); Channel_Text_Start="Dev1/port1/line7"; ...Show All