Change the default networkcard for ODBC

Change the default networkcard for ODBC

Post by T3lzdGVpbk » Thu, 28 Feb 2008 21:34:03


Hi!
I got two NIC's, one for our companys internal network(NIC 1) and one for
our production network(NIC2). We have been using the NIC1 for our production
software which connects to a SQL Server on the NIC2 network throuh ODBC. This
is time consuming for transfering large data. So I set up a NIC2 which is on
the production network. I have tested this with the other network diasbled
and it's about 50% faster, but I need both networks to be up..

My question is: Is it possible to define a default NIC for the ODBC or is
this decided by the NIC's Index.? NIC 1 has 1 and NIC 2 has 9.