Thanks Boris,

it worked a treat.

~M

>>Hi all,
>>
>>we had an application that connection to a db fine and update some tables. the server moved to the cloud and it stopped working. Some settings were changes on the server, names etc. and I have allowed for these but the connection string won't work, any ideas?
>>Old connection string
>>

>>Driver=SQL Server;Server=SERVER01\scanning;Database=Scanning;uSER iD=user1;Password=Password1;Trusted_connection=yes
>>

>>New connection string
>>

>>Driver=SQLOLEDB; Data source=SERVER99\scanning; Initial Catalog=Scanning; User id=user99; Password=Password99; Integrated Security=SSPI
>>

>>If i use the SQL manager setup I can log into the new server using the username and password and SQL authentication.
>>~M
>
>Old connection string is ODBC connection string.
>New one is OleDB (ADO) one.
>You could try with this:
>

>Driver={SQL Server}; Server=SERVER99\scanning; Database=Scanning; UID=user99; PWD=Password99;
>