fail to connect to Oracle...missing OCI.dll

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

my connection string:

my $dbh = DBI->connect("dbi:Oracle:host=xxxx;sid=sh;port=1526, $userid
+, $password");
[download]

I can connect via sqldeveloper so I know the connection parameters are correct. Using Strawberry Perl 5.24.1 on 32-bit windows. The error message says that OCI.dll is missing.

Comment on fail to connect to Oracle...missing OCI.dll Download Code

Replies are listed 'Best First'.
Re: fail to connect to Oracle...missing OCI.dll by poj (Abbot) on May 17, 2017 at 15:40 UTC
See Oracle Instant Client	[reply]
Re: fail to connect to Oracle...missing OCI.dll by thanos1983 (Parson) on May 17, 2017 at 15:41 UTC
Hello Anonymous Monk, I would suggest to read this similar problem thread (problem using DBD::Oracle with Active State). Most like the problem is `Oracle: DBD::Oracle - install 64bit Oracle Instant Client 12.x and make sure you have OCI.DLL in your PATH` as stated on the (Strawberry Perl (5.22.0.1-64bit) Release Notes) documentation. I assume the same applies for 32-bit system. Hope this helps. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]
Re: fail to connect to Oracle...missing OCI.dll by Anonymous Monk on May 17, 2017 at 16:10 UTC
thanks helpful Perl gurus...	[reply]