Microsoft Access export table cuts off last character

[silentbutdeadly21]

The export table feature in Microsoft Access always cuts off the last character in a text column when the access table is exported to Ingres ODBC database. How do I prevent this from happening?

I'm not sure if (a) I'm doing something wrong, or (b) there is a bug in Access, or (c) there is a bug in Ingres ODBC driver.

Step to Repeat Issue:
1. Start MS Access 2007
2. Create a new table, name it "access_test"
3. Switch to table design view
a. table should have 1 column, name it "test_col"
b. test_col should have a Data Type of Text
c. test_col should have a field size of 10
4. Switch to table entry view
5. Enter "test123" into the test_col field
6. Save the table
7. Close the "access_test" table
8. From the list of tables pane (usually on the left), right click "access_test"
9. Choose Export, then ODBC Database
10. Click OK to confirm the table name
11. From the Machine Data Source tab, choose an Ingres data source (must already be setup from windows control panel)
12. Click "Close" to finish the export
13. Start Ingres and go to the access_test table
14. select all records
15. notice the the value is now "test12". The "3" was chopped off

[loera01]

Hello silentbutdeadly21,

This bug, or a least a version of it, was reported a couple years ago as bug 115908, and occurred in Ingres 9.0 (Ingres 2006 as it was known at that time).

I have heard no reports of this problem since the fix was submitted in 2006, and was unable to reproduce the problem in Ingres 9.1 or Ingres 9.2, based you your instructions.

What release of Ingres are you using?

Regards,
Ralph Loen

[silentbutdeadly21]

I'm using Ingres 2006 [II 9.0.4 (int.w32/105)]

I'm using Ingres on Windows basically as a pass-through to connect to production database on Unix [version II 9.0.4 (su9.us5/105)]. Is there a need to keep the Windows and Unix installations at the same version? Or could I use a newer version on Windows?

[daryl.monge]

No need for them to be the same, but you should probably upgrade to 9.1 to pick up the bug fixes you need.

[loera01]

I recommend downloading the community version of Ingres 9.1 or the 9.2 beta for Windows. If you have a support contract, you can also receive the latest ODBC patch, which can keep you current with all of the most recent fixes.

Regards,
Ralph Loen