RE: :ODBC::st execute failed: [unixODBC]ERROR: crossed

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