2

I'm trying to figure out what some old Perl that is used for reporting on our websites is doing. I've gotten ActiveState Perl installed and things seem to be working EXCEPT that when the Perl tries to open a database connection. The following error is displayed:

Error creating ADODB.Connection to [our connection string redacted]: OLE exception from "ADODB.Connection":

Provider cannot be found. It may not be properly installed.

Win32::OLE(0.1712) error 0x800a0e7a
    in METHOD/PROPERTYGET "Open"" failed:256

The offending line of Perl is:

$dbhandle = dbOpen(%dbConnectstr);

The following use statements are also used:

use Win32::OLE;
use Win32::OLE::Const 'Microsoft ActiveX Data Objects';

How do I install (or configure or?) the provider on Windows 10?

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
Owen
  • 426
  • 5
  • 15
  • Is `dbOpen(%dbConnectstr)` a typo? Are you sure you didn't mean to write `dbOpen(\%dbConnectstr)` instead? Is `dpOpen()` your own code or from a module? If it is your own code, you should add to your question. – Stefan Becker Jan 30 '19 at 06:32
  • I don't recognize `dbOpen`. Is it a function they wrote? You may need [ADO](https://learn.microsoft.com/en-us/sql/ado/microsoft-activex-data-objects-ado?view=sql-server-2017) installed or to mess with ODBC settings. – Schwern Apr 06 '19 at 20:28

0 Answers0