VB6 nad Progress9.1D09 ODBC

Yahoo Archive
1
Yes, I do have ODBC kit for Vantage 6.1. I can connect to Vantage with
ODBC and it runs fine but when I tried to filter using
field "JobHead.StartDate" I got the error. It said "inconsistent type".
I did test with SQL-89 and it works fine but not SQL-92.

Is there something between VB6 and Progress SQL-92?

Thanks,


--- In vantage@yahoogroups.com, "peterlv2002" <peterlv2002@y...> wrote:
>
> Do you have the ODBC kit for Vantage 6.X? Without it the Vanatage
> database will not allow ODBC connectivity.
> --- In vantage@yahoogroups.com, "progress92000" <nvong@m...> wrote:
> >
> > I have a program written in VB6. It works fine with Vantage 5.1
> > (Progress 9.1C ODBC). Now I want to convert it to connect to
Vantage
> > 6.1 (Progress 9.1D09 ODBC) but there is a error "Inconsitent type
> > (7481)" when SQL statement compare the date.
> >
> > I saw an error code in the Progress Knoledge base regarding of this
> > error but I did update to the latest SP. and there error is no
vanished.
> >
> > Any one seen this error and what the fix for this?
> >
> > Thank you,
2
I have a program written in VB6. It works fine with Vantage 5.1
(Progress 9.1C ODBC). Now I want to convert it to connect to Vantage
6.1 (Progress 9.1D09 ODBC) but there is a error "Inconsitent type
(7481)" when SQL statement compare the date.

I saw an error code in the Progress Knoledge base regarding of this
error but I did update to the latest SP. and there error is no vanished.

Any one seen this error and what the fix for this?

Thank you,
3
Do you have the ODBC kit for Vantage 6.X? Without it the Vanatage
database will not allow ODBC connectivity.
--- In vantage@yahoogroups.com, "progress92000" <nvong@m...> wrote:
>
> I have a program written in VB6. It works fine with Vantage 5.1
> (Progress 9.1C ODBC). Now I want to convert it to connect to Vantage
> 6.1 (Progress 9.1D09 ODBC) but there is a error "Inconsitent type
> (7481)" when SQL statement compare the date.
>
> I saw an error code in the Progress Knoledge base regarding of this
> error but I did update to the latest SP. and there error is no vanished.
>
> Any one seen this error and what the fix for this?
>
> Thank you,