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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 SQL Stmt returns the incorrect value ? 3
Comparing a Month & Day Combination 2
Access Access 2007 Query Date 1
Turn Off Access Field Re-name? Calculation fields in query 2
VB sql statement 6
Access 2007 - SQL query assistance needed 2
convert columns to rows 2
New to Access, need some help with a query 1

Back
Top