DateTime format

[Former Member]

Hello,

some time ago we updated our MaxDb Version from 7.6.5.0 to 7.7.6.9. Now we got more and more workstations, which are using the new ODBC-Driver. These workstations are not working correctly. We can not insert or update any DateTime field, because we get an error message.

ERROR [[S1000]][[SAP DB]][[SDBODBC DLL]][[MaxDB]] General error;-10802 Invalid numeric value for parameter / column (X)

An other error message is

Query Engine Error: [[S1000]][[SAP DB]][[SDBODBC DLL]][[MaxDB]] General error;-10411 Illegal DATE value for parameter/column (X)

I changed the DateTime-Parameter to any available option. No one of this options works.

We use our own frontend to connect to the database. In which format I have to send DateTime-parameters to the database?

Edited by: Sebastian Wegener on Sep 18, 2009 9:53 AM

[TTK]

Hello Sebastian

Can you please provide a trace of the problem?

This can be done with ODBC drivers 77 or higher with:

odbc_cons trace api on

odbc_cons trace sql on

<run your application>

odbc_cons trace off

odbc_cons s a

shows, where the trace files are written and which names they get.

As work around I recommend using the MaxDB 76 ODBC-driver.

Kind regards Thomas