I am attempting to insert records into a sybase ASE 12.5.3
server from MSSQL 2000 as identified below.

INSERT INTO gasybprod001.lancer.dbo.stock_idx_tmp
(
[stock_cusip],
[cusip_suffix],
[cusip_check_digit],
[Last_mnt_date_time],
[Last_mnt_opid],
[Create_date],
[DML_Flag],
[stock_idx_sponsor],
[stock_idx_name],
[issue_status_code],
[issue_type_code],
[margin_flag],
[option_flag]
)
SELECT
g.stock_cusip,
g.cusip_suffix,
g.cusip_check_digit,
g.Last_mnt_date_time,
g.Last_mnt_opid,
g.Create_date,
g.DML_Flag,
g.stock_idx_sponsor,
g.stock_idx_name,
g.issue_status_code,
g.issue_type_code,
g.margin_flag,
g.option_flag

FROM gaprod.lancer.dbo.stock_idx g
left outer join
gasybprod001.lancer.dbo.stock_idx_tmp s
on (
s.stock_cusip = g.stock_cusip and
s.cusip_suffix = g.cusip_suffix and
s.cusip_check_digit = g.cusip_check_digit
)
WHERE
s.stock_cusip is null

I get the following error.

[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: Transaction cannot have
multiple recordsets with this cursor type. Change the cursor
type, commit the transaction, or close one of the
recordsets.]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
IRowsetChange::InsertRow returned 0x80004005: ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.

As you can see I'm not using a cursor so i have no idea how
to resolve this issue... any help would be appreciated.
Thanks,
-Tim

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote

Hi Tim,

Which OLE DB Provider are you using?
Not much testing has been done with MSSQL 2000 but it should work
for the most part. Most of the focus has been with using MS SQL 2005.

Is this with a linked Server? Using ASE OLE DB 15.0? If so what version?
Sounds like an older version.

-Paul

<Tim> wrote