Microsoft 64bit ODBC drivers.....?

[BellyGas]

This is only sort of a VBA question.

The dept I'm contracted to right now has a 32bit Excel based reporting system that uses hard coded connection strings in VBA like so:

Please Login or Register  to view this content.

There are 96 different reports that use this connection string. However, a few of these reports are hitting excel memory limits (getting the error: Excel does not have the required resources to complete this operation, and others similar), therefore, the IT dept have built us a spanky new 64Bit server with 64bit office to run things in......however, what they're telling me is they can't find a 64bit Microsoft ODBC driver so they've put on a 64bit Oracle ODBC driver instead. This means all our connection strings need to change and all the reporting analysts laptops will also have to be upgraded to 64bit office with the Oracle 64bit driver if they want to be able to continue to run reports outside of the reporting server on an ad-hoc basis.


My question is: Does anyone know of a 64bit MS ODBC driver? Cos it would save a lot of effort....

[Leith Ross]

Hello BellyGas,

I am surprised your IT department is not aware of WoW64. This is Microsoft's x86 emulator for 64 Bit Windows.

Here is link to explain more about it Running 32-Bit Applications

[BellyGas]

The IT dept here isn't aware of a lot of things.

Anyway, running 32bit office on the new 64bit server isn't an option. The whole reason for moving to 64bit is to allow Excel more memory space for the inefficiently build workbooks I'm dealing with. Running a 32bit ODBC driver on a 64bit system isn't an option as 64bit Office wont take a data feed from a 32bit ODBC driver.

After some research discovered the MS-ODBC driver for Oracle is about 20 years old, MS stopped support for it over a decade ago and never produced a 64bit version. Why would they when Oracle produce their own drivers. It just means a 1 line code change for the different connection string.

[naliakbar]

The IT dept here isn't aware of a lot of things.

Anyway, running 32bit office on the new 64bit server isn't an option. The whole reason for moving to 64bit is to allow Excel more memory space for the inefficiently build workbooks I'm dealing with. Running a 32bit ODBC driver on a 64bit system isn't an option as 64bit Office wont take a data feed from a 32bit ODBC driver.

After some research discovered the MS-ODBC driver for Oracle is about 20 years old, MS stopped support for it over a decade ago and never produced a 64bit version. Why would they when Oracle produce their own drivers. It just means a 1 line code change for the different connection string.

Do you mind sharing what the line of code might be?

[Haluk]

There is a non-Microsoft ODBC Driver for Oracle which they say that it works for 32-Bit and 64-Bit applications on both x32 and x64 platforms.

https://www.devart.com/odbc/oracle/

[naliakbar]

Because our IT department would not allow for additional software to be installed I need to come up with a solution that will work without having to install something new.