RDB Cube entry fails

Previous Member

Hi together,

 

i just created a table on a oracle database:

 

USERNAME (VARCHAR2(50))

KEYWORD (VARCHAR2(100))

 

I also created an RDB cube to edit the KEYWORD in board using a dataview (data entry allowed).

 

The changed KEYWORD wont be saved in the database and i just get the following error message in the SQL Log:

 

The object of type BoardDBConnection.BoardDbConnectionWrapper cannot be converted to type System.Data.Odbc.OdbcConnection.

 

Any hints or tips?

 

THX

Paul

Björn Reuber

Hi,

 

some questions from my side:

- is Username defined as PrimaryKey in your SQL table?

- is the connection configured as OleDB or ODBC, do you use Oralce as RDBMS

- is the text you are entering smaller than 100 Bytes (BOARD is using UTF)? Cause varchar2(100) holds 100 BYTES. A string which is 100 CHARACTERS in UTF8 may be MUCH larger then 4000 BYTES. It could be 4000 BYTES.

 

Regards

Björn