Link to home
Start Free TrialLog in
Avatar of LiquidHappyRDM
LiquidHappyRDM

asked on

Making an ODBC call

I was wondering, is there a way to select a network connection while making an ODBC call?  I have two machines that have 2 different network connections and I need to make this call over a specific network connection.  I would imagine it would have to do something with specifying the mac address of the NIC it is communicating over, but I am not sure.
Avatar of Jim P.
Jim P.
Flag of United States of America image

Actually it is more of a routing issue.

Instead of specifying a server name in the ODBC specify the IP address.  The redirector at layer 3 (I think) should know the route of of each connection and forward appropriately.
ASKER CERTIFIED SOLUTION
Avatar of Brain2000
Brain2000
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No objections.