Sql Server Connection in Dreamweaver

Hi there

I was wondering if anyone could point me in the right direction or had come across my issue before. I have recently moved some content to Winhost including the databases for a number of sites. I managed to get everything working as expected in the live environment using the connection string:

"Provider=SQLOLEDB;data source=XXX.Winhost.com;Initial Catalog=DB_XXXX_lmciti;User ID=DB_XXX_lmciti_user;Password=XXXX;Integrated Security=False;Language=British English;"​

When I go into Dreamweaver CS6 and try to view the databases or indeed test the connection string I get the error message:

Multiple-step OLE DB operation generated errors. Checkeach OLE DB status value, if available. No work was done.
​

I'm not sure what to change as the exact same connection is working on live sites.

Any ideas or suggestions?

Thanks in advance.