Forum Stats

  • 3,750,412 Users
  • 2,250,174 Discussions
  • 7,866,971 Comments

Discussions

Error creating ODBC connection

This relates to a old Windows Server 2008 R2 instance (which I know is out of support, but I have to work with what I have).

I have installed the 32 bit 19.12 instant client as per the instructions and followed up with adding the ODBC components.

When I use the ODBC Data Source Administrator I can see the driver listed in the drivers tab "Oracle in instantclient_19_12". But when I go to the System DSN tab and attempt to adda connection as soon as I select the driver I get the error:


The setup routines for the Oracle in instantclient-19_12 ODBC driver could not be loaded due to system error code 998: Invalid access to memory location.

The file SQORAS32.DLL does exist in C:\Oracle\instantclient_19_12.

C:\Oracle\instantclient_19_12 has permission set to allow access for all users

C:\Oracle\instantclient_19_12 is the first entry in the PATH system variable

I've removed and re-installed.

I tried the 64 bit versions instead and got the same error

I've Googled all over the place without finding any solutions, even found a very similar question here that was closed with no answer.

Can anyone offer any steps to take please?