Kolf's Q&A profile

• SQL Server Problem with Updatable Subscriptions

  Hi all, I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg " Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this. There was also a recent QFE fixed to address a similar issue, but like Gary said, it depends on how frequently you're updating the same data at both ends. The QFE fix will make it into SP2, but if you need the fix immediately, you can call CSS. ...Show All

• Visual Basic Looping

  How do I setup a for next loop array to open files if I don`t know how many files are in the folder You could get an out of memory exception if the file you're trying to load is not a valid image file. Please check what kind of file you're loading before setting picturebox's Image property. Also, setting the pattern to limit the search to a certain extension could help: Dim folder As String = "d:\MyImageFiles" Dim pattern As String = "*.jpg" ... Andrej ...Show All

• SQL Server "login failed for user" message when executing a copy of a working package

  I notice when I copy an SSIS package 'A' to a new package 'B', the new package 'B' will generate a "login failed for user" message in the data flow components. To copy I "save copy of Package 'A' as." Some config info: Package ProtectionLevel = EncryptSensitiveWithPassword Connections are Data Sources Connection strings with password are stored using PackageConfigurations to an SQLServer table. I've verified Package 'A' is in fact using the config table (e.g. it is not using a password or user stored in the package) Data connectios are all SQLServer Native OLE DB Client The account is an SQLServer account (not integrated security) The original Package 'A' works flawlessly and I get success when I ...Show All

• Microsoft ISV Community Center Forums Office Communicator 2005 sign-in name, auto populate after install somehow?

  Does anyone know of a way to have the sign in name in communicator, auto filled in after an install or doing the install.. Basically every user has the same format.. first.lastname@domain for the login. I'd prefer to find a way to have this info auto entered after the install when it first tries to open. I'll be using communicator as a "broadcast" method.. and alot of users probably wont take the time to enter their info when I have it set to auto start/connect on windows start up. Thanks Very useful - thanks. I did see a post somewhere that suggested running: reg add HKCU\Software\Microsoft\Communicator /v "UserMicrosoft RTC Instant Messaging" /t reg_sz /d "%userna ...Show All

• SQL Server SQL Query - Fetching Records

  Have a table with following structure ID DeviceName Status 1 Sony Good 2 Toshiba OK 3 Sony Bad 4 Tata OK I need to return the following records ID DeviceName Status 2 Toshiba OK 3 Sony Bad 4 Tata OK If there are more than one record for the Device, then record with the latest ID should be returned. If there is only one record for the Device, then that record should be returned. Can this be achieved through a single query. Any help is appreciated. Thanks, Loonysan One way create table #test (ID int, DeviceName varchar(49), Status varchar(51)) insert #test select 1, 'Sony ', 'Good' union all select 2, 'Toshiba',' OK' union ...Show All

• Visual Studio Express Editions Error message "non-generic method" using ObjectDataSource and GridView

  Here is my process: (all with visual web developer 2005 Express, April version.) 1.  create new dataset in the app_code folder, called interaction.xsd.  (right-click on the app_code directory and select new...) a.  Step through the TableAdapter Configuration Wizard. b.  Select the data connection (ManagementConnection String (Web.config) c.  Create new stored procedures d.  sql statement "SELECT Interaction.* FROM Interaction e.  new stored procedure names:  InteractionSelect_sp, InteractionInsert_sp, InteractionUpdate_sp, InteractionDelete_sp f.  Fill method: FillInteraction, Get method:  GetInteraction g.  Checked Create methods to send updates directly... h.  I now have Interac ...Show All

• Windows Forms Validating a user with a Login Form

  hi everyone! need a winform that can validate a username and password. I had created a table that has the username and the password in it. the idea is to compare the text that is input onto the textboxes to the data that is stored in the table and if the username and the password are the same the login form will hide and then the principal menu form will me showen. I'm useing a sql server 2000 database and visual basic .net 2003. oh also need the posibility that the user can change his password as many time he wants. really need this!!! What part of all of this do you need help with Here are some general thoughts: 1) You can create a basic login form using the Login Form template in the Add New Items dialog. 2) You wil ...Show All

• SQL Server Add sum column to query

  What's the best way to include an amount sum in a query if I also need the individual amounts For example, I need the following columns: order number order amount total amount I tried using "with cube ", but the total number of columns in the query exceeds the allowable limit of 10. stephane - Montpellier wrote: sorry, i made a mistake... SELECT a.ordernum, a.orderamt, b.totalamt FROM orders a inner join (select sum(orderamt) from orders) b on a.ordernum= b.ordernum I thought inner join could be more efficient than using where statement... Your statement won't work there either. You didn't include ordernum in your subquery. Never-the-less, inner join and the join method I used are identical. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. MessageBoxes

  The first thing I tried to do when playing with the XNA framework was try to handle the "NoSuitableGraphicsDeviceException" exception to prevent a crash on the end-users machine. In the older MDX version of my game, I had code similar to this: ClientEngine engine; try { engine = new ClientEngine(); } catch (NoSuitableGraphicsDeviceException exception) { GameConsole.Write("Exception: " + exception.GetType().Name + " (" + exception.Message + ")", ConsoleMessageType.Error); GameConsole.Write("Current video card or drivers are not supported."); MessageBox.Show("Your current video card or drivers are not supported.", "Error Initializing Graphics Device", MessageBoxButtons.OK, MessageBoxIcon.Stop); ...Show All

• SharePoint Products and Technologies SPS2007 and Workflow. What's wrong?

  I installed SPS2007 6 times on new instance of 2003 server. Everything works except workflow. I assigned document to approve or feedback to another user. BUT another user can not see this in tasks. If I assigned this file to myself - I see tasks but nobody also when I create workflow for other people. HELP!!! Thanks ...Show All

• Visual FoxPro report with users parameters

  Scenario: ->FoxPro 7 ->1 remote VIEW - called view2 -> 1 form -> 1 report bind to VIEW I have a form and a report and I want that the report shown just customers that are of United States and U.K (for example) . This form have checkboxes with countries names and a variable called xOptions ( that store the options of user) Before shownn the report I want that the user select a checkbox and see just what he selected into the report. Below the code in the procedure INIT of Dataenviroment . SET FILTER TO &xOptions FILTER(&xOptions,view2) How I make it This code don't work! Thanks How I make it This code don't work! After you set or change a filter you must move the record pointer in o ...Show All

• Visual Basic sorting the files in a folder

  how to sort the files in the folder according to the date modified/written i am getting the file (code snips) Dim dDir As New DirectoryInfo(pathIssueFile) Dim fInfo As FileInfo() fInfo = dDir.GetFiles("*.txt") is there any methods to sort the files [according to the file modified ] while Getfiles.. or any other methods.. avilable.. thanks in advance..... Textbox1 and Textbox2 are simply leftovers from a test and shouldn't be there. The usage of the FLArraySorter becomes - Dim DirInf As New IO.DirectoryInfo( My .Computer.FileSystem.CurrentDirectory) 'Set an appropriate directory the My nnamespace is dotnet 2.0 Dim fls() As IO.FileInfo = DirInf.GetFiles() Dim Sorter As New FlArraySorter Array.Sort(f ...Show All

• Visual Studio Team System Load Testing with Unit Tests. Iterations.

  Hi I am conducting load tests using unit tests as we need to test a non-http based application. One of the things that I need to do is have users go through a sequence like: 1. Logon. Aquire a resource. 2. Repeated data-driven action using the resource. 3. Logoff. Cleanup the resource. I dont know if I am going mad or something but this seems incredibly difficult in VSTS. My issues are: 1. Each iteration of a test results in a new instance of the test class hence resources cannot be kept as member variables. 2. I cannot find a way of distinguishing between a new iteration and a new vuser so I cannot use some kind of Singleton to keep hold of my resources. 3. The databinding does not support multi-iteration type stu ...Show All

• Visual Basic ADO.net dataadapter.fill

  Hi, I have two tables in my database: tb1 and tb2. tb1 will be inserted into tb2 with these conditions: 1.) if primary key to be inserted is already existing in tb2, then the data in tb2 will just be updated using values of tb1 2.) if primary key to be inserted is not yet existing in tb2, a new recorded will be created in tb2. I used a dataadapter to fill the datatable and a bindingsource. Also, I used execute non-query command to insert/update the data in tb2. everytime i update/insert a record in the database, my datatable still contains old table records (it doesn't have the data i inserted and contains old data before updated). in this case, i have to issue another da.fill(mydatatable) to refresh.... which is so slow espe ...Show All

• SQL Server Strange Query Behaviour

  Hi, I am seeming strange results with a query. I have two tables, lets call them Table1 and Table2. Table1 has an ID field, Table2 does not have an ID field. To be sure I wasn't blind, the query 'SELECT ID FROM Table2' returns: Invalid column name 'ID'. OK. Now when I run the query 'SELECT * FROM Table1 WHERE ID IN (SELECT ID FROM Table2)' it returns all the records from Table1. What gives Is this a bug, or am I missing something Hi, I got it thank u....! But why the result is "no rows selected" when table2 is empty. Even if it considers table1.id in select id from table2 , it has to retrieve all the ids right!! Otherwise it should rise an error saying that id not ...Show All