Here is the string:

ADOCONN='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=password;Initial Catalog=databasename;Data Source=sqlservername'

I used tags in the initial post and these were most probably rejected.

I have also set the server to use mixed...