CODEWITHSUNDEEP
sql-serverssisvisual-studio-2017odbcetl
Krishna
Krishna

Reputation: 41

I am not able to see ODBC 64-bit drivers in SSIS connection manager drop down list?

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?

Upvotes: 3

Views: 6482

Answers (3)

KTYP
KTYP

Reputation: 356

Either you can change the runtime to 32bit in Visual Studio or install the 64 bit driver.

The last available 64-bit version of MySQL ODBC Driver is 8.0.33. You can find this version under the archive section. After installing this 64-bit driver, it will be accessible in the 64-bit ODBC window.

visual studio 2022 doesn't allow you to change the runtime to 32bit therefore thi is the only option i had to use the 64bit driver.

enter image description here

Upvotes: 0

Hari
Hari

Reputation: 1

I stumbled upon this same issue and solved it by selecting Run in 32 bit runtime in SSMS.

Steps :

  1. Right click on Job
  2. Select Properties
  3. Navigate to Steps and select the particular step which executes the package
  4. Select Connections and then in Advanced tab
  5. Enable 32 bit runtime check box.

This fixed my issue.

Upvotes: 0

Hadi
Hadi

Reputation: 37358

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

Upvotes: 0

Related Questions