0

I've changed an SSIS package to use a 64-bit ODBC connection instead of 32-bit.

After deployment it works fine when executing the package but when running a SQL Server Agent job with the package it fails with:

An ODBC Error -1 has occurred

and

There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server

and

The AcquireConnection call to the connection manager Athena West-1 64-bit failed with error code 0xC0014009.

What is the reason for this error?

2
  • 1
    dup on SO
    – SMor
    Sep 8 at 11:39
  • I imagine the odbc connections are registered as user ODBCs, have you configured a proxy account on SQL Server agent to run the job as the said user?
    – Amine C
    Sep 8 at 14:15
0

My guess is a firewall is blocking the account, I'd recommend working with your security team to establish a service account in your AD, assuming this is a corporate environment

1
  • It works when running with the 32-bit version of the ODBC correction so it doesn't sound likely that it would be a firewall issue.
    – Christian
    Sep 8 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.