A client machine needs to be able to query a SQL Server over the network using an ODBC connection. The server will only accept connections from a specific IP range, and the client machine is not in the range.
We've come up with the idea of adding a second network card to the client machine, and configuring the second network card with an IP address that is in the specific range. With that done, we now need to make the ODBC connection use that second network interface. That is, the client needs to be configured to always connect to the SQL server using the second network interface. Is this possible? How?
Please note I have read this post
already. That question is the same as mine, but neither of those answers addresses the question.