JustCode : Update a sample record

This code shows you how to update a sample record from an MRS script.

Dim oConnection

' Start code to check if the field has data in it.
    Set oConnection = CreateObject("ADODB.Connection")

' Standard Connection String You need to change this
    oConnection.ConnectionString = "Provider=SQLOLEDB.1;Password=MyPassword;Persist Security Info=-1;User ID=MyUser;Initial Catalog=Participants;Data Source=MyServer"

    If ( oConnection.State = 1 ) Then
        oConnection.Execute("UPDATE TABLE1 SET Queue = 'Fresh' WHERE Queue = 'Completed'")
    End If


Set oConnection = Null

2×4 Data Collection Interviewer Server Backup Application

I have been on holiday for the last few weeks and during that time I managed to get some articles written. Whilst on holiday I was asked by 2×4 if I wanted to have a play with their backup tool and of course I excepted. This article is about that app and it shows you what it can do and how you can do it in the first release. To be honest , and I get nothing for saying this , I think this will turn into a “Must Have App” for all those users out there , and I know a few , that struggle with or do not even do backups. With a couple of clicks you have backed up a project or restored it. No Complicate procedures , just a few clicks and you are done. Anyway , here is what I did and the screen shots that go with it.

Read more2×4 Data Collection Interviewer Server Backup Application

What Hardware Part 5 : Complex Cluster Install

Now that we have seen a basic cluster setup , we should expand on it and show you how you can make your cluster as tolerant as possible. This article will talk about splitting out the tiers to different machines and highlight the advantages of doing this.

Read moreWhat Hardware Part 5 : Complex Cluster Install

What Hardware Part 4 : Simple Cluster Install

In this article we are going to talk about a simple cluster setup. If there was ever a setup that you should start with , this is the one. Whilst it may not be cheap as it uses 3 machines , it does begin to give you the redundancy that you really should have in a data collection setup.

Read moreWhat Hardware Part 4 : Simple Cluster Install

What Hardware Part 3 : Single Machine Install Seperate SQL

In the previous article we discussed the single machine setup and how fault tolerant a setup like that would be. This article will expand on the single machine install and discuss the advantages of introducing additional machines to the setup.

Read moreWhat Hardware Part 3 : Single Machine Install Seperate SQL

What Hardware Part 2 : Single Machine Install

So you need to buy some hardware to host a Data collection setup. You have no idea what you need so where do you start. This series of article will help you make some of those important decisions and get you thinking as to what your final solution will be.

Read moreWhat Hardware Part 2 : Single Machine Install

What Hardware Part 1 : In-House or Hosted

When it comes to deciding what hardware you want for your Data Collection Server setup there are lots of things that you need to consider. Once you have an idea on how many concurrents you will be getting we need to build a system that will cope with it. There are many network topologys that we can come up with and it really depends on what resources you have available to use.

Read moreWhat Hardware Part 1 : In-House or Hosted

Quick Question : What spec hardware should I buy?

Recently we where asked what spec hardware should we buy for our new Data Collection Interview Server setup, and we had to honestly reply we don’t know, but we know people that might have an in stite on some rules that they used. So … When you purchased your setup , how did you decide what hardware to buy? Did you use any sort of sizing calculator or was it just a guess?

If you did not use any sort of calculator, but have a setup in use and its working for you, what spec machines do you have , how many emails do you send out , and what is your response rate for WEB and CATI ?  How many questions do you have on average in your surveys? What does DimensionNet or Interview Administrator say your max con-currents are ?

We would love to hear from you be it from a comment on this article or a email to admin@smarterDimensions.com if you are willing to send us all your IVW* log files ( from all servers in the cluster )  then that would be great , we plan to run some articles on how we can write programs to read these and work out actual concurrency and then perhaps come up with a sizing calculator. So anything you send us will help us write a realy cool set of articles and scripts. We promise that all confidentiality will be kept and no names will be given as to whose setup is who’s

The Smarter Dimensions Team.

PS We cannot do this without your input !!

%d bloggers like this: