exp2000's Q&A profile

• SQL Server Job Hang

  Hi, I am running the following TSQL command and it hangs. These commands are running from SQL 2000 server and it is querying information for SQL20005 database. Running simple EXEC command work fine but running using Insert hangs. Set @Cmd = @ServerName + '.' + @dbname + '.dbo.sp_helpntgroup' Print @Cmd Insert into dbo.DBSecurity ( NTGroupName, NTGroupID, SID, HasDbAccess) Exec (@Cmd) Any idea, Is the SQL Server 2005 server configured as a linked server or remote server If the SQL Server 2005 server is configured as a remote server and SET REMOTE_PROC_TRANSACTIONS is ON/the option is set then the insert...exec will start a distributed transaction automatically. So depending on your network configuration a ...Show All

• Visual Studio Express Editions Help Needed

  I have made a web browser but i don't know how to make it the when im using that web browser and i click open in new window and it opens a new web browser form the same program and wont open a new windows explore brorowser. Can anybody help me Ow, Very sorry about that. Let me try again. When you right click in any web browser, But in this case the one I made, You get a list of things that can be done such as, If it is a link it will give you "open" or "open in new window" and so on. When I run my browser it works all fine and dandey exept when I right click on a link and select "open in new window", When I click that it opens up a new Internet Explore Browser but I dont w ...Show All

• SQL Server HELP problem with roles.

  hi again to every one. well i run the report serve on local and my company has a network. to test the security i deployed reports to the local reports server and i gave browser capabilities to a computer of my local network. knowing the US/pass, i execute the Internet explorer from my post but with the account of my network(execute as...). well when i enter to report manager (//<server(local)/reports>) i can notice the limited choices on the manager but when i go to run a report it tells me that either the user (the foreign user)cannot access the OLAP database or the database does no exist(impossible). how can i fix this problem thank you a lot It sounds like you have an issue passing the p ...Show All

• Windows Forms DataGridView getting index of the entering row

  I have a DataGridView with say for e.g. two rows. User currently have selected the row 1 (index 0)..when they select the next row what event should I use to find the next row's index (row 2 index which should be 1)  I tried using RowEnter event of the datagridview along with MyDataGridView.CurrentRow.Index which is giving me the index of the first row not the entering  second row. To find the next row *when* a user selects a row you could try, assuming your DataGridView is called dataGridView1: if (dataGridView1.SelectedRows[0].Index + 1 < dataGridView1.Rows.Count) { int nextRow = dataGridView1.SelectedRows[0].Index + 1; } It might be a cheap styl ...Show All

• SQL Server How to edit rsreportserver.config to configure SimplePageHeaders

  Hi! I want to set SimplePageHeaders to true, but I'm not sure how can I do it. What is the format I should use, and where should I put it Thank you! How to set default rendering options: http://msdn2.microsoft.com/en-us/library/ms156281.aspx Excel format options, including SimplePageHeaders: http://msdn2.microsoft.com/en-us/library/ms155069.aspx Sample: <Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> <DeviceInfo> <SimplePageHeaders>True</SimplePageHeaders> </DeviceInfo> </Confi ...Show All

• Visual Studio Listing of all MSB errors

  Hello, I am new to msbuild and encountered errors in the cmdline that are not in the .NET Framework 2.0 SDK and I wanted to know if there is a list of them all someplace. Thanks! (Hi Jaysh!!) Hi Dan. Thanks for the response. I am not looking for any error in particular, just the 4xxx ones. It would be nice to know what to look for when it happaens rather than scratch my head and post a message. :) -Caolan O'Domhnaill ...Show All

• Visual Studio Team System Exception thrown when executing unit test

  I have VS2005 Team Edition. In my test, I am creating an instance of a class that I intend to test. When I execute, the 'new' statement throws an exception: Test method UnitTest2.UnitTest1.TestMethod2 threw exception: System.TypeInitializationException: The type initializer for '<Module>' threw an exception. ---> <CrtImplementationDetails>.ModuleLoadExceptionHandlerException: A nested exception occurred after the primary exception that caused the C++ module to fail to load. ---> System.Runtime.Serialization.SerializationException: Serialization error.. The assembly containing the class does have a reference to a C++/CLR (interop) project. When I modify the experiment to instantiate a class in the interop project, I ...Show All

• .NET Development Disposing example

  Hi, Can anyone please help me check if the disposing method that I have built is correct I am having a difficulty to create a class wrapper. Please let me know if my code is not verbose enough. Thank you Public class Test Implements IDisposable Private reader as StreamReader Private writer as StreamWriter Private cmd as SqlCommand Private disposed as Boolean '-- constructor code, public method ,etc -- public sub Close() If Not IsNothing(reader) then reader.Close() If Not IsNothing(writer) then writer.Close() End Sub public sub Dispose() Implements IDisposable.Dispose Dispose(True) GC.SuppressFinalize(Me) End Sub Protected Overridable Sub Dispose(disposing as Boolean) If Not Me.disposed Then I ...Show All

• Visual C++ Unable to debug: "The breakpoint will not currently be hit. No symbols have been loaded for this document."

  Hi, This is the forst project I compiled with VS 2005 and I got this error when I tried to debug. The PDB is in the same folder as the executable though and the project was set to "Debug". What did I forget Thanks for your help. You can use the "Modules Window" to investigate PDB load issues. Just look for your DLL/EXE there and verify that the path is correct. Does the list entry say that symbols have been loaded If not you can right click and select "Symbol load information" (IIRC). In most cases (at least for me) it's just a mismatch of EXE/DLL and the PDB because you forgot to copy the DLL. If the symbols are loaded correctly, try setting a breakpoint via a funct ...Show All

• Smart Device Development SqlException while trying to establish(open) connection to SQLServer 2005 from Pocket PC2003

  Hi I have same requirement to connect from PPC to SQL Server 2005. I have installed VS.NET 2005, SQL Server 2005 Deverloper Edittion, Active sync 4.2. When I run application on emulator, I am getting sqlexception saying that SqlServer Doesn't exist or authentication failed. Error occuring while opening connection to sqlserver. Do I need to install any other s/ws. I went through help in MSDN forum ( http://netcf2.blogspot.com/2005/12/accessing-sql-server-express-from.html ), but didn't work. I verified port etc, those are okay. I haven't install any emulator, working on default emulator comes with VS.Net 2005. I used the following code. I have doubt like, application runs on emulator, how the connection established to sqlserver. Do I nee ...Show All

• Visual Studio 2008 (Pre-release) LINQ and MySQL

  will i be able to use LINQ with mysql server database Yeah, it's possible! Remember Linq Over DataSet! You can use the MySql data provider (System.Data.dll) to load a dataset and use Linq Over DataSet to query the DataSet. For example, using MySql.Data.MySqlClient; using System.Data; ... MySqlDataAdapter adapter = new MySqlDataAdapter("select query", "connection string"); DataSet ds = new DataSet(); adapter.Fill(ds, "query resultset name in dataset"); /* Query the dataset using Linq. */ ... However, we have to wait for MySql Ab to provide a query processor that knows how to convert Linq expressions tree to Mysql server compatible sql syntax. They know their tool (the server) be ...Show All

• SQL Server Displaying Multi parameter info : Report builder

  Hi All, Is there is any way to display the User selected parameter information if the parameter is multiselect I was able to display if the parameter is single valued but if it is multivalued (list), i was not able to . Any help is greatly appreciated. Regards, Thanks Bala, This was really helpful. We wanted to use the output of the Parameter!Dimention.Value array for custom filter description which is easy to understand... placed under the report title. Here's what we are using =REPLACE(cstr( "Dates Aggregated: " +JOIN(Parameters!DateYearMonth.Value, " ; " )), "[Date].[Year - Month].[Year].&" , "" ) This goes throu ...Show All

• Visual Basic Redirecting Processes's StandardOutput! Need a help here.

  Hello VB developers! I got a problem redirecting processes's standardoutput! I'm trying to put all the output of a console application in a textbox in my project, but I can't! =/ I have developed this code in Visual Basic .net 2003 to do it: Dim Proc As New Process Dim pInfo As New ProcessStartInfo(Textbox1.Text) 'In text1.text I got the file path pInfo.UseShellExecute = False pInfo.RedirectStandardOutput = True Proc.StartInfo = pInfo Proc.Start() Textbox2.Text = Proc.StandardOutput.ReadToEnd() But I think nothing is changed in the textbox. Hugs! Yeah. I think you're right! Thanks guy, I'll make changes in my project and test it, by the way, I'm marking your posts! Hugs. ...Show All

• Visual Studio Accessing parent project from invoked child project

  When a project calls msbuild on a child project - is there any way to access anything in the invoking/parent project Is there any way to determine the project filename, or anything about the parent project This could be either via the msbuild XML or from a custom task, ie via the object model. I've been looking at the object model and at the internal classes but haven't found anything appropriate. /marcus Hi, There is currently no support in MSBuild to gain access to information like project file name of the parent project (invoking project) from a child project. The only way for a child project to get information regarding a parent process is if the parent project passes properties to the child proj ...Show All

• Visual Studio Express Editions ListBox

  I am creating a movie database program and am trying to create it so that the movie titles are displayed in a listbox on the right and the rest of the info in boxes on the left. I connected up the listbox to a databinding source and selected the displayMember and valueMember accordingly, everything worked. But when I went to add movie titles in the database in a field on the left, save, then go to another movie title, the data was changed to a number. Can anyone help the listbox and the rest of the fields retain the info. I am a complete newbie, so could you explain what to do step-by-step. Thankyou for all your help! Elliott the table is a datatable from my database. The datatable is called "Movie" And belongs to ...Show All