Amit Vasu's Q&A profile

• SQL Server accesssing mirrored databases via SQLNCLI linked server?

  Does anyone know how to configure a mirrored pair as a linked server on a 3rd instance Say I have a mirrored database on two servers: PRIMARY and SECONDARY. I want to create a linked server on a 3rd machine that allows me to access the database on the mirrored pair. This is what I'm using: EXEC master.dbo.sp_addlinkedserver @server = N'MIRROR', @srvproduct=N'', @provider=N'SQLNCLI', @provstr=N'Server=PRIMARY;FailoverPartner=SECONDARY;' select count (*) from mirror.pubs.dbo.authors and it works fine if the database on PRIMARY is alive. however when the mirror has failed over to SECONDARY and PRIMARY is no longer available, I get the following when I try to query the database via the linked server: OLE DB provid ...Show All

• .NET Development dataset.merge .NET 1.1

  Hey guys Got trouble with dataset.merge in .NET 1.1 . I did 8 query with the sql database and tried to merge those tables to one dataset. it simply doesn't work. It gets 7 datatable and doesn't merge the 8th one. I wrote a simple for loop and it does the same. mycode: DataSet dts = new DataSet(); for (int i = 0; i < 10; i++) { DataTable dt = new DataTable(); dt.TableName = "table"+i; dts.Merge(dt); } dataGrid1.DataSource = dts; Result: adds table0 till table6 and after tht doesn't add anymore tables. I display the results on a datagrid. Please help!!! is this a bug Or constraints on DataSet.Merge ...Show All

• .NET Development System.Timers.Timer high resolution problem (C#)

  I want to use System.Timers.Timer in my project as a metronom with the resolution of approx. 1ms interval value. When i tried, it works fine up to 10ms, but below that value, it doesn't work. in my sample application, i am using a count value which increases every tick and when the count reaches the value of 100, i invoke a function which updates the label1. When i use the interval as 10, label1 updates every 1 second as expected but when i reduce the interval value, the time for updating the label1 doesn't decrease. For example, when i set interval to 1ms, it still takes 1 second to update label1. Does System.Timers.Timer allows interval below 10 Or is there any timer which does this in .NET framework PS: I didnt set the Syncroni ...Show All

• Visual C++ How to overload the ">>" operator for a user-defined type

  Hi, I have a Location class in my project, and I need to read a Location object by using cin >>, eg: Location locationObject; cin >> locationObject; I'm wondering if there is a way to overload the >> operator for a user-defined type like this. I trid to code the overloading method: istream& operator >> (istream& is, const Location& addLocationObject) { return is >> addLocationObject; } The compiler does not complain, but there is a error at runtime when the >> operator is called: "Unhandled exception at 0x00414219 in C++Project.exe: 0xC00000FD: Stack overflow." and it's pointing at the second line of the method above. Any suggestion Thanks in ...Show All

• Visual Studio Team System Cannot open source code in Visual Studio in Windows Vista x64

  When I click on Location link in a message to open the source code in Visual Studio (having the default “Launch in Visual Studio” selected in Settings) in Windows Vista (64-bit), it does not work, saying “Could not start Microsoft Visual Studio. Try specifying an alternate source code editor in Application Settings.” I tried to watch the process using SysInternals’ Process Monitor, and the only suspicious thing I have seen is: RegOpenKey HKCU\Software\Classes\Wow6432Node\CLSID\{BA018599-1DB3-44F9-83B4-461454C84BF8}\InprocServer32 NAME NOT FOUND Desired Access: Read RegOpenKey HKCR\Wow6432Node\CLSID\{BA018599-1DB3-44F9-83B4-461454C84BF8}\InprocServer32 NAME NOT FOUND Desired Access: Read (The keys really are not present in registry, t ...Show All

• .NET Development FTP Error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

  Hi, I am using a FTP client in my application. This FTP client is a freeware for .NET version1.1. It works fine for all files except two files. But these two files are required to FTP to a mainframe machine. I am able to FTP these two files in command prompt but getting error if I am trying to FTP through my c# application. These two files are giving two different errors mentioned below: 1. Index (zero based) must be greater than or equal to zero and less than the size of the argument list. 2. Input string was not in a correct format. But strangely, if I am trying to FTP these files to a Windows platform then it's getting FTPed successfully. I am also giving right SITE command for mainframe requirement. I am gettin ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. InvalidCallException in 3D primitives code attempt

  Hello, Lacking full examples in the docs, I threw together some of the sample code in the How to: Draw 3D Primitives section, probably incorrectly, and am getting an InvalidCallException on the following line: graphics.GraphicsDevice.DrawUserPrimitives<VertexPositionColor>(PrimitiveType.TriangleList, 12, nonIndexedCube); The details of the exception are not helpful. They say "External component has thrown an exception." My code is below, hopefully this forum formats it ok, without smiley faces etc. Any suggestions appreciated. By the way, I am using an ATI Radeon Mobility X600 and had no problems compiling and running the Spacewar demo. - Matteus using System; using System.Collections.Generic; using Microsoft.Xna.Framework ...Show All

• SQL Server Codepage 932 is not supported by the Java environment.

  I have a JDBC type 4 driver, connecting to a Japanese SQL Server 2000. The connection gives this SQL exception: SQLException: Codepage 932 is not supported by the Java environment. SQL State: null SQL Code: 0 This same software has been in use and working just fine for over 2 years with other servers. Does anyone know the solution to this problem Thanks! pds2 Hi, The Microsoft SQL Server 2005 JDBC Driver relies on nio Charset support in the JVM to map from CHAR/VARCHAR/TEXT values with SQL collations to Java String instances. To do that, it needs to have charsets.jar, provided by your JVM vendor, installed and accessible via your application's classpath. Some JVM vendors choose not in ...Show All

• Visual C++ COM Shell Extension Drag Drop, Copy/Paste

  Hi All, I am working in VC++ 6.0. My requirement is to get the control when an user try to Drag and Drop or Copy and Paste any file into a specif folder in Explorer. I referred to some web pages and got to know that this can be achieved by COM Shell Extensions. I am very much new to this requirement, Can anyone please help me out in this regard. Regards G.Girish For VC6.0 issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Basic Saving ListViewItemCollection

  Connection.Open() Dim cmd As New OleDbCommand cmd.CommandText = "INSERT INTO PANELDETAIL (PanelID,PanelName,ExamName) VALUES (@PanelID,@PanelName,@ExamName)" cmd.Parameters.AddWithValue("@PanelID", tboxID.Text) cmd.Parameters.AddWithValue("@PanelName", tboxName.Text) cmd.Parameters.AddWithValue("@ExamName", lviewIncluded.Text) cmd.Connection = Connection cmd.ExecuteNonQuery() Connection.Close() Basically, this code just inserted a certain record on my database...All seems fine but the one with the question mark, I don't know how to insert but I am certain that it's wrong.I just want to ask how can I ...Show All

• SQL Server Database start trigger 2005

  Hi, I have searched high and low, and can not find any mention of SQL2005 and mount/start database DDL triggers. I need a trigger/job/event to update a column in a table to indicate that the database has been restarted. I can not have an application connect to the database and set this value as I am afraid one of my other computers may connect first and get the wrong state from the database. Is there any way to have SQL2005 update a table on MOUNT/Service Start/DB start Regards, Derek ...Show All

• Windows Live Developer Forums CAN NOT UPLOAD LARGER PIC ???

  I used windows live writer to refresh my blog, and there is a problem that when I try to upload a pic which size is more than 50bytes(not very sure, but nearly to this size), it just return a message from  Remote Server , 403 forbidden. Is there any limitation of the pic size But if not, can anybody tell me why or how With great thanks, Michael   Michael: This forum is for questions and discussions related to Windows live Spaces development. For issues with Live Writer, try the Live Writer forums at: : http://groups.msn.com/windowslivewriter/ . ...Show All

• Visual Studio 2008 (Pre-release) How To: Rename Windows Application (WPF) Form Name & Class Name

  Hi all, I am using Visual Studio 2005 extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP. I had created a new project of "Windows Application (WPF)" type that is named "WindowsApplication1". How do I can rename the Windows1.xaml to some other name that I prefer If I rename it, some compilation error will appear. Please advice. Thanks! Check the "Build Action" property of your renamed Window1.xaml and make sure that it is set to "Page". And in case you want to rename MyApp.xaml you should check that it is still set to "ApplicationDefinition". I remember seeing some issues around that with the WPF project flavor for Visual Studio 2005. ...Show All

• SQL Server date parsing

  Hello, I have a source with two smalldatetime fields, the first field contains 8/1/2006 12:00:00 AM, and the second field contains 8/10/2006 7:57:00 PM. I would like to have the date from the first field and the time from the second field. No chance of changing the source system to do this for me. What I have so far works, except the time portion is converted to 19:57:00 instead of 7:57:00 p.m. Any Ideas My expression is below. (DT_STR,2,1252)DATEPART("month",FIELD1) + "/" + (DT_STR,2,1252)DATEPART("Day",FIELD1) + "/" + (DT_STR,4,1252)DATEPART("Year",FIELD1) + " " + (DT_STR,2,1252)DATEPART("Hour",FIELD2) + ":" + (DT_STR,2,1252)DATEPART("Mi ...Show All

• SQL Server Date Picker formatting

  Im sure we have all seen this error before: "The value for the report parameter XXX is not valid for its type" I have a report (RS 2005) that has 2 date parameters, "start" and "end". My SQL in not very complicated at all, I have a simple WHERE date between @start and @end But when I go to view the report in VS2005, I get the above error. I am yet to find a decent fix for this, what is going on the date I am trying is: "26/02/2007" now, obviously its trying to us the en-US formatting, but im in Australia, so I want en-AU. I have changed my report Language setting to be en-AU, my local settings in Region Setting is English (Australia). (BTW, I had to change the Language setting in my report through th ...Show All