CODEWITHSUNDEEP
excelpostgresqlms-accessvba
Frost
Frost

Reputation: 25

Impossible to connect to PostgreSQL DB via VBA

I have a problem trying to connect to my local PGSQL db via VBA. My code looks like this :

Set conn = CreateObject("ADODB.Connection") strCnx = "Driver={PostgreSQL Unicode}; Server=127.0.0.1; Database=postgres; UID=postgres;Pwd=***;port=5432" conn.Open strCnx

The error I get is

[Microsoft][ODBC Driver Controler]DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED

I have tried a few things I found on stackoverflow, mainly installed the odbc drivers for postgresqlx64, and tried to connect to the database using directly ODBC, which told me success when I tried to connect (picture below).

Testing connection to PGSQL DB directly via ODBC

But despite everything I tried, the error is the same when I try to execute my VBA code, and I'm out of ideas, so if there are any way you could help me, I would be most thankful :)

Thanks

Frost

Upvotes: 1

Views: 1292

Answers (1)

Erik A
Erik A

Reputation: 32672

Make sure you install an ODBC driver with the same bitness as the application hosting your VBA. So 32-bits Excel means you need the 32-bits (x86) ODBC driver.

If you install the proper ODBC driver, this error should go away.

Upvotes: 2

Related Questions