Yuki Chen's Q&A profile

• SQL Server SQL Server 2005 Service Pack 2 CTP is available

  Hi, SQL Server Service 2005 Pack 2 CTP (Community Technology Preview) is available... http://www.microsoft.com/sql/ctp.mspx The list of new features and fixed was published here on KB Article http://support.microsoft.com/default.aspx/kb/921896 Regards Nilton Pinheiro www.mcdbabrasil.com.br Hi maddesco, Is there a date yet for the public version No. Now, the December CTP of SP2 is available at: http://www.microsoft.com/sql/ctp.mspx If not, any estimate of when it might be Dec CTP is the last SP2 CTP release, so I believe that between Jan end and Feb middle will be a most likely date. thanks Nilton Pinheiro www.mcdbabrasil.com.br ...Show All

• SQL Server redundant definitions of row...WHY?

  insert new row for car private static void InsertNewCar( SqlDataAdapter dAdpater) { // Gather info about new car. Console .Write( "Enter CarID: " ); int newCarID = 0; try { newCarID = int .Parse( Console .ReadLine()); } catch { Console .WriteLine( "Bad input! Canceling request" ); return ; } Console .Write( "Enter Make: " ); string newCarMake = Console .ReadLine(); Console .Write( "Enter Color: " ); string newCarColor = Console .ReadLine(); Console .Write( "Enter PetName: " ); string newCarPetName = Console .ReadLine(); // Format SQL Insert and plug into DataAdapter. // ................ ...Show All

• Visual C++ Symbol Lookup Not Working

  I have Visual Studio Team Edition, and have built the projects of a solution, but shift-f12 (symbol lookup) doesn't find anything...ever. I made sure to "Enable Browse Information" in the C/C++ "Browse Information" project property page, and it is indeed generating sbr and bsc files...but symbol lookup refuses to work. What am I doing wrong I don't think it is using .sbr/.bsc files, it works fine without them. IntelliSense would be my guess. Everything OK with IntelliSense for you ...Show All

• Visual C# Classes without namespaces (Error 1)

  Hi, I'm debugging someone else's code. The programmer is not using namespaces and all his classes are in different files with the name of the class as the filename. Somehow, only on my machine, I get an error saying: Error 1 The type or namespace name 'MyClass' could not be found (are you missing a using directive or an assembly reference ) Works fine on his computer. How does the IDE resolve the "using" statement and, if someone is only writing classes without namespaces, how can the compiler find a class when it's being used as a type in another class (and file) Plus, if a file is included in a project, doesn't the IDE "register" the possible use of all the classes defined inside that file Is there ...Show All

• Internet Explorer Development IWebBrowser2::ToolBar property not working under IE7

  My web application installs a client-side control that uses the IWebBrowser2::ToolBar property to enable / disable the IE menu bar and toolbars. Under IE7 RC1 this works if my application is running in the _only_ IE7 tab; but if other tabs are open enabling / disabling toolbars has no effect. I can see why the tab bar isn't being hidden with more than one tab open, but not why other toolbars are not -- seems like they should be enabled / disabled as appropriate for the active tab (the IWebBrowser2::MenuBar property _does_ appear to work this way). Thoughts Suggestions for a workaround Thanks! In IE7, each new tab contains its own instance of IWebBrowser2. This may be why it seems that the other ta ...Show All

• SQL Server Earlier question on ODBC compatibility

  Hi Chris: I am sure as you are aware only data adpaters in SQL 2005 out of the box are .NET Frameworks, in your answer to Stoobs, you state the ADO.Net framework does not have all the APIs. We're experiencing the same problem with the product and ODBC. Unfortunately we have a legacy MUMPs DB (that KBSQLODBC layer sits on top of, its a flavor of SQL from Knowledge Based systems) that our vendor is not going to update. Given that, how can we address the ODBC driver problem with SQL 2005 Is there going to be an update to ADO.NET Thanks, dfreshman The trick to this was knowing not to use the Data Source View. I had to create the Data Sources, add them to the connection manager make sure their ...Show All

• SQL Server SQL Server tcp connect problems

  I have MSDE SP4, SQL Server 2000 Developer SP4 and SQL Server 2005 Developer SP2 loaded on my laptop / server. The OS is Win XP SP2. So I have 3 instances of SQL Server running. There names are: TPM8500, TPM8500\SQL2000 and TPM8500\SQL2005. My client machine is also running Win XP SP2; and it has a copy of MSDE SP3 of its own. Both computers are in the same network on a LAN. Both computers have identical Administrator passwords. I am having problems with the network SQL connections from the client to the laptop / server. Local connections all seem fine. Network connections are unstable. From time to time, a network connection can be made. I am more likely to make a connection to the default instance, especially when I am l ...Show All

• SQL Server Prob on Importing

  I have a field name say cust_code it is a uniqueidentifier.While importing a excel sheet on my table on sql server2005 it display the following error.... - Copying to [mission].[dbo].[company_profile] (Error) Messages Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". (SQL Server Import and Export Wizard) Error 0xc020901c: Data Flow Task: There was an error with input column "Pincode" (199) on input "Destination Input" (174). The column status returned was: "The value could not be converted ...Show All

• Windows Forms Eating MouseWheel Events

  I have a PixtureBox placed in a panel with AutoScroll enabled. I use the mouse wheel to zoom in and out of the image. I was able to add the mousewheel event code and this is working just fine but the image not only zooms, it scrolls with the mouse wheel as well. I would rather not have the image scoll due to the mouse wheel. I have seen examples for C# to use WndProc() to capture the WM_MOUSEWHEEL msg, but I can't seem to get these to port to C++. I have tried the following (Based on the only C++ example I could find)... void WndProc(Message* m) { const int WM_MOUSEWHEEL = 0x020A; switch (m->Msg) { case WM_MOUSEWHEEL: //TODO: Image Zoom Code Goes here... break ; } Form::WndProc(m); } This giv ...Show All

• Visual Studio VS2005 Help missing

  Since installing SQLServer 2005 client to get the SSRS project template, I only get the SQLServer help contents when clicking on the help button. How can I get the VS2005 Help context back or even better, have both VS2005 and SQLServer 2005 available TIA jim Continuing this thread here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=322942&SiteID=1 Thx! Jeremy ...Show All

• Visual Studio Team System TFS with Visual Foxpro 8

  Can TFS be used with VFP 8.0 SP1 The list mentions only VFP9. I have been using VFP8 + VSS 6 for many years and need to change to something more reliable. ...Show All

• Visual C# Overloaded constructors

  Can someone please explain why this doesn't work   using System; public class MyClass { public MyClass () {     MyClass ( 0 , string .Empty);    //error here } public MyClass ( int i) {     MyClass (i, string .Empty);   //error here } public MyClass ( int i, string b)    //full constructor { } public static void Main() {    MyClass c = new MyClass ( 0 ); } The error is: 'MyClass' denotes a 'class' which is not valid in the given context I mean this error highlited on every line where I call my full constructor. P.S. I know how to make it work but the question ...Show All

• Visual C# finding file size

  hi I need to know the size of the file which I am going to read with a stream. but I can not find any way to have the size of the file. regards you can use the FileInfo Class to get the file size. the length property return the size of the file.   FileInfo f = new FileInfo("File Path"); f.Length <- return the size of the file. ...Show All

• Smart Device Development SQL error? Please Help Me

  please help me " Error" i want use dataset in windows mobile application and when i fill datagrid from dataset give fe unknown error please help me Picture for error link Error Picture It's not an "unknown error" but perfectly normal unhanded exception which indicates a bug in your code - luck of exception handling. You should add exception handling, catch this exception and print all information from it - exception type, error message, stack trace and error message from error collection (if applicable). After that you would be able to analyze this exception and figure our why it was thrown. In this case it’s probably thrown because connection to SQL Express can not be established. That can be for number ...Show All

• Visual C# How can I find whether the current thread is exited or not?

  Is there any property or method is available for checking whether the current threading is exited or not. If so can you place provide me the code snippet and some of the useful tutorial & samples links for learning about this concept. Evan Mulawski wrote: if (threadMain.ThreadState != ThreadState.Running) //Not running { //Next step } If a running thread has called a Wait method (WaitOne,WaitAny,WaitAll, etc.) or called Sleep, its state will not be ThreadState.Running, it will be ThreadState.WaitSleepJoin. ...Show All