DSN Connection Successful but Cannot Query from Excel
Posted on 2011-09-09
We have a large network with many different vlans, and have around 20 databases on various servers. One of these servers is on a subnet that is not on a vlan, but is interfaced to one of our access vlans by a cheap Netgear soho router.
It is necessary to query from a number of databases on this server, so I put the server in the DMZ zone on the soho router.
I can successfully establish a connection when setting up a DSN from a computer on our access vlan, but cannot establish a connection via an Excel ODBC connection.
I receive error 67 and 17, server not found or access denied.
Any ideas why I am unable to connect only through Excel?