Alex_ludy's Q&A profile

• SQL Server Errors with combined use of transactional and merge replication - SQL2005

  I am investigating the feasibility of a configuration with 3 databases on SQL2005 DB_A is an OLTP database and serves up transactional publication pub_txn - with updateable subscriptions DB_B is a subscriber database which subscribes to pub_txn DB_B is also a publisher which serves up merge publication pub_merge DB_C is a subscriber database which pulls pub_merge =============================== Updates on DB_A are successfully replicated to DB_B Howvever, when DB_C pulls updates, it doesn't find the update sent to DB_B =============================== Updates on DB_B are successfully replicated to both DB_A and DB_C =============================== Updates on DB_C initially failed with the error Msg 916, L ...Show All

• Gadgets Automation

  I have a gadget that calls a .net library that is registered as a COM object. It works fine when UAC is turned on but it fails when UAC is turned off. This seems the opposite what I would have expected. I marked the dll as Safe for Scripting but that didn't make any difference. Any Ideas How does it fail Does it get killed by DEP, fail to run or result in a security error. Have you tried running it from an HTA, instead of a Gadget, to check there's no error ...Show All

• Visual Basic Help with Sorting List

  Ok so i have a generic list of a structure. Dim Lst as new list(of mystructure) How would I sort it randomly Public Sub Shuffle(Of T)(ByVal x() As T) Dim rnd As New Random For i As Integer = 0 To x.Length - 2 Dim j As Integer = rnd.Next(x.Length - i) + i Dim temp As T = x(i) x(i) = x(j) x(j) = temp Next i End Sub The catch with using the Random class is that it can only generate 2^31 unique results at the most, and for lists of considerable length, (13 items or more), some shufflings will never be generated. If you absolutely have to make every shuffling outcome possible, you will need a different Random number generator. ...Show All

• Visual Studio Debugger looking for CRT0.C

  Hey guys, When I'm running my debugger, I am getting a strange problem that keeps occuring. If I click run, the debugger follow throughs the whole source code and gives me an access violation of 0xC0000005. If I do a run to cursor, then I am forced by the debugger to provide the location of CRT0.C. The program runs fine without the debugger, just doesnt output the correct results. Would anyone know the reason for that Thanks Robbie It sounds like you have an access violation somewhere in your code. I believe crt0.c is the source for winmain. It's probably where the access violation is being caught. Did you try handling exceptions as they are thrown (Under Debug | Exceptions ... and then pick access violation under Win32 Exc ...Show All

• .NET Development Error .Net SqlClient Data Provider when running a SQL Job

  Event Type: Error Event Source: .Net SqlClient Data Provider Event Category: None Event ID: 0 Date: 19/09/2006 Time: 12:41:57 User: N/A Computer: Description: A severe error occurred on the current command. The results, if any, should be discarded. Job 'Update Shared Data from CM' started successfully. running a stored procedure which executes sql to quick off a sql job on another server (provides it with the remote servername as an input parameter. Stored Procedure Code as follows --set ansi_nulls on --go --set ansi_warnings on --go @strLiveServerName nvarchar(30) as DECLARE @strSQL nvarchar(500) SET @strSQL = "EXEC [" + @strLiveServerName +"].msdb.dbo.sp_start_job N'Update F ...Show All

• SQL Server =Globals.PageNumber & " of " & Globals.TotalPages

  how do i get pagenumber and total pages when i try to put on the page header i get error: =Globals.PageNumber & " of " & Globals.TotalPages error: [rsPageNumberInBody] The Value expression for the textbox ‘textbox17’ refers to the global variable PageNumber or TotalPages. These global variables can be used only in the page header and page footer. Build complete -- 1 errors, 0 warnings any help please The error message [rs PageNumber InBody ] clear mentions that you are using the Global Variables in the body of the report layout. ...Show All

• Visual Studio 2008 (Pre-release) Difficulty installing .NET 3.0 on Windows XP

  I'm trying to get .NET 3.0 working with VS 2005 so that I can use WPF. I've followed the instructions at: http://msdn.microsoft.com/windowsvista/downloads/products/getthebeta/#runWinFXApps I've installed on two machines - one a clean Windows XP machine - without any luck. The installation order has been: Visual Studio (already on both machines), Net 3.0 and then the SDK. No additional project types are shown in VS after install and an attempt at installing Orcas results in the error message that .NET 3.0 isn't installed. Any suggestions mikej Ive done .NET Framework 3.0 RC1 and Windows SDK RC1 on two machines - one a clean install of Windows XP SP2 with nothing else ...Show All

• Visual Basic Problem using a data bound combo box

  (I'm using VS2005) Instead of using a bindingnavigator, I'm setting one field as a databound combo box with the display member and selected value set to the field. Then the other fields are text boxes and change based on the selected value of the combo box. The problem is that when I run the app, the form won't close. Why does this happen and what can I do to make the form run appropriately Thanks. Not knowing the exception you are getting, I am only speculating, but you may want to check the order in which your controls are being disposed. I have found instances where a control is disposed prior to the binding source which still holds a reference to it. Try disposing your binding sources explicitily ...Show All

• SQL Server Reporting Services Configuration (Database Connection)

  Hi, I want to configure my Reporting Service. And if I want to configure the Database Connection I the action "Create a Grants Rights Script" fails. I tried all credential types by it doesn't work. Does anybody have an idea Thanks for your help! Jo-Jo Are there steps to replicate this issue What is the error message Does the SQL Reporting Services service account have access to the database this may help. http://support.microsoft.com/kb/264697 cheers, Andrew ...Show All

• Visual Studio Team System Setting default WorkItem field values during creation of New Team Project

  Hi, I've created a creation wizard that will gather information from the user when they create a new team project. I'd like to be able to set some fields of work items when they are created to the values that were entered in the wizard during project creationg. For example, during the wizard a user will enter the project category along with name. Each bug entered will also have the project category saved in a field that is also a dimension. I don't want the user to have to enter the project category when entering bugs. Is there any way to get the information from the wizard back into the Team Project XML Or some way to change the Process template tasks lists during project creation to have the custom field default to a certain va ...Show All

• SQL Server Running the package through C# UI

  one more guidance needed with regard to the Quotation marks path = @"D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"; jobCommand = new SqlCommand(@"xp_cmdshell 'dtexec /f "'path '" /Set \package.Variables[User::ArchiveFileType].Properties[Value];""Excel""'", cconn); How Do i set the path's value in c# the quotation marks are wrong again. cos i want to set value of path according to selection in the UI. Select("deviceUniqueId = '" + deviceUniqueId + "'"); is an e.g of Doing in C# but when i implement it through text it does not recognize Thanks Jas Hi! Thanks For your reply! but this is ve ...Show All

• SQL Server Problem in executing xp_cmdshell with Least Privileged SQL Login account in SQL 2005

  Hi, I have a least privileged SQL Login “Client” and have granted execute rights on XP_Cmdshell SP at master db. When I execute master.. XP_Cmdshell ‘dir’ I’m getting the below error. Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1 The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information. Please note it is SQL Login account and not windows account. I have checked everywhere for similar problem and no luck. Thanks for you help in advance With regards GK See my reply to your other related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1157356&am ...Show All

• Visual Studio passing session parameters - newbie question

  hey guys, another newb question for ya.   ok got a report viewer control on 2.aspx - local mode links to a .rdlc and connects to a orcale Connection String and everything im doing is in VB.   Next i got 1.aspx webpage with 2 fields. DATE1 and DATE2.  When the user hit the generate button I saved the inputs into Session("DATE1") and Session("DATE2") and postback to page 2.aspx.    Next i verify 2.aspx picked up on the 2 session variables I made and it does.  Now I want the report to display ONLY my fields in the report table which are in bettween the dates selected.    What is the best way to go about this or can anyoine give me a link to somewhere that explains passing session ...Show All

• Visual Studio Express Editions Query generator

  Hi Friends, i want to develop a query generator in vb8, how can i go about it. i want it to be a stand alone sw so that i can load it with any database and gnerate the data and then be able to print that data. thanks in advance Rajnesh how exactly do you mean a query generator As well as this, in order to run .NET applications, you NEED to have the appropriate .NET Framework installed on the computer you wish to run the application from. ...Show All

• Visual Studio Express Editions Checking dropdown box for no values

  I have a dropdown box that is created from SQL if no values are returned I want to insert four zeros "0000". I have tried a couple of ways and they dont work at all. The program just gets stuck. Here is what I am working with, thanks for any advice: TxtDept.Text = Me .ComboBox1.SelectedValue Me .Cursor = Cursors.WaitCursor ' CHANGE CURSER TO A WAITING CURSOR THEN DO WORK Dim connectionString = "Data Source=localhost;Initial Catalog=TESIS;User ID=sa;Password=password" Dim theDataSet As New DataSet() Dim theSqlCommand As New SqlCommand( "Select [DIV_ID],[BUD_ID] from [FR_BUDGET_DIV] WHERE DIV_ID = '" & Me .ComboBox1.SelectedValue & "'" , New SqlConnec ...Show All