jazztuffy's Q&A profile

• SQL Server OPENQUERY and unicode from MySQL

  Hi, all. Using SQL 2005. When I execute this query against a MySQL database set up as a linked server, cyrillic text stored in unicode in MySQL shows up as question marks ( ). SELECT * FROM OPENQUERY ( LINKEDSERVER , 'SELECT * FROM documents ) Clearly, some kind of unicode issue. I've spent a few hours reading in BOL and searching online. Must be something simple, but I'm not finding a solution. If anyone has suggestions, I'd be very grateful. Stephen Just to follow up, my testing this morning suggests that this is an issue with the MySQL OBDC driver, used to create the connection to the linked server in SQL Server. So if anyone has solved this issue before, of course I'd be ...Show All

• Windows Forms cannot find table 0

  Hi all, I had the following piece of code. System.Web.UI.WebControls. DataGrid EOWDataGrid = new System.Web.UI.WebControls. DataGrid (); conn = new NpgsqlConnection ( "Server=" + PGIPAddress + ";Port=" + PGPort + ";User Id=" + PGUserName + ";Password=" + PGPassword + ";Database=" + PGDatabase + ";" ); this .Controls.Add(EOWDataGrid); NpgsqlDataAdapter pgDataAdapter = new NpgsqlDataAdapter ( "select \"wid\",\"wstart\", \"EOW\" from \"lwinfo\" where \"wstart\" >='" + tsFromSecs + "' and \"wstart\" <='" + tsToSecs + "'" , conn); conn.Open(); ...Show All

• SQL Server Cube Processing Issue

  We are trying to process the Cube. First time when we processed the cube it took around 1 and 1/2 hours to do full process. But after some time in the same environment its taking more then 6 hours to process. As such there was no change in the environment. We have 64 bit 2 way itinium processor with 32 GB of ram. The size of the cube is aroung 150 MB. We are using the OLE DB2 provider to connect to database.Any environmental issues that needs to be checked.Any thoughts on this issue.Appriciate your help. Thnaks, There does not seems to be any issue with Relational Database side .If I ran the same cube from machine its peocessing very fast.Any factor in analysis box that that can count for slow processing . Analytical bo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What is "title" means?

  Is the "title" in "title storage" means "An identifying name" or "the game program" I think "title" means "the game program",but my friend insist "An identifying name". What does "title" mean Does the "title" in "title storage" mean "An identifying name" or "the game program" I think "title" means "the game program",but my friend insists "An identifying name". Sorry for solecism. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA task palette

  XNA Build was installed in Visual Studio 2005 Standard Editon (Japanese). The tutorial 1 is performed now. However, it has stumbled suddenly. The XNA project was made according to directions. But a XNA task palette is not in a tool box window. A message task is not found, either. Desigen and the MSBuild palette are displayed. How is a XNA task palette displayed if it carries out Try going to C:\Program Files\MSBuild\Microsoft\XNA\Plugins and deleting your cache.dat file. This should force a refresh of the toolbox and should make it appear again. Once that appears you should find the Message task in that group. ...Show All

• Visual Studio 2008 (Pre-release) Is the Except operator broken in May 2006 CTP?

  Or am I misinterpretting what it is supposed to do The doc says: "The Except operator produces the set difference between two sequences." I would interpret this to mean that if I had two sequences of integers, {1,2,3,4} and {3,4,5,6}, the sequence generated by the Except operator should be {1,2,5,6}. However, the technical description of what the operator does makes this a little ambiguous to me. And, the results are not consistent with what I would expect: int [] first = new int [] {1,2,3,4}; int [] second = new int [] {3,4,5,6}; IEnumerable < int > exceptions = first.Except(second); foreach ( int i in exceptions) Console .WriteLine(i); The results are: 1 2 Am I wrong abou ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA 2D Collision Detection using Quadtrees

  I've seen a few posts on collision detection, and though I'd post an article on how to write a collision detection engine for your game. Take a look at: http://mbebenita.blogspot.com/ I'll follow it up with some source code as soon as I get a chance. Michael B. The link does not work :( Will there be any sample code How can you separate the bullets in different regions Is that we use generic list to store the bullets in each region If so, assume there are 1000+ bullets moving in each frame, will the update process slower than just checking all the bullets thank you very much ...Show All

• Smart Device Development Can I install CF 2.0 on iPAQ PPC 2002?

  Hi, guys I go to this page: http://www.microsoft.com/downloads/details.aspx familyid=9655156b-356b-4a2c-857c-e62f50ae9a55&displaylang=en And this is the place to download the .NET CF 2.0 and it does not say anything about PPC 2002. I think it may not support it at all. ...Show All

• Visual C++ Is there any difference between Unicode char set and Multi-byte char set ?

  Is there any difference between Unicode char set and Multi-byte char set in the Visual Studio 2005 Thank you!! Yes, there is a difference between unicode an multibyte. See http://msdn2.microsoft.com/en-us/library/cwe8bzh0(VS.80).aspx for more details. ...Show All

• Visual C# Form Designer - multiple controls inside one single source file

  Is it possible to use the form designer with controls that exist in the same source file Or is the <ControlName>.cs + <ControlName>.Designer.cs mechanism strictly neccessary No, <ControlName>.cs + <ControlName>.Designer.cs is not necessary but just a good habbit to seperate codes accrding to behavior, this is new feature in C# 2.0 and is called partial types. using this you have a single class on multiple files. Its just the idea of isolation of presentation and behaviors. You can put all the code into a single file or even you can have 10 controls in a single file. Best Regards, ...Show All

• Visual Studio HOWTO: Custom titles for X and Y axis for a bar chart

  Is there a way to have the title names for the X and Y axis feed off report parameters It must be something easy that I am missing.. Thanks Steps: * Open the chart properties dialog * Go to the x-axis or y-axis tab * Type in an expression into the axis title field, such as =Parameters!P1.Value -- Robert ...Show All

• Smart Device Development Pocket PC Mobile 5 app....buffer too small or too many cursors open

  ok I keep getting this error....a form as one record of data in labels and a combobox to select a new person...select the person the app gets a new record into a sqlceresultset and puts the data in the form labels... if you select a new record from the combobox about 50 times ths error comes up-----HELP !!!!! i am using one sqlceconnection object (variable) for the whole app...the resultsets are dim'd as needed and closed when i'm done... what does this error mean...i have tried a bunch of stuff.... thanks I think what's happening is that you create an updatable ResultSet, but never close it. You need to close (and preferrably dispose) it when you are done with it. Same applies to the command object ...Show All

• Visual C# True Copying Reference-Value Objects

  I have stumbled upon the following problem: Given an object (any reference-value class) O1, how can I copy it to another object O2. O1 = O2; //will only copy the reference, but I want a new object being exactly identic to the old one. Also, how can I do the same thing on an Array int[] arr1, arr2; arr1 = arr2;// also, doesn't work, only copies the reference Hope I made myself clear enough. Thanks in advanced. Hi have a look at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1119209&SiteID=1 Hope this helps, please close the thread if it does ...Show All

• .NET Development Problems connecting to sql 2005 express....

  I built an application for work and tested it at home on my computer, and it worked like a charm. When compiling it i included what i thought was everything i needed to install and run it at work....but when i install it and try to run it i get and error messege as follows: Named Pipes Error: 40- Could not open a connection to SQL Server. Now i have enabled named pipes and tcp/ip as well as anything else i could find that might be causing a connection failure....but still no luck....I also disabled my firewall thinking it was the culprit...but no cigar....i have SQL Server 2005 express installed on the work computer as a prerequisit... Any ideas on how to make my application connect to the SQL Server ...Show All

• Visual Basic VB NET Debugging - How do show potential error corrections

  I am using VS 2005 (VB NET) on two different machines. On one installation, when an error or warning is encountered, the editor shows potential corrections for the bug. This feature does not seem to be enabled in the other installation of VS 2005 that I am using. How do I enable/ disable this feature What is this feature called I think the thing you're looking for is: Tools->Options->Text Editor->Basic->VB Specific->Enable error correction suggestions ...Show All