Ingres ODBC driver problem

[adrianroy]

Hello
I'm trying to connect to an Ingres stored procedure but I keep getting the following message:
S1000[CA][Ingres ODBC driver][Ingres]Invalid literal parameter

Some points to note (!):
I can connect to tables successfully.
The parameter datatypes in the stored procedures aren't unusual ie just integers, chars. The names are valid, however do use underscores within the name (eg m_date etc)

I'm going to try a process of elimination of parameter datatypes to see if one of those have a problem with the Ingres ODBC driver.

Thanking you
Adrian

 

[malcolmt]

Adrian,

I am sorry I do not have an answer to the issue you raised but I am also facing some problems connecting Crystal Reports to Ingres 6.4 and IngresII databases.

I would appreciate any feed back that you or anyone else can offer in respect to:

What odbc drivers are you using? We have installed the latest read-only driver from the CA website. However this does not support any 6.4 databases.

Filtering on dates - What is the simplest way to filter for records that do not have a value in a date column? e.g. with convert nulls to default values turned on, selecting where date_column < 1/1/1990 does not return rows that do not have a value in that date_column.

Thank You & Regards,

Malcolm.