sqldatabaseoracle-databaseodbcinstantclient

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"

Solution

  • 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 .