Welcome, Guest
Username: Password: Remember me

TOPIC: 32bit ODBC connector not allowing connection

32bit ODBC connector not allowing connection 5 months 9 hours ago #19219

Hi, have installed an ODBC x32 connector for a SYSTEM/4 database. have tested using MS ODBC connector test tool and can access the database. When I attempt to access using ODBC connector in ETL Processor will not allow "Browse data" - fails with "Failed to connect to DSN" message. If I try and use Lookup it fails with "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" error. Does ETL Processor not support ODBC using 32bit drivers? Thanks Martin

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

32bit ODBC connector not allowing connection 5 months 9 hours ago #19220

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7658
  • Karma: 33
  • Thank you received: 434
32-bit windows applications only work with 32-bit ODBC drivers.
64-bit windows applications only work with 64-bit ODBC drivers.
It is been like this since Windows32/64 was created.
We do have both 32-bit nd 64-bit versions of our software.
Mike

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

32bit ODBC connector not allowing connection 5 months 8 hours ago #19221

Thanks for informative reply.

The ETL iteration we are running is 64bit, it accesses a native 32bit database (MariaDb) with no problem and there is no mention in the selection list of DSN's that we are selecting a 32bit ODBC driver.

As there are different versions of the software how do we run the 32bit version as well as the 64bit version please? If I attempt to execute the 32bit executable it does nothing.
Attachments:

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

32bit ODBC connector not allowing connection 5 months 7 hours ago #19222

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7658
  • Karma: 33
  • Thank you received: 434
1) The ETL iteration we are running is 64bit, it accesses a native 32bit database (MariaDB) with no problem and there is no mention in the selection list of DSN's that we are selecting a 32bit ODBC driver.
We do not use ODBC for MariaDB connections.
Or software connect directly to it via TCP/IP. So it does not matter if MariaDB is 32 bit or 64 bit.
2) In the case of ODBC, it is different. 64 bit software cannot work with 32 bit dll's (ODB driver is a dll file)
3) 32-bit folder allows running transformation/packages in the 32-bit mode, ONLY when it is executed using the agent. EG you have to design the transformation first then you will be able to execute it.
4) Install the 32-bit version of our software (just designer), connect to the same repository and design the transformation.
Please post more screenshots the do help a lot
Mike

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

32bit ODBC connector not allowing connection 5 months 6 hours ago #19223

Thanks again - will get the 32bit Designer installed on the box and try again! Watch this space.

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

32bit ODBC connector not allowing connection 4 months 3 weeks ago #19238

Hi, attempting to download the 32bit "Enterprise" version (which is the version licensed by the client) and the file downloaded is empty - the 64 bit download is the same, "Professional" download works however. Is there another way of accessing the Enterprise version software please? Thanks Martin
The following user(s) said Thank You: admin

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

We have 76 guests and one member online