Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Error creating ODBC connection
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?
Answers
-
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.
0 -
Admins - please delete. I'll re-post somewhere more appropriate.
0 -
*Moderator Note: Closing this thread.
0