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