[Firebird-odbc-devel] PowerBuilder 7.x and 8.x

[Sam W. <hi...@ho...>]

We are trying to access Interbase using the ODBC on the Enterprise
Edition.

We successfully connect and use with the Easysoft version but not the
firebird version. We have errors with the Database Painter that says

(26a0870):
DBPARM=ConnectString='DSN=xpfin70_fb;UID=;PWD=',ConnectOption='SQL_OPT_TRACE,SQL_OPT_TRACE_ON;SQL_OPT_TRACEFILE,C:\SQL.LOG'
(1211 MilliSeconds)
(26a0870): TABLE LIST: (10 MilliSeconds)
(26a0870): COLUMNS INFORMATION: TABLE=amx_branch_table OWNER=sysdba (10
MilliSeconds)
(26a0870):
 Error 999 (rc -1) : Table "amx_branch_table" has no columns, possible
invalid table format.


When we execute Stored Procedure using the FireBird
CREATE PROCEDURE DW_TEST
RETURNS (
LS_CODE VARCHAR(5),
LS_COMPANY_NAME VARCHAR(25)
)
AS
BEGIN
FOR SELECT CODE,NAME
FROM AMX_COMPANY_TABLE
INTO :LS_CODE,:LS_COMPANY_NAME
DO
SUSPEND;
END ^

it crashes with the following log.
(26a0870): DIALOG CONNECT TO TRACE ODBC:
(26a0870): USERID=
(26a0870):
DBPARM=ConnectString='DSN=xpfin70_fb;UID=;PWD=',ConnectOption='SQL_OPT_TRACE,SQL_OPT_TRACE_ON;SQL_OPT_TRACEFILE,C:\SQL.LOG'
(1262 MilliSeconds)
(26a0870): PROCEDURE PREPARE:
(26a0870): execute .DW_TEST;0  (10 MilliSeconds)
(26a0870): BIND SELECT OUTPUT BUFFER (DataWindow): (0 MilliSeconds)
(26a0870): ,len=7,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(26a0870): ,len=27,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(26a0870): EXECUTE: (0 MilliSeconds)
(26a0870): FETCH NEXT:



With the Easysoft, it runs without problem and the trace as follows :
(26a0870): DIALOG CONNECT TO TRACE ODBC:
(26a0870): USERID=
(26a0870): DBPARM=ConnectString='DSN=xpfin70_es;UID=;PWD=',DisableBind=1
(1132 MilliSeconds)
(26a0870): PROCEDURE PREPARE:
(26a0870): execute .DW_TEST;0  (0 MilliSeconds)
(26a0870): BIND SELECT OUTPUT BUFFER (DataWindow): (0 MilliSeconds)
(26a0870): ,len=7,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(26a0870): ,len=27,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(26a0870): EXECUTE: (0 MilliSeconds)
(26a0870): FETCH NEXT: (0 MilliSeconds)
(26a0870):  COLUMN=C1 COLUMN=C1 N
(26a0870): FETCH NEXT: (0 MilliSeconds)
(26a0870):  COLUMN=C2 COLUMN=C2 Name
(26a0870): FETCH NEXT: (0 MilliSeconds)
(26a0870):
 Error 1 (rc 100)
(26a0870): CANCEL: (0 MilliSeconds)
(26a0870): ROLLBACK: (0 MilliSeconds)
(26a0870): DISCONNECT: (0 MilliSeconds)
(26a0870): SHUTDOWN DATABASE INTERFACE: (0 MilliSeconds)


The above trace are capture within PowerBuilder as ODBC trace log shows
nothing when crashed.

Thanks

Sam