Msorcl32.dll, File description: ODBC Driver for Oracle Errors related to msorcl32.dll can arise for a few different different reasons. For instance, a faulty application, msorcl32.dll has been deleted or misplaced, corrupted by malicious software present on your PC or a damaged Windows registry.
Here is the trick,
I wanted to add an ODBC for Oracle in the profiler for an application that is linked(Inter-Isolation communication) with Oracle Client profile, but i had this error ' Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation'.
Anyway, i added a windows 'cmd.exe' to the profile using the streaming profiler. After that i launched the command. By now, i have a command line prompt, which i like!, and i typed 'odbcad32.exe' which is the ODBC configuration window. So, the window pop-up and i added my ODBC without any problem. But i still in the isolated environment not in the profiler. What i did is from the same command window i launched the 'regedit' command, i looked for ODBC and found it in the 'HKEY_CURRENT_USERSoftware'. Then i copied all the created variables in the registry (i didn't want to make an export). After this, i went to the streaming profiler and updated the profile in the registry by using these lines:
Lets assume that 'cosmos' is the name of the data sources and the name of the server.(take look to the picture in the attachment). All you have to do is to create the keys and the variables and their values.
HKEY_CURRENT_USERSoftwareODBCODBC.INI
HKEY_CURRENT_USERSoftwareODBCODBC.INIcosmos
* BufferSize REG_SZ 65535
* Description REG_SZ
* Driver REG_SZ C:WINDOWSsystem32msorcl32.dll
* DSN REG_SZ cosmos
* GuessTheColDef REG_SZ 0
* PWD REG_SZ
* Remarks REG_SZ 0
* SERVER REG_SZ cosmos
* StdDayOfWeek REG_SZ 1
* StripTrailingZero REG_SZ 0
* SynonymColumns REG_SZ 1
* UID REG_SZ
HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources
* cosmos REG_SZ Microsoft ODBC for Oracle
I wanted to add an ODBC for Oracle in the profiler for an application that is linked(Inter-Isolation communication) with Oracle Client profile, but i had this error ' Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the
Oracle Version 7.3.3 or later client software installation'.
Anyway, i added a windows 'cmd.exe' to the profile using the streaming profiler. After that i launched the command. By now, i have a command line prompt, which i like!, and i typed 'odbcad32.exe' which is the ODBC configuration window. So, the window pop-up and i added my ODBC without any problem. But i still in the isolated environment not in the profiler. What i did is from the same command window i launched the 'regedit' command, i looked for ODBC and found it in the 'HKEY_CURRENT_USERSoftware'. Then i copied all the created variables in the registry (i didn't want to make an export). After this, i went to the streaming profiler and updated the profile in the registry by using these lines:
Lets assume that 'cosmos' is the name of the data sources and the name of the server.(take look to the picture in the attachment). All you have to do is to create the keys and the variables and their values.
HKEY_CURRENT_USERSoftwareODBCODBC.INI
HKEY_CURRENT_USERSoftwareODBCODBC.INIcosmos
* BufferSize REG_SZ 65535
* Description REG_SZ
* Driver REG_SZ C:WINDOWSsystem32msorcl32.dll
* DSN REG_SZ cosmos
* GuessTheColDef REG_SZ 0
* PWD REG_SZ
* Remarks REG_SZ 0
* SERVER REG_SZ cosmos
* StdDayOfWeek REG_SZ 1
* StripTrailingZero REG_SZ 0
* SynonymColumns REG_SZ 1
* UID REG_SZ
HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources
* cosmos REG_SZ Microsoft ODBC for Oracle