3

I am not able to see ODBC 64-bit drivers in the SSIS connection manager dropdown list? only 32-bit drivers are appearing in the Visual Studio 2017 SSIS project. Any solution to see a list of available DSN 64-bit ODBC drivers?

Hadi
  • 36,233
  • 13
  • 65
  • 124
Krishna
  • 41
  • 1
  • 3

1 Answers1

0

I don't think you can see 64-bit ODBC sources using Visual Studio since it is a 32-bit application and ODBC 64-bit DSN only appears within 64-bit applications.

Workaround

Create two ODBC DSN (32-bit and 64-bit) having the same name. Then run the package in 64-bit mode then it will connect to the 64-bit DSN.

This workaround is mentioned in the ThoughtSpot ODBC Driver guide for SSIS.

External Links

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • Then how can I test connectivity when adding Oracle ODBC in connection managers in SSIS? Oracle does not allow any connections from 32bit ODBC driver connections. – Krishna May 22 '20 at 19:00
  • @Krishna why it doesn't allow connections using 32bit ODBC? – Hadi May 22 '20 at 21:19