Different Query results in Sql *Plus and Oracle ODBC 32Bit Test

Hi

I am new to programming in Oracle and I have a strange problem.

From Vb6 (IIS application) I am connecting to Oracle 8 Using Oracle OLE Provider..

Code:

Conn.Open "Provider = OraOLEDB.Oracle;Data Source = Test;User ID=abc;Password=xxx;PLSQLRSet=1"

'Table owner: vcg

Sql = "select a.job_title, b.skill_key, c.skill_value, d.value from vcg.t_job_order a, vcg.t_job_order_skill b, vcg.t_skill c, vcg.t_employment_type d
where a.Primary_key = b.job_order_key

and b.skill_key = c.primary_key
and a.employment_type_key = d.primary_key
and a.office_key = 'NMC'
and a.open_flag = 'Y' and a.active_flag = 'A'"

RecordSet.Open Sql, Conn, adOpenStatic

Problem:

When run this Sql from Sql *Plus (version 8.1.6.0.0) and Oracle ODBC 32Bit Test (version 2.5.3.1.0)
they give different results! The field values as well as the number of rows returned are all different.
When run the above from the Vb, get the same result as the Oracle ODBC 32Bit Test.
Sql *Plus results seem consistent with the query, whereas Oracle ODBC 32Bit Test results seem wrong.

Please Help!
Thanks for any suggestions.

Mahua. Received on Wed Mar 20 2002 - 11:03:36 CST