Attempting to setup an outbound (I'm querying out, not querying the IRIS db) SQL connection. I am connecting to a PostgreSQL database, name "hl7interface".
I have setup the odbc.ini file at /usr/local/etc with the following contents:
[HL7Interface2] Driver = PostgreSQL Description = HL7 Interface DB Servername = localhost Port = 5432 Protocol = 7.4-1 #userName = postgres #Password = <real pw here> Database = hl7interface ReadOnly = no ServerType = Postgres
I have set the /etc/odbcinst.ini file with the location of the PostgreSQL driver: