I have a connection string that works on one pc, but not on the other, and vice versa..
So two connection strings.
What I want to do is have an if satement that checks the computer name, and if its computer A, then use connection 1, else use connection 2.
How do I do this?
just do it like this:
if ComputerName() = 'COMPUTER_A' then
elseif ComputerName() = 'COMPUTER_B' then
Retrieving data ...