One of my users can't get the main SQL database as an option from which to import data into Microsoft Visio.
We have dozens of databases but only a few are set up and available to select as Data Sources through ODBC. Where do I need to set up the ODBC? Is there a SQL setting I need to make in the Database itself that 'turns on' the capability for an office application such as visio to be able to 'see' the data?
We have dozens of databases but only a few are set up and available to select as Data Sources through ODBC. Where do I need to set up the ODBC? Is there a SQL setting I need to make in the Database itself that 'turns on' the capability for an office application such as visio to be able to 'see' the data?