When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources.
..but it does show up under data source settings and it does show up in SSMS, so I know the PC can see the server\database I want to access.
I think the issue has to do with the face that this computer was configured on one domain, and then switched to another (at two different facilities). The data sources listed under my ODBC connection data list are from the first domain, at the first facility, in a different state than the PC is currently on.
How do I get Excel to see the data sources on the network & domain the PC is currently on?
Also, I'm remoting into this PC from location & domain 1, but that doesn't seem to have anyting to do with it.