Hi

i m facing a problem with perl script adaptation where i have to connect on Postgresql database using ODBC connection

my $dbServer = "SVTFRCTM01";

my $dbName = "EMDB";

my @drivers = DBI->available_drivers;

print join(", ", @drivers), "\n";

my $dsn = 'dbi:ODBC:Driver={PostgreSQL30}';

$dbh = DBI->connect("$dsn;Server=$dbServer;Database=$dbName;Trusted_Connection=yes", { RaiseError => 1, AutoCommit => 1 }) || messageLog("Error", "Database connection not made: $DBI::errstr");

print "\n affichage de la commande psql : ".$dbh;

nevertheless when i try do do this i obtain this following message

install_driver(Pg) failed: Can't load 'C:/Adminsouf/souffletPerl/perl/vendor/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg: load_file:\

The specified module could not be found at C:/Adminsouf/souffletPerl/perl/lib/DynaLoader.pm line 190.

at C:/Adminsouf/souffletPerl/perl/minimal/PAR/Heavy.pm line 95.

Compilation failed in require at (eval 48) line 3.

Perhaps a required shared library or dll isn't installed where expected

at C:\Adminsouf\ctm\vbs.pl line 109.

we use postgré version 9.5

i cannot add any DSN in ODBC administrator consol , i have an error message like this one =>

The setup rouines for the BMC ODBC for PostgreSQL ANSI (Default) ODBC driver could not be loaded due to system error code 126: the specified module could not be found .(C:\Program Files\BBMC Software\Control-M EM\Default\pgsql\bin\PSQLODBC30A.DLL).

so if somebody can help me ,  thank you in advance