CODEWITHSUNDEEP
sqldatabaseoracle-databaseodbcinstantclient
Louay GOURRIDA
Louay GOURRIDA

Reputation: 202

Oracle in instantclient_12_2 ODBC driver could not be loaded

I Was trying to do the connection between Oracle and QT while I'm in creating a new data source there were a problem that I couldn't solve

first step

2nd step

the problem

when I go and check the instant client I found sqoras32.dll I don't know why it says sqoras32.dll not found ..

I tried a lot of solutions like installing visual c++ 2010 , copying the sqoras.dll and pasting it in system32... but none of them worked can anyone help me please , Thanks!

PS:all my classmates did the same steps and it worked for them.

and that's what I have in 

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\Oracle in instantclient12_2
"APILevel"="1"
"CPTimeout"="60"
"ConnectFunctions"="YYY"
"Driver"="C:\instantclient12_2\SQORA32.dll"
"DriverODBCVer"="03.51"
"FileUsage"="0"
"Setup"="C:\instantclient12_2\SQORAS32.DLL"
"SQLLevel"="1"

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers
 "Driver da Microsoft para arquivos texto (*.txt; *.csv)"="installed"
 "Driver do Microsoft Access (*.mdb)"="installed"
 "Driver do Microsoft dBase (*.dbf)"="installed"
 "Driver do Microsoft Excel(*.xls)"="installed"
 "Driver do Microsoft Paradox (*.db)"="installed"
 "Microsoft Access Driver (*.mdb)"="installed"
 "Microsoft Access-Treiber (*.mdb)"="installed"
 "Microsoft dBase Driver (*.dbf)"="installed"
 "Microsoft dBase-Treiber (*.dbf)"="installed"
 "Microsoft Excel Driver (*.xls)"="installed"
 "Microsoft Excel-Treiber (*.xls)"="installed"
 "Microsoft ODBC for Oracle"="installed"
 "Microsoft Paradox Driver (*.db )"="installed"
 "Microsoft Paradox-Treiber (*.db )"="installed"
 "Microsoft Text Driver (*.txt; *.csv)"="installed"
 "Microsoft Text-Treiber (*.txt; *.csv)"="installed"
 "Oracle in instantclient12_2"="installed"
 "SQL Server"="installed"

Upvotes: 2

Views: 5222

Answers (2)

that_roy
that_roy

Reputation: 104

I had the same issue and was able to use the information found in this post to fix it.

Out of helping others the following link is where to find the downloads. https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170

Direct links to Redist:

https://aka.ms/vs/17/release/vc_redist.arm64.exe

https://aka.ms/vs/17/release/vc_redist.x86.exe

https://aka.ms/vs/17/release/vc_redist.x64.exe

Upvotes: 0

Louay GOURRIDA
Louay GOURRIDA

Reputation: 202

finally I could fix it by installing all visual studios from 2005 to 2017(x64 nd x86) now it works correctly thanks for all those who tried to help .

Upvotes: 1

Related Questions