Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Different Query results in Sql *Plus and Oracle ODBC 32Bit Test

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

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Thu, 21 Mar 2002 10:00:16 -0600
Message-ID: <0p0k9ucm5k99etaeod07f76kr4ns93hjhu@4ax.com>

Are both connections using the exact same user/password/<connection info> ... Is the ODBC entry configured to restrict data in any way ( uniqueness, etc) ?  

mahua_at_saisoft.com (Mahua) wrote:

>1. I am simply using a test sql for testing purpose...the final query
>will have variables.
>
>2. Oracle version :8.0.3.0.0 for windows NT. Sql *Plus(version
>8.1.6.0.0) .Oracle ODBC 32Bit Test (version 2.5.3.1.0)
>
>3. I tried with a simple query without any where conditions and joins:
>"Select value from vcg.T_EMPLOYMENT_TYPE"
>and it gave 4 rows in ODBC 32Bit Test and 5 rows in Sql *Plus.
>Results:
>ODBC Test Sql *Plus
>1.Contract Hourly 1.ContractHourly
>2.Perm 2.Perm
>3.Contract Salary 3.Contract Salary
>4. Reference Contact 4.Contract
> 5.Reference Contact
>
>Thanks
>Mahua.
>
>"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<Egbm8.80297$ZR2.35868_at_rwcrnsc52.ops.asp.att.net>...
>> 1. use bind variables. You are killing scalability with what you are doing.
>>
>> 2. What version of Oracle?
>> 3. Give examples of each (what's the output)
>> Jim
>> "Mahua" <mahua_at_saisoft.com> wrote in message
>> news:694ba138.0203200903.31eefa66_at_posting.google.com...
>> > 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.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Mar 21 2002 - 10:00:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US