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

I have solved the problem. Yes, the ODBC configuration for DSN connection was wrong.

Thanks everyone for your suggestions.
Mahua.

TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<0p0k9ucm5k99etaeod07f76kr4ns93hjhu_at_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 - 14:46:51 CST