Re: Need To Find A Report Writer.......
Posted in 1997
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET
Sorry but I dont think you will have much luck. It appears as though Informix doesn't support the use of the ODBC API SQLProcedureColumns which returns the number and type of input/output parameters and result set columns. Using the SCO ODBC driver, the number of input parameters in a stored proc is returned but not thier type and this is where Crystal has its problem. The OpenLink ODBC driver doesn't find any input parametes at all. The only way to use stored procs that use parameters in an ODBC report writers is to use SQL Pass-through and dynamically modifying the SQL to include you parameter. Access can do this, so can Info Reports from Platinum and there are probably others that can also. Dan Collins <dcollins@vsol.com> wrote in article <5datnu$1mb@cssun.mathcs.emory.edu>... > ...which can access Informix stored procedures. We tried Crystal Writer, but that function is apparently not supported. > > Can you help ? ? ? > > Thanks, in advance ! > > Dano > >