This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, I am trying to update a connection string on a SQL database connection I have. I need to change the server address from "Server A" to "Server B". I went into the "Manage Data Connections" option, and the connection string section is grayed out. I cannot find this anywhere else. Anyone have any ideas how to modify this?
I know that I can set up the new server as a new connection, but then I need to change the connection in each data "input" on my workflows.
If I'm not mistaken, the connection string section is automatically populated with information from the fields above and the Microsoft ODBC Administrator. The server address should be pulled from the ODBC Administrator, so I imagine editing the server location there is the way to go.
I don't think this is true. I changed the name of my odbc connection to match the dsn on server and my designer still shows the old name. I can't modify anything and I don't think this used to be the case.
We REALLY need curated community content, there is so much that's confusing or of unclear veracity on these threads!