Thanks for your help everyone. It is working now, hooray!!

I checked the firewall log & found lots of DROP UDP entries coming through so started fiddling. It seems...

hmmm, I tried changing 'Data Source' to 'Server', as well as trying 'Database' instead of 'Initial Catalog' and 'Uid' instead of 'User ID'; none of these made a difference. ...

Hi Ian

Thanks for that, I wasn't aware I needed to install this. I've now done so and changed the connection string's Provider to include 'sqlncli' instead of 'sqloledb' (was...