Home » SQL & PL/SQL » SQL & PL/SQL » VB6 and oracle connection
VB6 and oracle connection [message #228593] Tue, 03 April 2007 07:50 Go to next message
Cummi
Messages: 2
Registered: April 2007
Junior Member
I need your help
I'm using for connection from VB6 application to Oracle 9i OraOLEDB.Oracle.1 provider

From VB6 application this select statement "SELECT (CASE WHEN BB_FAKTURA_KOPF.STORNODATUM IS NULL THEN ' ' ELSE 'S' END) FROM BB_FAKTURA_KOPF"
returns error: ORA-00907: missing right parenthesis
But right on oracle (SQLPlus Worksheet) this statement work's correctly. What's an reason?

[Updated on: Tue, 03 April 2007 09:26]

Report message to a moderator

Re: VB6 and oracle connection [message #228602 is a reply to message #228593] Tue, 03 April 2007 08:05 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

The error you are reciving speaks for itself...the statement you are executing from vb doesnt look what you think it looks like obviously.

Check you'r vb code and verify that the statement has been constructed correctly before executing it.
Re: VB6 and oracle connection [message #228631 is a reply to message #228602] Tue, 03 April 2007 09:26 Go to previous message
Cummi
Messages: 2
Registered: April 2007
Junior Member
The statement is constructed IN VB6 correctly. I checked it. If I write this select on this way in VB6 it's working: "SELECT * FROM (SELECT (CASE WHEN BB_FAKTURA_KOPF.STORNODATUM IS NULL THEN ' ' ELSE 'S' END) FROM BB_FAKTURA_KOPF) A" But it's not solution for me. It looks that's really problem by connection Oracle 9i OraOLEDB.Oracle.1 provider, but I'm not sure. Pls help me.
Previous Topic: Independent autonomous transactions
Next Topic: How to get minimum value in a single SQL from 3 tables having same structure and different values
Goto Forum:
  


Current Time: Fri Dec 09 13:37:48 CST 2016

Total time taken to generate the page: 0.08831 seconds