Can't add to route table, 2 NIC connections

[Coveblue]

I've got 2 nic cards on my computer, running Windows XP Pro.

Card 1:
Connects directly to network server through ethernet hub (not router).
nic = 192.168.0.55, 255.255.255.0, no gateway specified
server = cove_server, 192.168.0.10, 255.255.255.0, no gateway specified

Card 2:
Connects to DirecWay Satellite Internet through DHCP.
nic = dhcp, 192.168.0.3, 255.255.255.0, gateway 192.168.0.1

--------------------

I'm trying to connect to a database on the 1st card's network via ODBC. If
connection 2 (internet) is connected, then I get an error trying to connect
to the database:

"Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied."

If I disable connection 2 (internet), then it works perfect.

------------------

I've just upgraded my computer so I'm trying to rebuild. On the old
computer (same setup), I had the same problem. I added 192.168.0.10 to the
route table and it solved the problem. Now, on my current computer, when I
try to add 192.168.0.10 I get this error:

route -p ADD 192.168.0.10 MASK 255.255.255.0

"The route addition failed: The specified mask parameter is invalid.
(Destination & Mask) != Destination"

I have tried the route add several times with various possibilities for
gateways and metrics, but I get an error every time.

--------------------

This is my current route table:

C:\Documents and Settings\Ted>route print
===========================================================================
Interface List
0x1 ........................... MS TCP Loopback interface
0x10003 ...00 0c 6e 23 25 3d ...... VIA Compatable Fast Ethernet Adapter -
Packe
t Scheduler Miniport
0x10004 ...00 04 5a 8e 2e 37 ...... Linksys LNE100TX Fast Ethernet
Adapter(LNE10
0TX v4) - Packet Scheduler Miniport
===========================================================================
===========================================================================
Active Routes:
Network Destination Netmask Gateway Interface Metric
0.0.0.0 0.0.0.0 192.168.0.1 192.168.0.3
20
127.0.0.0 255.0.0.0 127.0.0.1 127.0.0.1
1
192.168.0.0 255.255.255.0 192.168.0.3 192.168.0.3 20
192.168.0.0 255.255.255.0 192.168.0.55 192.168.0.55 20
192.168.0.3 255.255.255.255 127.0.0.1 127.0.0.1 20
192.168.0.55 255.255.255.255 127.0.0.1 127.0.0.1 20
192.168.0.255 255.255.255.255 192.168.0.3 192.168.0.3 20
192.168.0.255 255.255.255.255 192.168.0.55 192.168.0.55 20
224.0.0.0 240.0.0.0 192.168.0.3 192.168.0.3 20
224.0.0.0 240.0.0.0 192.168.0.55 192.168.0.55 20
255.255.255.255 255.255.255.255 192.168.0.3 192.168.0.3 1
255.255.255.255 255.255.255.255 192.168.0.55 192.168.0.55 1
Default Gateway: 192.168.0.1
===========================================================================
Persistent Routes:
None

-------------------

I feel certain that my problem will be solved if I can add 192.168.0.10 to
my route table, but I get an error every time I try.


Thanks for any help you can offer!!!!!!!!

Ted

 

[coveblue]

Sorry about the long message, I just wanted to give as much info as
possible.

Yes, I have tried 255.255.255.255, I get the same error "mask & destination
!= destination"

 

[Steve Winograd [MVP]]

I've just upgraded my computer so I'm trying to rebuild. On the old
computer (same setup), I had the same problem. I added 192.168.0.10 to the
route table and it solved the problem. Now, on my current computer, when I
try to add 192.168.0.10 I get this error:


"The route addition failed: The specified mask parameter is invalid.
(Destination & Mask) != Destination"

I have tried the route add several times with various possibilities for
gateways and metrics, but I get an error every time.

If I understand correctly, you want to create a route that sends
traffic for 192.168.0.10 through the nic with IP address 192.168.0.55.
Your route statement doesn't have enough parameters, and the subnet
mask is wrong if the route is to apply to just one IP address. To
make traffic for 192.168.0.10 go through the NIC at 192.168.0.55, the
statement would be:

route -p ADD 192.168.0.10 MASK 255.255.255.255 192.168.0.55

As I said in my other reply, the real problem is that both nics are in
the same subnet, which can cause strange network behavior. I don't
think that adding this route will fix everything, but I could be
wrong. If you try it, please post the result.

The best solution is to use different subnets for the two networks.
--
Best Wishes,
Steve Winograd, MS-MVP (Windows Networking)

Please post any reply as a follow-up message in the news group
for everyone to see. I'm sorry, but I don't answer questions
addressed directly to me in E-mail or news groups.

Microsoft Most Valuable Professional Program
http://mvp.support.microsoft.com

 

[Coveblue]

That did it. I tried the same thing before, but with MASK 255.255.255.0 and
it didn't work. Anyway, this did the trick and now I can access my
databases and internet at the same time. Thanks for your help!

 

[Steve Winograd [MVP]]

That did it. I tried the same thing before, but with MASK 255.255.255.0 and
it didn't work. Anyway, this did the trick and now I can access my
databases and internet at the same time. Thanks for your help!

You're welcome! Thanks for reporting the results.
--
Best Wishes,
Steve Winograd, MS-MVP (Windows Networking)

Please post any reply as a follow-up message in the news group
for everyone to see. I'm sorry, but I don't answer questions
addressed directly to me in E-mail or news groups.

Microsoft Most Valuable Professional Program
http://mvp.support.microsoft.com