Collation Problem Using Openquery to insert record to Oracle

Hi,
I am trying to insert a record into an Oracle 9.2 instance from Microsoft's
SQL Server 2000 using openquery, it is really slow, someone knows if it has
to do with differences between SQL Collation setting and Oracle's NLS_SORT,
my current setings are:
SQL: SQL_Latin1_General_CP1_CI_AS
Oracle NLS_SORT: Binary
I configured the Linked server with the Use Remote Collation option and left
the collation name blank.
Thanks a lot!!
IgnacioHi
You don't say how the oracle server is linked and which drivers/versions you
are using.
Are you getting any error messages?
What are you doing with returned data?
John
"i-DLT" wrote:

> Hi,
> I am trying to insert a record into an Oracle 9.2 instance from Microsoft'
s
> SQL Server 2000 using openquery, it is really slow, someone knows if it ha
s
> to do with differences between SQL Collation setting and Oracle's NLS_SORT
,
> my current setings are:
> SQL: SQL_Latin1_General_CP1_CI_AS
> Oracle NLS_SORT: Binary
> I configured the Linked server with the Use Remote Collation option and le
ft
> the collation name blank.
> Thanks a lot!!
> Ignacio