Sybase ASE ODBC driver ( version 3.50.00.10 ) and Crystal Reports 4.6 error 
Author Message
 Sybase ASE ODBC driver ( version 3.50.00.10 ) and Crystal Reports 4.6 error

Tch,

We have upgraded from database client Sybase System 11 ODBC driver (
version 3.11.00.17 ) to Sybase ASE ODBC driver ( version 3.50.00.10 ).

All systems work Ok with the new client, except the Crystal Reports
4.6. This systems access the Sybase databases via ODBC (Vb 6.0) or
native access (Delphi 5 and Powerbuilder 8).

When a CR report is fired, occurs the following error:

        20534 Error detected by database dll.

The ODBC trace gives:

( ... )

CRW32           3f8-118 ENTER SQLExecDirect
                HSTMT               014521F0
                UCHAR *             0x015538A0 [      -3] "SELECT
SamAlmoxarifados.CodAlmox, SamAlmoxarifados.NomeAlmox,
SamAlmoxarifados.NomeAlmoxarife, SamAlmoxarifados.Logradouro,
SamAlmoxarifados.Ramal, SamAlmoxarifados.Telefone,
SamAlmoxarifados.LocalEntrega, SamAlmoxarifados.UnidadeOrcamentaria,
SamAlmoxarifados.CentroCusto,
SamAlmoxarifados.ImprimeFichaMovimentacao,
SamAlmoxarifados.VersaoAplicativo, SapCentrosCusto18.Nome18,
v_ORGAO_SAM_UnidOrcam.Nome19, v_ORGAO_SAM.Nome19 FROM { oj
((DBSIG.dbo.SamAlmoxarifados SamAlmoxarifados INNER JOIN
DBSIG.dbo.SapCentrosCusto18 SapCentrosCusto18 ON
SamAlmoxarifados.CentroCusto = SapCentrosCusto18.Codigo18)  LEFT OUTER
JOIN ADMINI.dbo.v_ORGAO_SAM v_ORGAO_SAM ON
SamAlmoxarifados.LocalEntrega = v_ORGAO_SAM.Codigo19)  LEFT OUTER JOIN
ADMINI.dbo.v_ORGAO_SAM v_ORGAO_SAM_UnidOrcam ON
SamAlmoxarifados.UnidadeOrcamentaria = v_ORGAO_SAM_UnidOrcam.Codigo19}
ORDER BY SamAlmoxarifados.CodAlmox ASC\ 0"
                SDWORD                    -3

CRW32           3f8-118 EXIT  SQLExecDirect  with return code -1
(SQL_ERROR)
                HSTMT               014521F0
                UCHAR *             0x015538A0 [      -3] "SELECT
SamAlmoxarifados.CodAlmox, SamAlmoxarifados.NomeAlmox,
SamAlmoxarifados.NomeAlmoxarife, SamAlmoxarifados.Logradouro,
SamAlmoxarifados.Ramal, SamAlmoxarifados.Telefone,
SamAlmoxarifados.LocalEntrega, SamAlmoxarifados.UnidadeOrcamentaria,
SamAlmoxarifados.CentroCusto,
SamAlmoxarifados.ImprimeFichaMovimentacao,
SamAlmoxarifados.VersaoAplicativo, SapCentrosCusto18.Nome18,
v_ORGAO_SAM_UnidOrcam.Nome19, v_ORGAO_SAM.Nome19 FROM { oj
((DBSIG.dbo.SamAlmoxarifados SamAlmoxarifados INNER JOIN
DBSIG.dbo.SapCentrosCusto18 SapCentrosCusto18 ON
SamAlmoxarifados.CentroCusto = SapCentrosCusto18.Codigo18)  LEFT OUTER
JOIN ADMINI.dbo.v_ORGAO_SAM v_ORGAO_SAM ON
SamAlmoxarifados.LocalEntrega = v_ORGAO_SAM.Codigo19)  LEFT OUTER JOIN
ADMINI.dbo.v_ORGAO_SAM v_ORGAO_SAM_UnidOrcam ON
SamAlmoxarifados.UnidadeOrcamentaria = v_ORGAO_SAM_UnidOrcam.Codigo19}
ORDER BY SamAlmoxarifados.CodAlmox ASC\ 0"
                SDWORD                    -3

                DIAG [37000] [SYBASE][ODBC Sybase driver][SQL Server]Incorrect
syntax near ','.
 (102)

CRW32           3f8-118 ENTER SQLErrorW
                HENV                014518E0
                HDBC                01451A28
                HSTMT               014521F0
                WCHAR *             0x0006DE58 (NYI)
                SDWORD *            0x0006DEA0
                WCHAR *             0x0006DA58
                SWORD                      242
                SWORD *             0x0006DE9E

CRW32           3f8-118 EXIT  SQLErrorW  with return code 0
(SQL_SUCCESS)
                HENV                014518E0
                HDBC                01451A28
                HSTMT               014521F0
                WCHAR *             0x0006DE58 (NYI)
                SDWORD *            0x0006DEA0 (102)
                WCHAR *             0x0006DA58 [      67] "[SYBASE][ODBC Sybase
driver][SQL "
                SWORD                      242
                SWORD *             0x0006DE9E (67)

CRW32           3f8-118 ENTER SQLFreeHandle
                SQLSMALLINT                  3 <SQL_HANDLE_STMT>
                SQLHANDLE           014521F0

CRW32           3f8-118 EXIT  SQLFreeHandle  with return code 0
(SQL_SUCCESS)
                SQLSMALLINT                  3 <SQL_HANDLE_STMT>
                SQLHANDLE           014521F0

At the Crystal Report enviroment I can log on ODBC databases and
browser their fields, but I can't preview the reports. The same error
occurs.

I have looked for something like this at groups, but I havent found
any reference.

Can someone help me?

Ricardo Vieira

CPD da UFRGS
Endere?o: Rua Ramiro Barcelos Nro 2574 Porto Alegre CEP 90035-003 RS
BR
Telefone: (02151) 3316-5307 (+5551-33165307)
Fax: (02151) 3331-1215 (+5551-33311215)



Mon, 22 Nov 2004 23:50:48 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. crystal reports control version 4.6 question

2. Drivers to access Sybase System 10

3. Crystal Report 4.6 in Crystal Report 6.0

4. Emailing/Package&Deployment question...2/10/00

5. Installing Sybase 10 ODBC for windows under WIN95

6. win95, vb4 pro 32bit, sybase 10, intersolv odbc, addchunk (image blobs)

7. VB, ODBC, Sybase System 10, and Dynamic (real) SQL

8. vb4 RDO, intersolv odbc, and Sybase system 10

9. VB 4.0 and the 32-bit ODBC for Sybase System 10

10. VB->ODBC->Sybase 10 on NetWare ?

11. VB 4.0 and the 32-bit ODBC for Sybase System 10

12. Sybase system 10, ODBC, RDO, VB5

 

 
Powered by phpBB® Forum Software