[Info-Ingres] Visual Studio 2005 and Ingres ODBC connector

[flip+ at andrew.SeeEmmYou.EeeDeeYou]

We're having an issue with the ingres ODBC connector when accessing it
with Visual Studio. It seems to truncate the last character of values
passed to it from form controls generated in Visual Studio.

eg:
If you have a table that is populated on a value '1234', it will
instead populate on '123'.  We've confirmed this behavior by getting
"desired" results by searching instead for '1234 '.

We're running Ingres 3.0 ODBC Driver Version 3.5 with ingres 9.0.4
Windows XP, Visual Studio 2005


To recreate my situation, try this:
Create table myvalues (value varchar(10) not null with default);
insert into myvalues (value) values ('one');
insert into myvalues (value) values ('two');
insert into myvalues (value) values ('three');
insert into myvalues (value) values ('four');

In Visual Studio 2005:
Add a new dataset to the project.
Create a new tableadapter to the values table.
       Use the querybuilder to use the following select:
       SELECT     *
       FROM         myVALUES
       WHERE     ("value" = ?)
   Now hit the execute query button.
     It prompts you for value. Type: "one"
       (the query returns no rows)
   Now hit the execute query button.
     It prompts you for value. Type: "one "
       (the query returns 1 row)

Has anyone else seen this?
Is there a fix?
Am I missing some key concept?


Thanks!
-- 
flip
Just on the border of your waking mind, There lies - Another time,
 Where darkness & light - are one. And as you tread the halls of sanity,
  You feel so glad to be, Unable to go beyond.  ELO - Twilight Prologue
In my email replace SeeEmmYou.EeeDeeYou with CMU.EDU