Thanks very much John, using sqlsetprop with a connection handle of 0 did the trick. That's great because I can carry on using connection strings which I'm holding in an INI file. Your help is much appreciated!