Can't Capture Identity in ODBC Connection to MS SQL Server 2014

[glenn_barber]

We have two environments we are working in.

Our in-house development environment is SQL Server 2012 Standard, another is 2014 Enterprise.  We have a 64 bit Classic 12.6 PB app.

On the 2012 version we have no problems getting an identity for a table populated in the datawindow after an update.

On the other (with the same client ODBC Driver) we can seem to get the value populated.

Any suggestions as to what the problem might be?

Thanks

[Former Member]

Hi Glenn,
Are you using the odbcad32.exe under Windows\System32 or Windows\SysWOW64?  The System32 is the 64-bit administrator and the SysWOW64 is the 32-bit.

Ted Zimmerman