MySQL Forums
Forum List  »  Oracle

ODBC setting
Posted by: cybe2000
Date: May 05, 2005 10:04PM

Please help....

I have a problem on my migration from Oracle to MySQL project..
On Oracle Developer 6 Report Builder, i use query :

SELECT NUM_OF_TRX, DATE_OF_TRX, DESC_OF_TRANS, ACCOUNT, VALUE_DB,
VALUE_CR, DATE_OF_ENTRY, USER_ENTRY
FROM JOURNAL
WHERE DATE_OF_TRX BETWEEN :TGL1 AND :TGL2 AND
(:PC is null or (JOURNAL.PC_CODE = :PC)) AND
(:KP is null or (JOURNAL.KP_CODE = :KP)) AND
(:BG is null or (JOURNAL.CODE_BAGIAN = :BG)) AND
(:SC is null or (JOURNAL.SECTION_CODE = :SC))
ORDER BY DATE_OF_TRX

note:
expresion with ":" is parameter input

i put that query on SQL Query at Data Model on Report Buillder. When I compiled the script, its doesn't have any error...... (compiled successfully), but when I run the application, it come out with this error message :

OCA-30010 : Message 3000 not found; no message file for
product=oca60,facility=UB==>SELECT NUM_OF_TRX,
DATE_OF_TRX, DESC_OF_TRANS, ACCOUNT, VALUE_DB,

could some body help me...... :((
when i execute the query on sql editor, it's running well....
and when the script at Oracle Developer compiled, its successfull....
but when i ran the application, its came out with that error...

is it my ODBC setting wrong... ???
could any body know about ODBC 3.51 setting (flags 1, flags 2, flags 3... etc) for Oracle Developer ???
I use MyODBC 3.51, Oracle Developer6, EMS MySQL Manager 3, and MySQL 5.0.3
previous Database : Oracle 9i

thx

Options: ReplyQuote


Subject
Views
Written By
Posted
ODBC setting
3381
May 05, 2005 10:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.