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)
