SSIS Package ODBC error code 0xC0014009 then connecting to another server

Question

Hello Internet!

Error
1 - Error an ODBC error -1 has orurred.
2 - There was an error tryinf to establish an Open Database Connectivity (ODBC) conection with the database server.
3 - The AcquereConnection method call the connection manager Questor failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
4 - Source ODBC failed validation and returned error code 0x80004005.

Setup
I make a package that's transfers data from a Firebird (Windows, alias: "Questor") and MySQL Server (Linux, alias: "Helpper"), both in a third-party server, to a SQL Server (in my own server). The package has an error as show above, but when I Delete the Firebird part of this Package it works.

These two databases weren’t always in a third-party server, and when they was in my own server, this Package worked fine. When I need to connect to this database outside SSMS, I need have a Windows Credential save in the "Credential Manager", and it is configure as show bellow:
IP: The.Third-Party.Server.IP | UserName: MyOrg\UserName1
This configuration works outside SSMS, and I use the same parameters in the Proxy that I configure to the Job that calls this Package.
And the connection string is similar to my OBDC configuration:
uid=FirebirdUser;Driver={Firebird/InterBase(r) driver};dbname=\ The.Third-Party.Server.IP \D:\nBase\questor.fdb;charset=NONE;client=C:**fbclient.dll**;
where fbclient.dll is used for 64 bits.

Doubt
What I’m doing wrong?

Answer 1

Hi @Daniel Camara ,

May I know if the user has correct permission to access the third-party server ?

Hope the following link will be helpful:

Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility

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.