Hi Martin, Here it is. I have removed the host names.
$ cat /usr/local/etc/odbc.ini [ODBC] DebugFile = /tmp/oplhsodbc.log TraceFile = /tmp/ihsodbc.log Trace = 1 [ODBC Data Sources] [AB01] Driver = /usr/local/nz/lib/libnzsqlodbc.so Description = NetezzaSQL ODBC Servername = Port = 5480 Database = CancelAsFreeStmt = false CommLog = true Ksqo = false Lie = true Optimizer = false Parse = false PreFetch = 256 Protocol = 7.0 ReadOnly = false ShowSystemTables = false Socket = 16384 DateFormat = 1 TranslationDLL = TranslationName = TranslationOption = [AS01] Driver = /usr/local/nz/lib/libnzsqlodbc.so Description = NetezzaSQL ODBC Servername = Port = 5480 Database = CancelAsFreeStmt = false CommLog = true Ksqo = false Lie = true Optimizer = false Parse = false PreFetch = 256 Protocol = 7.0 ReadOnly = false ShowSystemTables = false Socket = 16384 DateFormat = 1 TranslationDLL = TranslationName = TranslationOption = [ASSQL] Driver = /usr/local/nz/lib/libnzsqlodbc.so Description = NetezzaSQL ODBC Servername = Port = 5480 Database = CancelAsFreeStmt = false CommLog = true Ksqo = false Lie = true Optimizer = false Parse = false PreFetch = 256 Protocol = 7.0 ReadOnly = false ShowSystemTables = false Socket = 16384 DateFormat = 1 TranslationDLL = TranslationName = TranslationOption = [pgr7_lite] Driver = /export/home/idbamb1/openlink/lib/pgr7_mt_lt.so ServerType = PostgreSQL ;Username = ;Password = Database = Options = -H -P 5480 ;; These are the two key parameters for locating the Postgres (Neteeza) Server, the hostname and portno it is running on FetchBufferSize = 99 ReadOnly = no DeferLongFetch = no JetFix = no Description = Sample PostgreSQL Lite Connection NO_QUOTED_IDENTIFIERS=Y [xxxx] JetFix = No NoRowSetSizeLimit = No Description = Netezza via Openlink Driver test Options = ServerType = PostgreSQL Driver = /export/home/idbamb1/openlink/lib/pgr7_mt_lt.so Database = ReadOnly = No NoAutoCommit = No NoLoginBox = No FetchBufferSize = 60 Peter
