CJSingh's Q&A profile

• SQL Server Problem with Context Switching feature in SQL 2005

  Hi, One of our client application launches a execuatable on server by calling master..xp_cmdshell. We are migrating to SQL 2005 and I would like to use the Context Switching feature We have sql login “client” which is used by clinet application and has very least privelge and have only required access to requried database and tables. xp_cmdshell is disabled by default on our server and I would like to enable xp_cmdshell, launch the executable on the server and disable xp_cmdshell . I have created another SQL Login “Bob” and is member of sysadmin. The below SP is created by logging in as “Bob”. My objective is to grant execute access on this SP and grant impersonate access to sql login “client” . So that client ...Show All

• Visual Basic Display Same Object In Different TabControl Page

  Currently i have one databasegridview in tab page1, how can i bring this databasegridview to the other tab page Thank you. This first example is for when you add the datagridviews during the designtime. There is a TabControl with 2 pages, DataGridView1 on TabPage1 and DataGridView2 on TabPage2. Notice how the event sub is set to handle events from both datagridviews by listing them after the 'Handles' keyword at the end. If a column's width is changed on DataGridView1 or on DataGridView2, then the event has code to update both datagridviews so the layout will look the same on both datagridviews. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3d Model Rotation Problems

  This Post Has Been Edited.  I have created several posts regarding my games many problems so i have deleted the contents of this post to avoid confusion. any help would greatly be appreciated and comments as well as suggestions would be nice. Find the links on the below post for my game. Thanks to all Peter Chantler. You can right click modelRotation and hit "Find all references". Then you can see everywhere that modelRotation is being changed. However, the code you posted isn't very useful to us when we're trying to help. You seem to have run into many problems doing this program; I've seen multiple threads about the same go kart/track problem. Perhaps you should start with some basic tutorials ...Show All

• Visual Studio Team System Plans for Work Item Hierarchy?

  In reading the "MSF for CMMI Process Improvement" Process Guidance is says "If a change request is accepted, it is used to generate tasks to implement the change." We plan on following this guidance closely and for the most part think it will work fine. The one issue we see is, a Change Request can be closed with out it's Tasks being finished, giving false impressions to our over caffeinated project management team. Ideally we'd like to have a hierarchy so that a Change Request stays "Active" (or in an Implement state in our case) until all it's children tasks are complete. I know this is not possible now (at least with out a lot of customization), but is a work item hierarchy (specifically change req ...Show All

• Visual C++ Syntax for Overriding IListSource -Managed C++

  I am having trouble with the syntax for overriding IList source in managed c++. Especially, how do you override the public ref class StopListSource : Component, IListSource { private: static BindingList<String^>^ blah = gcnew BindingList<String^>(); public: StopListSource() {} StopListSource(IContainer^ container) { container->Add(this); } //***The Following generates: a member using-declaration or access declaration is illegal within a managed type IListSource::ContainsListCollection { get { return false; } } //Not sure about the following, but it doesn't throw any errors //in C# this is: System.Collections.IList IListSource.GetList() , but in C++ this is old syntax ...Show All

• .NET Development Exception: DataTable internal index is corrupted: '5'. on ...

  Hi, I have a problem with bindingsource component in framework 2.0. I have a combobox bound to a bindingsource which is also bound to a dataset with 2 related tables and a datagridview bound to the same bindingsource. What I want to do is : When the selectedindex property of my combobox changes, the corresponding cell value must be changed in the datagridview. But although the value in bindingsource changes, datagridview does not display the new value. That value is displayed after I move the mouse over that cell and make it invalidate its region manually. Another error I caught is the one that you can see as the subject of my post. I do not know why i have that message when I try to change the property of ((DataRowView)mybindi ...Show All

• Visual Studio Express Editions MSWinsck.ocx License

  Can anyone help me retreive my MSWINSCK.ocx license key... Because this is needed to run my program on other computers who don't have VB 2005 EE installed. And can anyone ( if i don't find it out myself ) tell me how i register it on the other computers. if it helps, I found this page , but my compiler doesn't recognize "Licenses" in the command line " MsgBox(Licenses.Add("MSWinsock.Winsock")) " And the program in the zip file doesn't show me my license key. The OS I'm running: Windows XP Service Pack 2 Microsoft .NET Framework 2.0 And the destination pc's are going to run the same. Thanks I found it already. You just have to export the registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Lic ...Show All

• SQL Server Data-Driven Subscriptions

  Hi I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine. Any help, comments, or even suggestions will be very welcome. Kind Regards Carel Greaves Unfortunately these logs are not what I asked. This is from the webserver log, but subscription execution error if any gets written into the RS windows service log file named ReportServerService__<timestamp>.log. Also you don’t need to copy the whole log file contents - find entries (by timestamp in each entry) where you expect subscription to fire and copy entries with errors if any are present. ...Show All

• SQL Server Serious error in RS licensing docs on MS web site

  Correct me if I'm wrong... There is a potentially costly error in at least 2 Reporting Services 2005 licensing docs on Microsoft’s web site. They fixed the docs a few months ago after I called and told them about it but, now they are bad again! Here are links to the bogus docs: http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx Both of these docs say that you need 2 SQL licenses to run Reporting Services 2005 on a separate server from the SQL engine. This is not true. You only need 1 license! You do of course need the correct number of CAL's or a CPU license. The license.txt file that ships on the SQL Server 2005 standard edition ins ...Show All

• Visual Studio Express Editions Rotating text on output of printer?

  Hi! I am making this small application for my company that is basicly just for filling out a pre-printed form. Here's what i use to do the printing on the paper Ah, I have tried to play around with all kinds of different settings. But it seems like if i change for example e.Graphics.DrawString(TextBox2.Text, TextBox1.Font, Brushes.Black, New System.Drawing.RectangleF(65, 137, 74, 20)) to e.Graphics.DrawString(TextBox2.Text, TextBox1.Font, Brushes.Black, New System.Drawing.RectangleF(665, 137, 74, 20)) And set the printer to print in landscape mode, i don't get anyting printed on the paper. The printer acts like its going to print but it's just blank. If i set the y-parameter to a lower number it prints, ...Show All

• Visual Basic Culture date format and system dat format conflicting

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july I'm using MS ACCESS2003. I'm using Insert statment insert into tbl1 (testdate) values ('"& date.now &"') so, how can I know what is the culture of the database ...Show All

• Visual Basic How to debug a Windows Service built with Vb 2005?

  Hi everyone, I’ve installed that service by means of installutil.exe and then started with Service Manager. But from the IDE I trying to attach that process from Debug option but it doesn’t appears. Why Let me know where am I failing. TIA It's already solved I was looking for the same name as service instead of process...   Pre and post build events too. Is different from VB Thanks anyway. ...Show All

• Visual Basic SerialPort Datareceived event

  I've got a problem with the serial datareceived event. Since i want to program OO i divided my program into classes. So I made a seperate class for the communication with the serial port and a seperate class for the form where i want to display the data. But now the datareceived event does nothing. Can enyone help Before i seperate the code it worked. Imports System.Object Public Class Communication Private Shared WithEvents serialPort As New IO.Ports.SerialPort Public Shared Function Look_Up_COM_Ports() As String() Dim COM_Ports(My.Computer.Ports.SerialPortNames.Count - 1) As String For i As Integer = 0 To My.Computer.Ports.SerialPortNames.Count - 1 COM_Ports(i) = My.Computer.Ports.SerialPortNames(i) N ...Show All

• Windows Forms Retrieve Object from ListBox

  I've got a OleDBDataReader object whose values I want to store in a ListBox for user interaction. The values I'm storing in the ListBox are the users first and last name (this is the displayed values). And I'm storing in the ListBox the users Social Security Number. I have done this by way of creating an object: class ListBoxStorage { public object data; public string display_string; public ListBoxStorage(object data_stored, string display_val) { data = data_stored; display_string = display_val; } public ListBoxStorage() { display_string = "Empty String"; } public override string ToString() { //MessageBox.Show("User " + display_string.ToString() + ", has the SSN of: &qu ...Show All

• Windows Forms MULTISELECT ON OPENFILEDIALOG

  I have an open file dialog on a form, and have the multiselect set to true, but I can still only select one file at a time. Any ideas Larry Hilley Thanks! That was not the problem bu it made me see the what I was doing wrong! I had droped the openfiledialog on my form and had set the multiselect property. But when I went to use the openfiledialog I declared a new one with the same name! So the one I was using was not the one I had set up on the form. I gpt rid of the new statement and all worked as it should. Thanks again. Laryy Hilley ...Show All