ETL version 5.8+ not working on 64bit Windows Server

More
8 years 7 months ago - 8 years 7 months ago #12434 by orlandoc
Greetings,

I upgraded our ETL version from 5.7.10.10 to the latest ETL 5.8+.
Our platform is Windows Server 2008 R2 Enterprise 64 bit.
We installed all the latest odbc driver on this machine except it wont able to install 32bit odbc driver. (see screenshot)









ETL 5.8 supports the FTP rename which we need but this latest version is not working for us so far. Please advise.
Attachments:
Last edit: 8 years 7 months ago by orlandoc.

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #12435 by admin
I believe if you install service pack for SQL Server it will update it.

(2012 drivers should work as well, It is more question to Microsoft and not us)

Can you you build a small example for us which is definitely failing

We would need:
table creation script
source text file
mapping

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #12436 by orlandoc
I just wondering if you guys tested the ETL 5.8+ on windows server 2008 R2 64bit.


Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #12437 by admin
We did and we had exactly same problems installed drivers and it started to work.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #12438 by orlandoc
in that case, can you please answer the following question below? I need to know if there some difference between our environment.

What is your OS version (pls state if 32 or 64)?
What is your SQL Server version?
What is your ODBC version running in ETL?
On ETL Repository, are you using SQL account to connect to repository database or domain account?

Thank you.

Please Log in or Create an account to join the conversation.

More
8 years 7 months ago #12439 by admin
Since you are really struggling I have asked one of the developers to have a look at it for you

Mike
ETL Architect

Please Log in or Create an account to join the conversation.