[Pgsql-ayuda] PowerBuilder 9.0/PostgreSQL 7.3.3

From: Sandrigo Lezcano <alkafes(at)yahoo(dot)com>
To: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: [Pgsql-ayuda] PowerBuilder 9.0/PostgreSQL 7.3.3
Date: 2003-07-01 21:05:13
Message-ID: 20030701210513.3916.qmail@web20004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

estoy en esto del Sybase/PostgreSQL
conectando el PowerBuilder 6.5 al pg
me da el sgte. error (ver abajo..), buscando
info. por ese tipo de error, encontre algunas
referencias que no me ayudan mucho....

lo cierto es que com el pg7.1.3 (linux)FUNCIONA!!!
se conecta, actualiza las tablas... exelente!!
tb con el 7.2.1 (la beta4 para Windows) OK
tb probe con el PowerBuilder 7.0 y el PB9.0

pero con el 7.3.3 lin ... NADA!!
(o sea me da el error)
con el ms-access OK (al 733)
con el ms-visualfoxpro OK (al 733)

el sentido comun, lo que me dice es
talvez sea que este tomando las
tablas como : squema.tabla
y no como: owner.tabla

pense en el ODBCdriver ...pero
hice la actualizacion completa del 733..

alguna idea... opinion...
sospecha...

--ERROR--------------------
Data pipeline
SQLSTATE = S1000
blank
---------------------------

REFs. encontradas buscando ('SQLSTATE S1000')
en los manuales del Sybase.

Database server already running
-------------------------------------------------------
Item Value
SQLCODE -96
Constant SQLE_ENGINE_ALREADY_RUNNING
SQLSTATE 08W23
Sybase error code 7950
ODBC 2 State S1000
ODBC 3 State HY000

Probable cause
The database server was not able to start on a
db_start_engine call because it was already running.
-------------------------------------------------------

Invalid escape character '%1'
-------------------------------------------------------
Item Value
SQLCODE -629
Constant SQLE_INVALID_ESCAPE_CHAR
SQLSTATE 22019
Sybase error code 7707
ODBC 2 State S1000
ODBC 3 State 22019

Probable cause
The escape character string length must be exactly
one.
-------------------------------------------------------

Invalid escape sequence '%1'
-------------------------------------------------------
Item Value
SQLCODE -630
Constant SQLE_INVALID_ESCAPE_SEQ
SQLSTATE 22025
Sybase error code 7705
ODBC 2 State S1000
ODBC 3 State 22025
Parameter 1 The escaped character

Probable cause
A LIKE pattern contains an invalid use of the escape
character. The escape character may only precede the
special characters '%', '_', '[', and the escape
character itself.
-------------------------------------------------------

WITH CHECK OPTION violated for insert/update on base
table '%1'
-------------------------------------------------------
Item Value
SQLCODE -632
Constant SQLE_WITH_CHECK_OPTION_VIOLATION
SQLSTATE 44000
Sybase error code 550
ODBC 2 State S1000
ODBC 3 State 44000
Parameter 1 Name of the base table being
updated.

Probable cause
You attempted an insert or update operation on the
indicated base table through a view (possibly nested).

However, one or more values in the modified row(s)
triggered a WITH CHECK OPTION violation.
This violation occurs when a modified value causes
one or more rows to fall outside the range
of the view by making the view's WHERE clause
evaluate to FALSE or UNKNOWN for that row.
-------------------------------------------------------

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2003-07-01 21:05:52 Re: [Pgsql-ayuda] actualizar postgresql de 7.2.1 a 7.3.3
Previous Message Gunnar Wolf 2003-07-01 20:40:40 Re: [Pgsql-ayuda] Ejemplos plpgsql