DBCC TraceOn error

If you happen to be using Microsoft Query, you may receive the DBCC TraceOn error and the following may help.

BAD

'strCn = "Provider=MSDASQL; DRIVER={SQL Server}; SERVER=[dbservername]; UID=[userid]; Pwd=**********; APP=Microsoft® Query; DATABASE=[dbname]; Trusted_Connection=yes; "

GOOD

 strCn = "DRIVER=SQL Server;SERVER=[dbservername]; APP=Microsoft® Query; DATABASE=[dbname] ;Uid=[userid];Pwd=******************;"