I think you would be wise to ask Netezza SQL who wrote the ODBC driver as they should be able to tell you what the error means. This is not a driver I know.
Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com On Tue, 2006-09-05 at 12:29 -0700, Loo, Peter # PHX wrote: > 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 > >
