ODBC with SSIS On Linux

Question

I have installed unixODBC 2.3.4 and Mysql ODBC Driver,
when I use CMD "isql DNS" ,it can connect to MysqlDB；
but when I use dtexec pacakge to run SSIS ,it can't recognize DNS.
The Error is "INVALID_HANDLE - unable to allocate an environment handle.".
"ADO NET Source failed validation and returned error code 0xC0208449."
What Can I do to reslove it ?

Answer 1

Hi @william.chen ,

Could please check the following properties?

1. ODBC driver is 32-bit or 64-bit?
2. DTExec.exe is 32-bit or 64-bit?
3. Run64BitRuntime is True or false in ssis package?

Please refer to the following links:
SSIS Packages in 64-Bit
How to run SSIS packages using 32-bit drivers on a 64-bit machine

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks for you Reply, My Server operaton System is Ubuntu 16.04 64bit, I have visit your solution,It's Run SSIS on windows ,there is no useful information for my question;

1.ODBC driver is 64-bit?
There is only a version about unixODBC2.3.4，It's 64bit;
I download it from ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz,

2.DTExec.exe is 32-bit or 64-bit?
DTExec is not a EXE，I install it follow :
sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"
sudo apt-get update
sudo apt-get install -y mssql-server-is
There is no information about 32-bit or 64-bit

3.Run64BitRuntime is True or false in ssis package?
I have confirmed Run64BitRuntime is True

Answer 3

Today I install a new Unbutu 18.02, Follow the Step on MSDN，The problem is the same，I try all my best , it say failure on ODBC when I run DTExec .

Answer 4

Thanks for your reply . There is no 32-bit ODBC Drvier on Linux. Can you provide an Really useful odbc pratical on Linux ?