Try doing this in stages. Before you even worry about the connection string, get the database working. Before you even get ODBC working, get the PCC working.
To get the PCC working, start it up on the workstation and right-click on Engines and select New Server. Enter the server name & click OK. Does it connect? If not, then the server name may be wrong, you may have a DNS problem preventing you from finding the server, the engine may not be running on that server, or a firewall may be blocking your access to the database.
If you can connect properly, you should see a list of databases there. Do you ONLY see DEMODATA? Or do you see the database that you are looking for?
We'll start with these two simple steps & go on from there.