Once the driver is installed, you must tell it where to go. A standard DSN setup requires: The IP or hostname of the database. Port: (e.g., 1433 for SQL Server, 3306 for MySQL). Database Name: The specific schema you want to access.
: Some drivers, like Snowflake's, require the Visual C++ Redistributable to be installed before the driver can function. 3. Test Connectivity
Ensure the driver version is compatible with your specific database release (e.g., SQL Server 2019 vs. 2022).
Does your application need a 32-bit or 64-bit driver? Note that a 64-bit Windows OS can run both, but a 32-bit version of Excel must use a 32-bit ODBC driver.