Error creating ODBC connection

user8026345

This relates to a old Windows Server 2008 R2 instance.

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?

[Deleted User]

a) Wrong place. This is the Analytics forum. You will want an admin to transfer this to the database forum

b) Windows 2008 isn't supported anymore by anyone - see https://docs.microsoft.com/en-us/troubleshoot/windows-server/windows-server-eos-faq/end-of-support-windows-server-2008-2008r2

So you won't get any drivers delivered for such an old, outdated operating system.

user8026345

Admins - please delete. I'll re-post somewhere more appropriate.

BluShadow

*Moderator Note: Closing this thread.