CODEWITHSUNDEEP
postgresqlvbaexcelado
n8gard
n8gard

Reputation: 1970

Does ADO work with ODBC drivers or only OLE DB providers?

I am trying to create some VBA code to automate dashboard creation against a PostgreSQL database. I have heard the OLE DB driver is unreliable and it looks like it hasn't been touched in several years. Does ADO work with an ODBC driver?

Upvotes: 1

Views: 6411

Answers (1)

Brettski
Brettski

Reputation: 20101

Yes, simply reference the DSN:

oConn.Open "DSN=mySystemDSN;" & _ 
           "Uid=myUsername;" & _ 
           "Pwd=myPassword"

Upvotes: 1

Related Questions