klymer's Q&A profile

• SQL Server cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I believe that the encoding of the text file is ANSI. If it is relevant the database collation is Latin1_General_CI_AS (the same as it was when 2000). Any help anyone can provide will be greatly appreciate ...Show All

• SQL Server Create New SQL Server Mobile Edition Database

  Hi, I follow the instruction to install SQL Server 2005 Mobile Edition, but when I try to change the Data Source to add a new connection, I don't find "Create New SQL Server Mobile Edition Database". Does anyone know how to fix this Thanks Paolo Giorgio DEVTOOLS ==> Microsoft SQL Server 2005 Mobile [ENU] Beta 3 or Microsoft SQL Server 2005 Mobile [ENU] Developer Tools Uninstall & Reinstall  DEVTOOLS using the MSI sqlmobile30devtoolsenu.msi in wcu\SQLCE sub directory of your Whidbey Installation Disc.  Goto ADD/REMOVE programs to uninstall DEVTOOLS. Thanks, Laxmi NRO, MSFT, ...Show All

• SQL Server Package Migration Wizard error -- Index was out of range

  I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib) ------------------------------ Program Location:    at System.Collections.ArrayList.get_Item(Int32 index)  &nbs ...Show All

• SQL Server Change the type of an expression container

  Hi, I use expressions to build the SQL query that is executed by the data flow. Today, I ran into an issue. For the first time the SQL query has exceeded 4000 char so the expression cannot be validated and it is not possible to use it. Is there a way to change the expression datatype to nvarchar(max) instead of the default nvarchar(4000) Thanks, Philippe Is there any way around the 4000 literal string masx issues. Its sad that the case because a table could contain many fields and that might cause the literal string to be more than 4000. ...Show All

• .NET Development JIT: different code emitted for the same IL in the same process

  I'm trying to find out what factors could affect the JIT mechanism so it would produce different binary code for the same method within the same process. An assembly, unless domain-neutral, can be JITted multiple times during the process lifetime, when loaded into a new application domain. Somehow I thought that, because typically none of the factors like the assembly footprint, system configuration etc. are changing during a process lifetime, it was expected to see the assembly's IL be JITted identically every time. Well, sometimes happens to be not so. One scenario I found is this: consider a CLR 1.1 application that creates an extra AppDo ...Show All

• Visual C# "a" and "§" --- What's this ?

  Hi PPl, Have any body got Idea about the special character "a" & "§".what's the usage i found this in a Web Service. It goes here, { strReturn += PwdReader["STAFF_ID"] + "a" + PwdReader["EMPLOYEE_CODE"] + "a" + PwdReader["FIRSTNAME"] + "a" + PwdReader["LASTNAME"] + "a" + PwdReader["STATUS"] + "§"; } And please help me to find this Character in the IDE. Thanks .. a = ASCII Code &#230 § = ASCII Code&#167 If you want ...Show All

• Windows Forms Deploying changed User.Config or App.Config via VS2005

  G'day, I've been struggling in VS2003/VS2005 to deploy an application upgrade that includes new entries in the User.config or App.config file. When I deploy a solution via MSI, I really need to keep some of the existing clients *.exe.config settings like database connections, but need to add new values to the existing User.config/App.config . Eg. Form position coordinates and sizes, which are new features of an application upgrade. How do you do this Options (from what I can see) The best/only solution may be internal code. However it seems near impossible (no easy solution in vs2005 [see http://forums.microsoft.com/MSDN/Show ...Show All

• Visual Basic ByVal variable passing

  didnt know where to post this, so i decided here was a suitable spot. anyways lets say i have an OCX that has variables defined.  the OCX, we will call "HMM" example given: Private Sub HMM_NAMEHERE(ByVal Latency As Long) now "Latency" is already declaired in the OCX as a changing variable that depends on the user that is connceted to a server.  so its not set. now im trying to pass that variable to a "Private Sub ListView_MouseMove".  the Latency variable in the HMM sub contains the true value, and i just want to pass that value to the ListView sub i have listed. how would i go about doing that here is an image, if it ...Show All

• Visual Studio Team System TFS Dual Server Deployment Licensing Question

  One doc I read on TFS licensing said that you need a license for every server you install TFS on. That sounds reasonable but what does that mean in a dual server (separate App/Data tier) deployment Does that mean you need to buy two TFS licenses for a dual server deployment I mean it's a single "logical" server, right Yes, you need a license for each machine. Same goes for clustering on the data tier, machines used as warm stand-by, etc. ...Show All

• Visual C# How detemine compiler version for custom attribute ?

  Hi! I want to write a custom attribute to indicate that a class or method is deprecated after a certain version of the compiler/runtime. How do I check the version number of the compiler/runtime from an attribute Thx! Jess C# Online.NET http://wiki.csharp-online.net/ right, using reflection: using System.Reflection; private string AssemblyVersion { return Assembly .GetExecutingAssembly().GetName().Version.ToString(); } ...Show All

• .NET Development BinaryDataMTOM sample

  Hi, I am just reviewing the BinaryDataMTOM sample project. At the service side there is a method GetFileResponseWriter.WriteXml(). If I understand correctly the class GetFileResponseWriter is used to provide xml schema and serialize the binary file. Method WriteXml() actually calls XmlWriter.WriteBase64 and the returned schema from the class is base64binary. So far so good and my expectations are that regardless of the MTOM settings there always be send base64 encoded binary. However in some way WSE handles the base64 encoded string and send it to the client as a binary MIME part. How is that possible I thought that explicit call of Write ...Show All

• Visual Studio How to manually process template in June CTP?

  I'm using the generate many files from one template approach by Annie . But the parameters for "ProcessTemplate" on the interface ITextTemplating has changed in the June CTP. You now need a "IVsHierarchy" as a extra parameter. Where do I get that thing Passing in null doesn't seem to work. Hope someone knows how to solve this, Gerben. The filename is used in the error window if there are errors in the input. Also the path of the filename can be used by the host to locate the file in the "requires" clause: it assumes this file has a relative path related to the input fi ...Show All

• Visual C# help a beginner please how to make this software?it with dictionary and chat and ....

  maybe my question so stupid~ please for give me~ i want make this software to help some japanese learn english and can put it into a game but most~ use it at desktop. i think it need thoese function: english dictionary; english <-> japanese dictionary; IM chat; file share,any file had index at server,can load a file from each other, seen like emule and bittorrent and Ares; storage ask and answer like a forum or knowledgebase; i dont know how to make a dictionary software. where to find a dictionary file it is free i think the WIKIdictionary is free but how to do that i find many free translate website how to do that i need the dictiona ...Show All

• Smart Device Development multithreading

  Hi guys, I am having a problem with implementing two threads in an application. One of the threads is doing the timer, which updates the progress bar everytime it ticks. The other thread is a work thread. Here is my code. It freezes when I run it.   private void timer1_Tick(object sender, System.EventArgs e)   {    if (this.progressBar.Value<this.progressBar.Maximum)    {     this.progressBar.Value++;    }    else if(this.progressBar.Value==this.progressBar.Maximum)    {     this.timer1.Enabled = false ...Show All

• SQL Server How do I devlop application which can use 2000 Reporting Services and 2005 Services

  Please guide me in developing applications which can work with Reporting Services of 2000 and 2005. Are there any design considerations to be taken to develop such applications. Thanks, V Could you please give me some references for the documentation to develop applications which can work both on 2000 Reporting services and 2005 Reporting Services . Best Regards, V ...Show All