is this a Bug in SQL Server 2000 ?

Here are 2 Linked server creation scripts
EXEC sp_addlinkedserver
@.server='baanb',
@.srvproduct='Oracle in OraHome92',
@.provider='MSDASQL',
@.datasrc='baan'
go
exec sp_addlinkedsrvlogin 'baanb',false,null,'pass','pass'
go
EXEC sp_addlinkedserver
@.server='baan',
@.srvproduct='Oracle in OraHome92',
@.provider=MSDAORA,
@.datasrc='baan'
go
exec sp_addlinkedsrvlogin 'baan',false,null,'pass','pass'
go
When i run these Queries
select count(*) from openquery(baanb,'select t$dsca from baan.ttiitm001400')
select count(*) from openquery(baan,'select t$dsca from baan.ttiitm001400')
I got (33732) rows from baanb
and (33831) rows from baan.
They r the same Oracle Server/same database/ same Tables but different Row
Counts Always with 99 rows difference.
But When i add this linked servers In SQL server 7.0 and run the same
queries. I got the same row count.
Any Explanations ?
Is It a bug ?
> Here are 2 Linked server creation scripts
> EXEC sp_addlinkedserver
> @.server='baanb',
> @.srvproduct='Oracle in OraHome92',
> @.provider='MSDASQL',
> @.datasrc='baan'
> go
> exec sp_addlinkedsrvlogin 'baanb',false,null,'pass','pass'
> go
> EXEC sp_addlinkedserver
> @.server='baan',
> @.srvproduct='Oracle in OraHome92',
> @.provider=MSDAORA,
> @.datasrc='baan'
>
> go
> exec sp_addlinkedsrvlogin 'baan',false,null,'pass','pass'
> go
>
> When i run these Queries
> select count(*) from openquery(baanb,'select t$dsca from
baan.ttiitm001400')
> select count(*) from openquery(baan,'select t$dsca from
baan.ttiitm001400')
> I got (33732) rows from baanb
> and (33831) rows from baan.
> They r the same Oracle Server/same database/ same Tables but different Row
> Counts Always with 99 rows difference.
> But When i add this linked servers In SQL server 7.0 and run the same
> queries. I got the same row count.
>
> Any Explanations ?
> Is It a bug ?
>
It could be a bug with a client driver. On the first one you're using an
Oracle ODBC driver in conjunction with the Microsoft OLE DB Provider for
ODBC. On the second one, you're using the Microsoft OLE DB Provider for
Oracle.
Which linked server returned the correct result? Have you tried using a
third-party OLE DB provider for Oracle and compare the results?
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.