Simon Holywell

Posts tagged bikes

Suzuki Bandit Carburettor Clean

Suzuki Bandit in the snow

Suzuki Bandit in the snow

When I went away on holiday the other year I left my Bandit standing for about 3 weeks and it must of had a bad batch of fuel in the tank. The bad fuel turned into jelly in the carburettors and of course the bike started running like a dog. In the back of my mind I had thought I should drain the float bowls before leaving, but it got forgotten in all the excitement of the trip.

If you suspect you have left your bike too long and that the fuel will have turned to jelly do not start it.

Anyway so the bike now would not run a week after returning and I desperately wanted to ride so I stripped the fairings off, drained the fuel tank by pulling the fuel lead and opening the petcock, removed the fuel tank, removed the battery, pulled the airbox out and finally released the carburettors. This involved disconnecting the throttle cable, the fuel hose and the fuel overflow hoses not forgetting the choke cable of course.

Once you have the four carbies out you need to set about pulling the float bowl covers off and inspecting them and cleaning with carb cleaner as needed. Also pull out the pilot screw/needle remembering how many turns it takes. Pop the diaphragm cover and remove the rubber diaphragm checking for any problems. Don’t forget to hang on to the spring that is under the cover and remove the fuel flow needle.

Give it a good blast of carb cleaner and then blow out with compressed air and you should see gunk come flying out. Use further cleaner and air blasts for stubborn rubbish.

Carefully reassemble and attach to the motorbike in reverse order.

The following video illustrates this process fairly well (bare in mind it was not made using Bandit carbs so they differ slightly). Video

SQL Server 2005 Dump to SQL statements

Say you have a development environment setup using SQL Server 2005 Express Edition and your customer has a SQL Server 2000 database accessible only via ODBC and you can only run a DB import via a script. How would you do it? Easy you might think just run msdbdump.exe on the command line, well this isn’t MySQL so you are not so fortunate.

Backing up your DB is easy with SQL Server using the following commands:

http://gist.github.com/294721

But this just gives you a binary file that can be restored if you have access privileges to the live database for restoring. If you are in a shared hosting environment or one where the paranoid admins won’t give you remote desktop access and the only access you have is to run a PHP script to import the data and schema via SQL you will need to export the DB to T-SQL format.

Microsoft have a little program to perform this very function: Microsoft SQL Server Database Publishing Wizard 1.1 It is difficult to find on the web so I aim to save you the time I spent hunting for it. When you run the wizard make sure to set:

  • Drop existing objects in script to false
  • Schema qualify to false
  • Script for target database to SQL Server 2000

It does seem to chew on the cud for quite some time so grab a beverage.

Now for the PHP portion of the process. So you have uploaded your lovely T-SQL dump file to a PHP accessible location on your webserver and now you are wondering how to get into your DB via ODBC. Well you will need a PHP script like the one I have supplied below.

A couple of the complexities to be aware of before you continue. It seems that the T-SQL dump file comes out as UTF16 and we need it in UTF8 so you will need to convert it to UTF8 before you can import. I used a neat little function available from Modular.org for this purpose. This may or may not meet your needs. If you need a more accurate conversion method then I recommend you start your search with the PHP module/function mbstring . T-SQL contains reference and keywords that ODBC/MS SQL cannot understand. I have included some regex to strip these out.

My script is by no means perfect or factored down so feel free to make suggestions or improvements.

http://gist.github.com/294720

SQL SERVER

Say you have a development environment setup using SQL Server 2005 Express Edition and your customer has a SQL Server 2000 database accessible only via ODBC and you can only run a DB import via a script. How would you do it? Easy you might think just run msdbdump.exe on the command line, well this isn’t MySQL so you are not so fortunate.

Backing up your DB is easy with SQL Server using the following commands:

But this just gives you a binary file that can be restored if you have access privileges to the live database for restoring. If you are in a shared hosting environment or one where the paranoid admins won’t give you remote desktop access and the only access you have is to run a PHP script to import the data and schema via SQL you will need to export the DB to T-SQL format.

Microsoft have a little program to perform this very function: Microsoft SQL Server Database Publishing Wizard 1.1 It is difficult to find on the web so I aim to save you the time I spent hunting for it. When you run the wizard make sure to set:

  • Drop existing objects in script to false
  • Schema qualify to false
  • Script for target database to SQL Server 2000

It does seem to chew on the cud for quite some time so grab a beverage.

Now for the PHP portion of the process. So you have uploaded your lovely T-SQL dump file to a PHP accessible location on your webserver and now you are wondering how to get into your DB via ODBC. Well you will need a PHP script like the one I have supplied below.

A couple of the complexities to be aware of before you continue. It seems that the T-SQL dump file comes out as UTF16 and we need it in UTF8 so you will need to convert it to UTF8 before you can import. I used a neat little function available from Modular.org for this purpose. This may or may not meet your needs. If you need a more accurate conversion method then I recommend you start your search with the PHP module/function mbstring . T-SQL contains reference and keywords that ODBC/MS SQL cannot understand. I have included some regex to strip these out.

My script is by no means perfect or factored down so feel free to make suggestions or improvements.


Getting Back on the Bike

If you haven’t been riding through winter like me then take care getting back out there and wear good gear. Check all the essentials:

  • Oil
  • Water (if applicable)
  • Tyre pressures and wear
  • Chain tension and wear
  • Check all electrics (kill switch and all lights being the main ones)
  • Also have a glance at your sprockets

If the bike has been sitting for more than a month then you will probably want to drain the fuel tank as well as the petrol may have gone off. When you leave it too long it can form a jelly like substance in the fuel lines or worse in the carburettors. If this has happened or you forgot to drain your float bowls you will need to strip down the carbies and clean them out with compressed air.

Electrics corrode so if it won’t start check that the connections are OK on the:

  • Battery (you have already checked for charge right?!)
  • Kill switch
  • Clutch switch (if applicable)
  • Neutral switch (if applicable)
  • Kickstand switch (if applicable)

Biking to the UK

Just a few tips for fellow bikers who might be considering a move to the UK from Victoria.

If you only have your L’s pass you test before you come so you can transfer your licence over. When you have a full licence (ie over 21 with a restricted motorcycle licence) this will be transferred to a full A licence in the UK meaning you can ride any capacity bike you like. However insurance is going to set you back…it is significantly more expensive here.

To help reduce this cost make sure you bring a no claims bonus confirmation letter from your Australian insurer with you. This must state your NCB in years, your name, your bike and a policy number. The company will probably want to see the original so make sure you make copies before sending it through the good old Royal Mail. The only insurer that would accept my foreign NCB was Bennetts – you may find others.

NCB ratings are not taken from your car like they are in Australia so make sure you transfer any car NCB over to your bike before you come. 5 years is maximum NCB and it will make a real difference to your quote.

Before sending anything into the DVLA ensure you make computer scans or at least photocopies of your licence (both sides) and any other documentation. It could get lost in the post, but much more likely the DVLA will neglect to add your motorbike licence to the licence they send out to you!

When you receive your new licence immediately check it lists the correct categories. Another little quirk about licences here is that they come in two parts – it’s ridiculous but the plastic one like the one you keep in your wallet in Australia is not your actual licence. There is an A4 sheet of paper that must accompany it to be an official licence so don’t toss it like I was tempted to. This annoyingly means that if you are out riding and get pulled you will have to go into a cop shop to flash both parts of your licence.

If you decide to do some advanced/safer riding courses then I can recommend the BikeSafe scheme where you ride out with a police observer who gives you tips on your riding. This I found was very helpful as riding here is completely different and more hectic I found. If you do decide to do this course take the ones organised for London rather than the surrounding counties as the London courses are subsidised by Transport for London and therefore cheaper for the same service! They run one from the Ace Café to the North West of London and one from the Police Academy in Bromley to the South East of London in Kent. I attended the Bromley one.

To help boost my confidence I am also an associate member of the Institute of Advanced Motorists (IAM). I have only been to two observed runs so far but I can already feel I my riding improving and it is making riding more fun. They are very friendly. I am doing it through the London Advanced Motorcyclists (LAM) group who run sessions from Banstead and Bromley. Basically you attend a Potluck session and scope it all out and meet people. If you decide it’s for you then you join IAM and attend potluck sessions from there on in.

By the way you need to bring your bike (roadworthy condition of course), proper gear, your MOT certificate (if applicable), your insurance certificate and both parts of your licence to both BikeSafe and your first LAM potluck sessions. You should also bring an open mind and remember they are there to steer you in the correct direction – they are not going to force you to do something you don’t want to do. They are there to help you improve not attack your riding.

Triumph Street Triple

Yeah I know I am not that quick off the mark posting this up, but I have been admiring it for days. The new Street Triple is running a slightly retuned version of the Daytona’s 675cc triple cylinder engine. It also shares the same frame and swing arm as its much lauded super sport colleague from what I can tell. I have always loved the styling of the larger Speed Triples, but I am not keen to go to much over a 600cc until I have had more on road experience in this country. So this is the perfect compromise – it has the go of a Daytona (well nearly), looks fantastic and sounds great. I will be very tempted to trade the Bandit in come August and try to get one of these (I reckon there maybe a wait involved given the stir this bike is creating).

I have been hunting around the web looking for all the information I can find about the bike so I thought I would share it with you.

Triumph 675 rolling news article – Best photo for a desktop background I could find.

Triumph Street Triple site

VisorDown.com Article

London Bikers Article

Bike gets delivered.

Kevin tries to destroy it.

Carmichael at it again!

Yet more fantastic bike control.