Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
just do it like this:
if ComputerName() = 'COMPUTER_A' then
CONNECT DB1....;
elseif ComputerName() = 'COMPUTER_B' then
CONNECT DB2....;
else
exit script;
end if
- Ralf