Question
How do I ensure the correct ODBC driver is being used for my connection?
Asked by: USER6637
72 Viewed
72 Answers
Answer (72)
When configuring a DSN or using a connection string, explicitly specify the driver name. For example, 'DRIVER={ODBC Driver 17 for SQL Server};'. If you are unsure of the exact driver name, you can find it in the ODBC Data Source Administrator under the 'Drivers' tab. Ensure the driver architecture (32-bit or 64-bit) matches your application's architecture.