1

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?

n8gard
  • 1,870
  • 8
  • 26
  • 41

1 Answers1

1

Yes, simply reference the DSN:

oConn.Open "DSN=mySystemDSN;" & _ 
           "Uid=myUsername;" & _ 
           "Pwd=myPassword"
Brettski
  • 19,351
  • 15
  • 74
  • 97
  • Thank you. I was just reading a book (not a very good one, I guess) that strongly implied that this could not be done. Thank you. – n8gard Feb 08 '12 at 04:43