Access 2007 new Odbcjt32.dll not fully compatible ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I experienced a change of behavior of the new OBDC dll for JET engine
included in Windows VISTA (ODBCJT32.dll version 6.00.xxxx) or ACCESS 2007
trial (ACEODBC.dll version 12.00.xxxx).
Queries like "Select 'hello' as Field1 from ...", or "Select Field2 + ' - '
+ Field3 as Field1 from Table1" returns a Memo Field for Field1 (Field2 and
Field3 are Text Field).
In previous versions of ODBC Jet (4.0 or less), Field1 returned as a Text
Field.

It's a serious pb for me because my program, build with Delphi, interfaces
via ODBC with both ACCESS and SQL Server databases (for deployment reason),
so I expect the same behavior for ODBC dlls.
(NB : ODBC for SQL Server (version 7 to 2005) has always returned a Text
Field for these queries).

Thank's for your help
 
Back
Top