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 
> 
> 


Reply via email to