2

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"
Louay GOURRIDA
  • 190
  • 1
  • 3
  • 14
  • Obviously there is **something different** about what your classmates have done and what you are doing. Maybe it's something about your environment or configuration. Maybe you've missed a step or mistyped a parameter. There is very little we can do to debug your installation remotely. On the other hand there is a great deal you can do with the assistance of one of your classmates. – APC Nov 13 '18 at 17:45
  • Is folder `c:\Instantclient_12_2` in your `%PATH%` environment variable? – Wernfried Domscheit Nov 13 '18 at 18:14
  • Open your Registry editor. What do you have in `HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers` and `HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\Oracle in instantclient_12_2`? – Wernfried Domscheit Nov 13 '18 at 18:16
  • yes its my path – Louay GOURRIDA Nov 13 '18 at 18:27
  • The show your registry entries (edit the question). In best case put in text rather than screen shots. – Wernfried Domscheit Nov 13 '18 at 18:39
  • @WernfriedDomscheit check my post I added 2 pictures that shows what I have in my HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers and HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\Oracle in instantclient_12_2? – Louay GOURRIDA Nov 13 '18 at 19:04
  • Do you think that we are visionary and can see the truncated text in you picture? Move the borders that we can read the relevant text! – Wernfried Domscheit Nov 13 '18 at 20:13
  • Do you have both files sqora32.dll and sqora**s**32.dll? – Wernfried Domscheit Nov 13 '18 at 20:18
  • @WernfriedDomscheit I removed the screenshots and wrote it as a text , yes I have sqora32.dll and saqoras32.dll. – Louay GOURRIDA Nov 13 '18 at 21:15
  • The folder in your Registry is `C:\instantclient12_2` instead of `C:\instantclient_12_2` - verify carefully. – Wernfried Domscheit Nov 13 '18 at 21:19
  • yeah I saw it and I did modify all the C:\instantclient_12_2 to C:\instantclient12_2 in the TNS_ADMIN,the path ... – Louay GOURRIDA Nov 13 '18 at 21:22
  • is there anything else that it looks like causing the problem .. what should I do ? – Louay GOURRIDA Nov 13 '18 at 21:23
  • Somehow you mixed the folders. I would recommend to uninstall the ODBC driver and install again. – Wernfried Domscheit Nov 14 '18 at 11:08

1 Answers1

1

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 .

Louay GOURRIDA
  • 190
  • 1
  • 3
  • 14