Page 1 of 1

unable to get oracle option in database connection

Posted: Fri Sep 14, 2018 8:28 am
by njhajhajha
Hey , I am using Process Maker 3.2.2 community version

I want to connect to oracle 11.2.0.4,
So i downloaded php_oci8_11g.dll and placed in php/ext path

and placed this
extension=php_oci8_11g.dll

in php.ini

and other oracle is commented.

Please Provide Solution.

Thanks

Re: unable to get oracle option in database connection

Posted: Fri Sep 14, 2018 9:54 pm
by amosbatto
What is the operating system of your ProcessMaker server? Are you using a manual or a Bitnami installation of ProcessMaker?

Re: unable to get oracle option in database connection

Posted: Sat Sep 15, 2018 12:30 am
by njhajhajha
I am using windows server 2012 R2 and also tried with windows 7
And i used bitnami installer

Re: unable to get oracle option in database connection

Posted: Mon Sep 17, 2018 1:50 am
by njhajhajha
There is oracle 12c dll file in php/ext
So i jst uncomment oracle 12c extension in php.ini file.

Still oracle option is not available in drop down of Database Connection.

Also i added .dll files for oracle 12c client in apache/bin Folder as mention in Documentation of ProcessMaker. Still I am not Able to get oracle Option.

Re: unable to get oracle option in database connection

Posted: Tue Sep 18, 2018 12:28 am
by amosbatto
I don't have time right now to install a Windows Server 2012 virtual machine to test this. Give me a few days and I will test it. What operating system is your Oracle 11.2.0.4 installed in?

Re: unable to get oracle option in database connection

Posted: Tue Sep 18, 2018 2:17 am
by njhajhajha
Okay no Problem, I guess Problem is with Microsoft visual C++ Not the OS.

Re: unable to get oracle option in database connection

Posted: Tue Sep 18, 2018 2:25 am
by njhajhajha
actually in error logs i m getting,

Unable to load dynamic library 'C:/Bitnami/Processmaker/php/ext\\php_oci8_12c.dll'- the specified module could not be found .\r\n in Unknown on line 0

Re: unable to get oracle option in database connection

Posted: Tue Sep 18, 2018 5:10 am
by njhajhajha
I t worked!! after Microsoft Visual C++ of specific version was installed on system :)

Re: unable to get oracle option in database connection

Posted: Wed Sep 19, 2018 1:47 am
by amosbatto
Good to know that you need a specific Visual C++ Runtime to make this work. I have never used Oracle in Windows.

Re: unable to get oracle option in database connection

Posted: Thu Sep 20, 2018 7:20 am
by njhajhajha
:)

Re: unable to get oracle option in database connection

Posted: Wed Jun 09, 2021 1:08 pm
by leociss
Hi guys, what version of Microsoft Visual C++ needed for connection to appear?