Kenny Spade's Q&A profile

• SQL Server HELP - Problem with Replication

  Hello, I have transactional replication running between two SQL Servers. It's a push subscription and the distributor is on the local publisher. Recently after running for a year the replication stopped working and we get the following two errors. 1 - The process could not bulk copy into the table "History_Rep" String Data, Right Truncation. Error Number 22001. ------------------------------------------------------------------------------------------------- 2 - The process could not bulk copy into the table "History_Rep" Unexpected EOF encountered in BCP Data-File. Error Number S1000 The data type ...Show All

• .NET Development Side by Side Execution

    I have a little problem in my application: Assembly1.0 and Assembly1.1 is in GAC Application is referecing Assembly1.0, how can i tell Application to use Assembly1.1... and if Assembly1.1 is removed from GAC how can i tell Application to use Assembly1.0 thanks in advance i am just newbie.... I guess if you set the "specific version" property in reference to false, it will handle the problem for you. ...Show All

• Software Development for Windows Vista How do you handle Persistence with WWF Beta 2.2?

  Tom, I am unable to raise events in WWF Beta 2.2 (unlike WWF Beta 2.0). When I set UnloadOnIdle = " false " (from "true"), I am able to raise the first event without an error, but am unable to get the XOML only State workflow assembly reference via persistence. The problem is that I am unable to persist a State XOML workflow when using WWF Beta 2.2. Everything worked fine with WWF Beta 2.0 State workflows (non XOML only State Workflow). What should my web.config look like (as opposed to what you see below) What code changes would I need to make using WWF Beta 2.2 What is SharedConnectionWorkflowTransacti ...Show All

• SQL Server SQL Server 2005 Express : installation failure !

  When i try to install SQL server 2005 Express, French version (after installation of : Framework 2.0, Visual Web Developper), i get the following error : " Le programme d'installation de SQL server 2005 a detecte des composants incompatibles des versions beta de visual studio, de .NET Framework ou de SQL server 2005. Supprimer ces composants a l'aide de Ajout ou suppression de programmes, puis executer a nouveau le programme d'installation de SQL server 2005. Pour des instructions detaillees sur la desinstallation de SQL Server 2005, voir le fichier lisez-moi de SQL server 2005." I removed all old versions ! Thank's for he ...Show All

• Visual Studio Team System TF command to switch TFS servers?

  Isn't there a way to connect to a different TFS Server via a TF command Yes we already have multiple TFVC servers. Anyway, it is not real easy to determine which server you are currently working against especially if your Workspace name (machine name in my case) is the same on both servers. And what is the point of tf status having a /server switch when it *always* tells me: Ignoring the /server option. That's very annoying since I really would like to check status on a specific server. I must admit that I was surprised that the same workspace just switched over to the new server. I figured worksapces somehow would be bound to a s ...Show All

• Windows Forms hey anybody

  i just want to know if i could create a new table into an existant database i'm handle an odbc and a mysql database i know it's a kind  of a frankesnstein but it's my duty so can anybody helpme Lan Ong, for future reference, you can use the <<b>code</b>><<b>/code</b>> tags around your code to have it for ...Show All

• .NET Development Dynamically creating result columns & data

  I have created a database that has a JOBS table, each row of the table has corresponding records in a JOB_TASKS table. Each job may have a different number of records in the JOB_TASKS table. I am trying to create a query that returns a few fields of the JOBS table, then searches the JOBS_TASKS table for all related records and uses those records to create additional column names back in the query and fill in the data in the correct columns. So if the JOBS table fields & data look like this: JOB_ID, NAME, DATE 5000 Bob 2006-01-21 And the JOBS_TASKS table fields & data look like this: JOB_TASK_ID, JOB_ID, TYPE, COMPLETED ...Show All

• SQL Server The proxy auto-configuration script could not be downloaded

  Hi, I am trying to create a Merge Replication through Web synchronization , i used the publish server as distributor and i installed IIS on the same server. i tried the following URL https://mysite/replisapi.dll  from publish server and it was ok. i got the following message: SQL Server WebSync ISAPI. from the subscriber server i checked the url https://mysite/replisapi.dll  too and it was ok too and i got the following message: SQL Server WebSync ISAPI. I created the publisher and publication and everything is fine , i checked the option to allow web synchronization. From the subscriber side, i created all settings, i did a ...Show All

• Visual Basic Installed app path

  Is there a way for me to detect if an application is installed on the user's system, and if it is, what the installation path is Obviously, some programs are not "proper citizens" in Windows and don't register themselves properly, but I'm more concerned about mainstream ones that supposedly do, like Word and Excel. You can always scan the HKLM\Software\Microsoft\Windows\Current Version\Uninstall\ Not every entry has the application path though. Dustin ...Show All

• Visual Studio Express Editions Corbis images and the icons

  I heard they come with the regisration. But where can i find them after registering it. ...Show All

• Visual Studio Team System Some more custom rules

  Hi I need to enforce the following rules- 1. Use string.Length==0 to check for empty string instead of String.Empty. 2. Do not use Response.Write(e.Message) to display exception messages on screen. 3. Use e.ToString() instead of e.Message to log exception details I've reached almost half-way trying to implement these rules, but cant seem to proceed. Can anybody help Regards Amit Hi Amit, Rule 1 already exists in FxCop: TestForEmptyStringsUsingStringLength for the other two rules, you need to provide some more details on what is blocking you so we can give some detaile ...Show All

• SQL Server How to connect to remote database using MS SQL Server 2005

  i'm using sql server 2005 developer edition. In sql server 2000, when i connect to my remote database, i just need to provide my IP address, server name with password in Query Analyzer. However, i do not know how to connect to remote database in SQL Server 2005. I did allow local and remote connection using Surface Area Configuration. However, after setting this, i do not know where to input the IP add, server name and pwd as well...>_<. Who can help me Thanks for ur expertise. So you want to connect to another sql server instance through sql server 2005 query Are you not able to type it in on ...Show All

• Visual Studio Tools for Office deploy VSTO 2003 for excel 2003 in network folder

  Dear All I have a VSTO 2003 solution for Excel 2003 in C#. i need to deploy it in the secured network folder. and create shortcuts for end users to use the same file. i searched net i managed to get 2005 related help. i couldnt find 2003 Pls help me thanks Youtham Hi, 1. After building your VSTO 2003 sln, and xcopy the dlls into the network folder; 2.open the Excel document, go File ->Properties dialog, and under Customer tab, edit _AssemblyLocation0 property's Value field to let it point to the above network folder. And save the document; 3.Run caspol on the end user's box to ...Show All

• .NET Development IOException when SerialPort.Open

  Hi I am trying to open serialport on COM1 so that I can print some messages to it for debugging purposes. When I invoke this function below, it does list COM1 and says Port is Closed. But raises IOException at port.Open(). private void Func() { SerialPort port = new SerialPort ( "COM1" ,115200, Parity .None); //this works string [] ports = SerialPort .GetPortNames(); foreach ( string str in ports) { Console .Write( "The List of Ports are: " + " \n\n " + str + ":" ); if (port.IsOpen == false ) { Console .WriteLine( & ...Show All

• Visual Basic sending a char

  hello how can i send in visual basic a char i want to design a form with multiple textboxes and want the users to enter their text with some buttons. now i don't know how i can add the chars to the active textbox. greetings chris In the button click event set the textbox .text property Example  in the Button1 click event Textbox1.text = "foo" will set the contents of a textbox of that form called textbox1 to display foo   Now id tou want to add it to the Active text box then you need to determine which textbox is active - I would creare a variable that contains an i ...Show All