I've inherited a DB with a bunch of remote views which were designed with some ODBC connection on some long gone machine and no documentation.

So when I try to open the view in the designer I get the error "Datasource name not found and no default driver specified"

I imagine the name is somewhere in the DB, but where?

TIA