>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;
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.