[Pgsql-ayuda] PowerBuilder 9.0/PostgreSQL 7.3.3

Sandrigo Lezcano alkafes@yahoo.com
Tue, 1 Jul 2003 16:05:13 -0500 (CDT)


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