Problems with Oracle connector

Hello and good morning!

I am running the 10/25/11 nightly build of LightSpeed 4 on Visual Studio 2010 SP1, trying to access an Oracle 11g database, version 11.2.0.2...

I was unable to connect at all until I found this post about binding redirect: http://www.mindscapehq.com/forums/thread/1590 - saved my day!

Once I added the binding redirect stuff to app.config I can apparently read from the database, but I am getting the following Oracle errors:

{"ORA-06550: line 112, column 14:\n
PLS-00302: component 'ORDERSID' must be declared\n
ORA-06550: line 112, column 3:\n
PL/SQL: ORA-00904: \"ORD_DETAIL\".\"ORDERSID\": invalid identifier\n
ORA-06550: line 74, column 1:\n
PL/SQL: SQL Statement ignored\n
ORA-06550: line 384, column 34:\n
PLS-00302: component 'ORDERSID' must be declared\n
ORA-06550: line 384, column 23:\n
PL/SQL: ORA-00904: \"ORD_DETAIL\".\"ORDERSID\": invalid identifier\n
ORA-06550: line 163, column 1:\n
PL/SQL: SQL Statement ignored"}

(Sorry about the formatting, I can't seem to get the EOL to work for some reason)

There is a field called ORDERS_ID (notice the underscore) that is a foreign key to the Orders table. Your auto-generated code seems to have done a great job of keeping the underscores in important places, that is, where there was a specific reference and it was not a key used in a relationship. However, in this case it seems to have mangled the name so it's unrecognizable by removing the underscore.

What can I do to get around this? I can post whatever you need to help figure it out, but this pretty well stops me dead at the moment.

Thanks for any help you can provide, Dave

It sounds like your OrdersId field is being mapped to an OrdersId column instead of the desired ORDERS_ID column.

To address this, select the Orders association and set the Column Name to ORDERS_ID.

That worked! Thanks for the help...

Dave