CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

ODBC shows #Deleted for records in linked table when special characters like "Ü" in primary key

edited Mar 8, 2019 4:03AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered

When connecting to an Oracle JD Edwards database (oracle database 12.1.0.1) with MsAccess 2016 using Oracle ODBC windows X64 instant client 12.2.0.1.0-2 I am not able to view records when there are special characters used like "Ö" or "Ä" in a string field when that field is part of the primary key of the table. For example use table F4108.IOLOTN (but is effective for all tables)

With the same settings (MS Access, ODBC etc.)  I am however able to insert data with the same special characters to that table where a string field is part of the primary key of a table and I see with the JDE application the data correct and also with SQL developer or UTB.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center